+ Reply to Thread
Results 1 to 2 of 2

Repeat formula in column H until the last row with data in column G

Hybrid View

matteobsuetti Repeat formula in column H... 08-23-2015, 07:31 AM
Blokeman Re: Repeat formula in column... 08-23-2015, 08:36 AM
  1. #1
    Registered User
    Join Date
    03-18-2015
    Location
    sydney
    MS-Off Ver
    2013
    Posts
    15

    Repeat formula in column H until the last row with data in column G

    Hi everyone!

    I am trying to automate an excel file for stock trading. What I have done so far is that I created a macro that let me select the name of the stock, the start date, the end date, the frequency of the data and fetches all the data from yahoo finance.

    However, I would like to automate also the next steps, but I am struggling to find a solution.

    In column H I have a formula to calculate the returns for the day and I would like this formula to automatically get updated when the macro fetches data for a new stock, which might have a different time span and therefore more (or less) rows of data.

    I would really appreciate if someone has a solution for this!
    Thank you!

  2. #2
    Forum Contributor
    Join Date
    08-15-2012
    Location
    Australia
    MS-Off Ver
    Excel 2016
    Posts
    349

    Re: Repeat formula in column H until the last row with data in column G

    Cross-post;http://www.mrexcel.com/forum/excel-q...-column-g.html

    Read this;http://www.excelguru.ca/content.php?184
    Please click the * Add Reputation if this helps
    If solved remember to mark Thread as solved

    "I'm glad to help and this is not meant to sound smart, but either you have super-human vision to see all those controls cleared one by one with the code I posted, or your computer is really slow."

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 11-17-2014, 02:40 PM
  2. [SOLVED] Repeat Column of Data Down a Row Using a Formula
    By pookyman in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-10-2014, 11:56 AM
  3. [SOLVED] VBA to detect next empty cell in column and add formula, then repeat for next column, ...
    By Marijke in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-17-2013, 07:28 AM
  4. Formula to count how many numbers repeat in a column.
    By simonheller in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-07-2010, 06:43 PM
  5. Replies: 2
    Last Post: 07-10-2006, 03:29 AM
  6. [SOLVED] repeat a formula same column same number of rows apart
    By steveo in forum Excel General
    Replies: 1
    Last Post: 07-10-2006, 03:29 AM
  7. Replies: 1
    Last Post: 11-09-2005, 09:20 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1