Hi there,
I want to save forex currency data into excel sheet. Forex refreshes the data every 15 seconds. How to save all data without overwrite the old one. Thanks in advance.
YJL
Hi there,
I want to save forex currency data into excel sheet. Forex refreshes the data every 15 seconds. How to save all data without overwrite the old one. Thanks in advance.
YJL
Hi
Record a macro, "open a new sheet" then copy forex and paste as value on new sheet, and save" then stop recording Macro.
Your Forex on the main sheet will still update , but the rest of the info on the new sheets will have it original value at the time of issue. Please notethat you have to run macro in order to copy and paste the data.
thiem
any idea to trigger macro automatically in a time series same as data update?
yjl
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks