Fifty Posted October 25, 2006 Share Posted October 25, 2006 Hi I need to know how to have 9 sheets within a file On each sheet will be data in the same cells I need to have these automatically adding up on to a 10th(in the same file) sheet with the total information from the 9 sheets lol does that make sense to anyone? Rich:d Link to comment Share on other sites More sharing options...
supra_surj Posted October 25, 2006 Share Posted October 25, 2006 Right click on the sheet tabs (where it says sheet 1, 2 etc) do add sheet until you get 10 sheets. put your data in on each sheet... on the 10th sheet add your formulas. ie...=sum(sheet1!c16....) just type in =sum( then just click on the sheet tabs then the cells. excel will automatically put in sheet1!c16 for example. Hope that helps! lol! Link to comment Share on other sites More sharing options...
how_supra Posted October 25, 2006 Share Posted October 25, 2006 Okay, so you are saying you want ten sheets in one file first off? To add a tab in the same sheet Right click the mouse on one of the tabs and insert worksheet. Link to comment Share on other sites More sharing options...
supra_surj Posted October 25, 2006 Share Posted October 25, 2006 Beat ya! hehe! Link to comment Share on other sites More sharing options...
Fifty Posted October 25, 2006 Author Share Posted October 25, 2006 Thanks so far Ill get it a try lol I think I know what I want - bleedin accountants lol Rich Link to comment Share on other sites More sharing options...
how_supra Posted October 25, 2006 Share Posted October 25, 2006 There are a couple of ways to do what you want to do, supra_surj has one way, another even simpler way is in the cell on the 10th spreadsheet, press equals, then flick onto the sheet with the number you want, and hit enter [its hte same thing without typing]. Link to comment Share on other sites More sharing options...
how_supra Posted October 25, 2006 Share Posted October 25, 2006 Beat ya! hehe! pah seconds in it. Link to comment Share on other sites More sharing options...
supra_surj Posted October 25, 2006 Share Posted October 25, 2006 Hehe! yea thats what i meant. type =sum( then click away. hehe! Link to comment Share on other sites More sharing options...
Fifty Posted October 25, 2006 Author Share Posted October 25, 2006 oOK got it muchios gracias! Rich:d Link to comment Share on other sites More sharing options...
supra_surj Posted October 25, 2006 Share Posted October 25, 2006 Ur welcome! hehe! Link to comment Share on other sites More sharing options...
Fifty Posted October 25, 2006 Author Share Posted October 25, 2006 Want a job 1 pound/hr BUT all the pancakes you can eat:d Rich Link to comment Share on other sites More sharing options...
how_supra Posted October 25, 2006 Share Posted October 25, 2006 mmmmmmmmmm pancakes. Tasty. Link to comment Share on other sites More sharing options...
supra_surj Posted October 25, 2006 Share Posted October 25, 2006 ill take it! lol!!! does it pay my travel expenses? hehe! Link to comment Share on other sites More sharing options...
Fifty Posted October 25, 2006 Author Share Posted October 25, 2006 Only if you live in Bodmin Im afraid lol hey, appreciate your help:d Rich Link to comment Share on other sites More sharing options...
supra_surj Posted October 25, 2006 Share Posted October 25, 2006 Lol! dont even know where that is! lol!! Kool mate take it easy! Surj Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now