If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
formula question...
I have a workbook in excel with four sheets, i have the same format of
columns in each of the sheets except for the last one. The last one i am trying to make be the total of the others. this brings me to my question, how can i make the columns in the final sheet be updated with whats put in the other sheets? My first four sheets are my salesmens statistics, each sheet being a different salesman. I want the final sheet to be a total sheet that adds copys the info from the other sheets to the final. For instance i have a column for revenue, organization name, potential revenue, etc, on each sheet including the final sheet. i want the final sheet to stay updated as the other sheets are updated. PLEAS HELP!!! |
Thread Tools | |
Display Modes | |
|
|