Remember Me?

#1
May 9th 09, 06:10 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: May 2009 Posts: 1
Using a formula to carry totals from 1 sheet to another

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.

#2
May 9th 09, 06:16 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Mar 2009 Posts: 8,521
Using a formula to carry totals from 1 sheet to another

Copying that formula down will change the reference to N3,4,.... If you are
not looking for a continuous reference, please let us know whats the next row
to be referred after 2....

If this post helps click Yes
---------------
Jacob Skaria

"KGB003" wrote:

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.

#3
May 9th 09, 06:23 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 3,572
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.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Dottled Excel Discussion (Misc queries) 3 January 26th 09 03:53 PM Andrew Ball[_2_] Excel Discussion (Misc queries) 2 September 19th 08 08:59 AM CAPTGNVR Excel Discussion (Misc queries) 5 February 2nd 07 07:05 PM Svea Excel Discussion (Misc queries) 3 July 17th 06 07:46 AM ZBC2 Excel Discussion (Misc queries) 1 January 29th 06 11:23 AM

All times are GMT +1. The time now is 07:52 AM.