Excel facing a problem with automation [Closed]

Report
Posts
1
Registration date
Saturday May 3, 2014
Status
Member
Last seen
May 3, 2014
-
Posts
2675
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 5, 2020
-
Hi everyone,

I am currently facing a problem with automation of Ms. excel for my work and would highly appreciate any kind of help in this case.

I on a daily basis import data from internet on my excel sheet. The data is refreshed every day automatically. Now i want to copy paste last day's data on a separate excel sheet each day.

For instance i don't visit the excel file for three days all the information that would be imported should be stored on a separate excel sheets each day for 3 days..

I have no ideas of macros. If someone can help please.

1 reply

Posts
2675
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 5, 2020
448
Hi Umer1991,

Not sure if I can help, but you say you import data from the internet and put it in Excel. What kind of program or code do you use for that?

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!