In my workbook, I get live data across a few columns (through a data connection). This data changes every x minutes. Lets say that's in row 1.
Beneath this is a table exactly 300 rows deep. (e.g. rows 2 through row 301)
I want row 301 to show the most recent data from row 1, then when x minutes passes, the data in row 301 is pushed up to row 300... all the way up. Whatever was in row 2 "falls off the cliff" so to speak.
Is there a formula which can do this rather than a macro?
And, if it has to be a macro, can multiple macros run in the same workbook (perhaps if macro A is running, macro B waits until A is done)?
Thanks
Bookmarks