Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding off of multiple sheets
Hi there.. I have a report that i need to create.. I have a file that has 5 worksheets and i need to add a cell from sheet one to a cell in sheet 5... I'm sure this is simple but i cant figure out how to add from multiple worksheets thanks -- bustanutti21 ------------------------------------------------------------------------ bustanutti21's Profile: http://www.excelforum.com/member.php...o&userid=25542 View this thread: http://www.excelforum.com/showthread...hreadid=495834 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding off of multiple sheets
Let XL make the formula for you.
Click in the cell that is to display the total, and enter an equal sign, = then, click in the cell containing the first value, Then hit the plus sign + Now, click on the Sheet5 tab, and click in the cell containing the second value, And then hit <Enter. You now have the syntax that you can duplicate for your other totals, or, you can continue creating your formulas in the same manner that you did the first one. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "bustanutti21" wrote in message news:bustanutti21.20icjy_1135366201.0555@excelforu m-nospam.com... Hi there.. I have a report that i need to create.. I have a file that has 5 worksheets and i need to add a cell from sheet one to a cell in sheet 5... I'm sure this is simple but i cant figure out how to add from multiple worksheets thanks -- bustanutti21 ------------------------------------------------------------------------ bustanutti21's Profile: http://www.excelforum.com/member.php...o&userid=25542 View this thread: http://www.excelforum.com/showthread...hreadid=495834 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How am i able to populate a sumation for multiple sheets | Excel Worksheet Functions | |||
Matching Multiple Sheets | Excel Worksheet Functions | |||
Opening multiple Excel files that contain varied selected sheets | Excel Worksheet Functions | |||
Exporting multiple sheets to multiple htm files? | Excel Discussion (Misc queries) | |||
linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) |