Is this doable with Excel Macros: Retrieve data from Yahoo Finance Stock into Excel

If you already have a macro and spreadsheet that does this an easier way to help you would be to upload the worksheet with the macro and then someone could just edit it for you.

Well on the macro somewhere before it pastes the data onto the spreadsheet you could put this line below before it pastes the new data and hopefully it won't paste over the previous data.

Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove

Hi again Jesse,

I added my excel sheet and the whole point is when it presses the "Refresh button" it adds a new row under #1 (information that was previously in rw #2 and cells B2 - M2 gets copied to next row) then fills in "QLIK" once a day in A2 which will then populate new info and be eventually be moved the rest down which creates a historical tracking of the information about the stock.

Test 2.xlsm

Modify that line to say this instead so it moves all the cells you want down instead of just that one. Is that what your looking for?

Range("A2:M2").Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove

If this met your desired solution please click on the * to thank those whom have helped you by giving them rep and mark the thread as solved. Thanks.