Hi!
I was looking for solutions to my problem, but I couldn't find the right one.
What I have:
Sheet A
Cell A1 = "X"
X - is updated automatically every 30 mins.
What I want to achieve:
Copy data from Cell A1 every 30 min and past it into sheet B.
Each copy has to be in a new cell.
Ergo - creating a list in Sheet B by copying the data every 30 min from Cell A1 in sheet A.
AUTOMATICALLY of course- as long as the document is open, or, after pressing a button linked to macro for example.
What would be nice to have in addition:
Decide how many times this process will happen.
For example:
From cell A1 - A30(length of generated list), then stop...
or
From cell A1 - A30(length of generated list), then overwrite data from A1...
I would be very thankfull for you help!
With regarts!
neoz
Bookmarks