welshgasman
Well-known Member
- Joined
- May 25, 2013
- Messages
- 1,329
- Office Version
- 2007
- Platform
- Windows
Hi all,
I have a workbook GCD.xslm that holds monthly trips for the community car service I volunteer for.
At the end of each month I copy all that into a Master GCD.xlsm workbook.
All works fine, so I have a history of all trips and can answer any questions my controller might ask.
However I have noticed that it inserts the GCD.xlsm name and sometimes the whole path to that workbook, so if I were to change the path or have to rename the monthly workbook, it would all break.
I know I could just paste the values, I do that already for another sheet that goes to the treasurer, but I need the formula, as I do a some stats on the monthly trips for my own benefit.
So, I am asking, is there a way to copy the formulae, but omit the monthly sheet name. The sheets in each file are named the same, basically Master is just a larger version of the monthly sheet.
TIA
I have a workbook GCD.xslm that holds monthly trips for the community car service I volunteer for.
At the end of each month I copy all that into a Master GCD.xlsm workbook.
All works fine, so I have a history of all trips and can answer any questions my controller might ask.
However I have noticed that it inserts the GCD.xlsm name and sometimes the whole path to that workbook, so if I were to change the path or have to rename the monthly workbook, it would all break.
I know I could just paste the values, I do that already for another sheet that goes to the treasurer, but I need the formula, as I do a some stats on the monthly trips for my own benefit.
So, I am asking, is there a way to copy the formulae, but omit the monthly sheet name. The sheets in each file are named the same, basically Master is just a larger version of the monthly sheet.
TIA