Excel facing a problem with automation

Closed
Report
Posts
1
Registration date
Saturday May 3, 2014
Status
Member
Last seen
May 3, 2014
-
Posts
2847
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 13, 2022
-
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
2847
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 13, 2022
491
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
0