Hope that someone can help . . .
If I have realtime stock data updating in cells A1 and B1 of a worksheet -how can I make excel automatically insert the changes in the cells below?
The range of inserted data could be A2:B65000, for example.
Cells A1 and B1 contain seperate data and do not necessarily change at the same time, and therefore, I would want the latest data from BOTH cells to be inserted into the next available row if/when either of the values in cells A1 or A2 changes - whereby when either A1 OR A2 changes, the data of BOTH A1 and A2 is automatically inserted into B1 and B2, etc.
Although I would be interested in any formula/VBA code - please keep in mind that I am NOT AT ALL familiar with VBA, and would require assistance with implementing that type of solution.
Many thanks,
Drexl
If I have realtime stock data updating in cells A1 and B1 of a worksheet -how can I make excel automatically insert the changes in the cells below?
The range of inserted data could be A2:B65000, for example.
Cells A1 and B1 contain seperate data and do not necessarily change at the same time, and therefore, I would want the latest data from BOTH cells to be inserted into the next available row if/when either of the values in cells A1 or A2 changes - whereby when either A1 OR A2 changes, the data of BOTH A1 and A2 is automatically inserted into B1 and B2, etc.
Although I would be interested in any formula/VBA code - please keep in mind that I am NOT AT ALL familiar with VBA, and would require assistance with implementing that type of solution.
Many thanks,
Drexl
