Previous Topic Next Topic

Excel Help

Closed
Angel - Feb 9, 2010 at 08:31 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 9, 2010 at 08:55 AM
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.
Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 9, 2010 at 08:55 AM
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
0

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses