lukerees83
Board Regular
- Joined
- Mar 28, 2011
- Messages
- 59
I am currently working on multiple workbooks that contain data of train times and late departures over the course of several months. One workbook must contain 1 week of data, and each has 7 tabs for Mon-Sun. I am using Excel 2003.
At the end of each workbook I have a cell that contains the following formula to add up all the late departures that week:
=SUM(MONDAY:SUNDAY!AA15)
The above example is for a workbook entitled 'week 2', and I then want to copy and paste this formula into a new workbook entitled 'week 3' to calculate the same thing. However when I do so it gives the following:
=SUM('[Week 2.xls]MONDAY:SUNDAY'!AA15)
This does not calculate the figures from week 3 but simply pastes in week 2's data.
How can I do a copy paste from one workbook to another so that it just copies the formula only and not the source workbook's name? I can't simply copy =SUM(MONDAY:SUNDAY!AA15) to the clipboard and paste into across workbooks one-by-one as there are too many.
At the end of each workbook I have a cell that contains the following formula to add up all the late departures that week:
=SUM(MONDAY:SUNDAY!AA15)
The above example is for a workbook entitled 'week 2', and I then want to copy and paste this formula into a new workbook entitled 'week 3' to calculate the same thing. However when I do so it gives the following:
=SUM('[Week 2.xls]MONDAY:SUNDAY'!AA15)
This does not calculate the figures from week 3 but simply pastes in week 2's data.
How can I do a copy paste from one workbook to another so that it just copies the formula only and not the source workbook's name? I can't simply copy =SUM(MONDAY:SUNDAY!AA15) to the clipboard and paste into across workbooks one-by-one as there are too many.
