Excel Help [Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I have two excel files in different path. Every week I have to copy the data from daily excel file to weekly excel file. Is there any formulae which can help me to avoid copy paste and automatically weekly file pull the data from daily excel file.

Thanks in advance.

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
767
one way would be to have formula in the 2nd worksheet that points to the primary workbook
and other way would be macro that you can run to pull the data into the second workbook

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!