Using a formula to carry totals from 1 sheet to another
2 questions:
After N2, which direction are you looking to copy *from*, across (O2),
OR down (N3)?
On the second sheet, which direction are you looking to paste *to*;
down or across?
--
Regards,
RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------
"KGB003" wrote in message
...
I use the formula ='[RENT-EXCEL 2009.xlsx]APR09'!N2 to carry amounts from
one
workbook sheet to another. My problem is I have 83 amounts to carry over
and
I have to do each one seperately by changing the "N" line number each time
and then I have to verify my worksheet name for each entry.
Is there an easier way.
|