H Husssy Registered User Messages 48 24 Jan 2008 #1 Have 12 monthly sheets in an xcel file that i want to summarise in one sheet(sheet 13), tried to copy monthly totals from each sheet(these have formulae) to sheet 13 but coming up with error message,any help greatly appreciated.
Have 12 monthly sheets in an xcel file that i want to summarise in one sheet(sheet 13), tried to copy monthly totals from each sheet(these have formulae) to sheet 13 but coming up with error message,any help greatly appreciated.
M MsGinger Registered User Messages 330 24 Jan 2008 #2 I think you should be able to do this by using the following formula where you want each month total to go: =Sheet!CellNo e.g. if Sheet 1was called Jan and total was in c1 then formula would be: =Jan!C1
I think you should be able to do this by using the following formula where you want each month total to go: =Sheet!CellNo e.g. if Sheet 1was called Jan and total was in c1 then formula would be: =Jan!C1
P pernickety Registered User Messages 175 24 Jan 2008 #3 try copy and 'paste special', and select value. You will then lose the formula though but should get the value without the error.
try copy and 'paste special', and select value. You will then lose the formula though but should get the value without the error.
H Husssy Registered User Messages 48 24 Jan 2008 #4 Thanks folks back in action. Much appreciated Last edited: 24 Jan 2008
