Excel facing a problem with automation

Closed
Umer1991 Posts 1 Registration date Saturday 3 May 2014 Status Member Last seen 3 May 2014 - 3 May 2014 à 14:32
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 6 May 2014 à 11:57
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.
Related:

1 response

TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
6 May 2014 à 11:57
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