Hi All,
I have an issue that had me stomped for quite a while now, and I would love to get some help on.
I have a running query that returns 1 day of data after refresh; I want to copy this data to another cell, so it is preserved, as a kind of database function.
How can I do that with a macro, based on date? i.e. IF I have data returning from 1-9-2014, it has to copy, paste value it to and adjacent cell, also marked 1-9-2014. Example attached. (there is a formula in sheet B, A1 to mark the 0-value)
I have tried to build a macro that takes the entire column and copy paste it, while skipping blanks; but as there are formula's in the source cells, they will not skip and overwrite the previous data.
So in short what I'm looking for:
• run query for 1-9-2014, paste data values to another cell
• run query for 2-9-2014, paste value to the cell directly under that one.
Thanks in advance for any help!
Bookmarks