| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I capture info from multiple sheets to main worksheet?
I have a travel worksheet for budgeting purposes. We need to get the
information (# of trips/# of days) submitted from the four people (all on separate sheets within the main worksheet document) to the main worksheet. Is there a formula that would allow me to take the totals of each sheet and put the total in the main sheet? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I capture info from multiple sheets to main worksheet?
=Sheet2!B10
in Sheet1 will display the content of B10 in Sheet2 Or have I misunderstood? -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "cempire5" wrote in message ... I have a travel worksheet for budgeting purposes. We need to get the information (# of trips/# of days) submitted from the four people (all on separate sheets within the main worksheet document) to the main worksheet. Is there a formula that would allow me to take the totals of each sheet and put the total in the main sheet? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I capture info from multiple sheets to main worksheet?
Since there will be four sheets of different responses would I put:
=Sheet2!B10+Sheet3!B10+Sheet4!B10 so that the total of each of these sheets calculates in the main worksheet? "Bernard Liengme" wrote: =Sheet2!B10 in Sheet1 will display the content of B10 in Sheet2 Or have I misunderstood? -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "cempire5" wrote in message ... I have a travel worksheet for budgeting purposes. We need to get the information (# of trips/# of days) submitted from the four people (all on separate sheets within the main worksheet document) to the main worksheet. Is there a formula that would allow me to take the totals of each sheet and put the total in the main sheet? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I capture info from multiple sheets to main worksheet?
Yes that would work
So would =SUM(Sheet2:Sheet5!B10) If sheets have spaces in their names: =SUM('Jan data:March data'!B10) best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "cempire5" wrote in message ... Since there will be four sheets of different responses would I put: =Sheet2!B10+Sheet3!B10+Sheet4!B10 so that the total of each of these sheets calculates in the main worksheet? "Bernard Liengme" wrote: =Sheet2!B10 in Sheet1 will display the content of B10 in Sheet2 Or have I misunderstood? -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "cempire5" wrote in message ... I have a travel worksheet for budgeting purposes. We need to get the information (# of trips/# of days) submitted from the four people (all on separate sheets within the main worksheet document) to the main worksheet. Is there a formula that would allow me to take the totals of each sheet and put the total in the main sheet? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I capture info from multiple sheets to main worksheet?
It worked. You're the best! I hope I'm not asking too much, but this
spreadsheet has columns B-Y and rows 4-19. How do I copy that formula so that I don't have to retype each and every one for the remainder of the worksheet? "Bernard Liengme" wrote: Yes that would work So would =SUM(Sheet2:Sheet5!B10) If sheets have spaces in their names: =SUM('Jan data:March data'!B10) best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "cempire5" wrote in message ... Since there will be four sheets of different responses would I put: =Sheet2!B10+Sheet3!B10+Sheet4!B10 so that the total of each of these sheets calculates in the main worksheet? "Bernard Liengme" wrote: =Sheet2!B10 in Sheet1 will display the content of B10 in Sheet2 Or have I misunderstood? -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "cempire5" wrote in message ... I have a travel worksheet for budgeting purposes. We need to get the information (# of trips/# of days) submitted from the four people (all on separate sheets within the main worksheet document) to the main worksheet. Is there a formula that would allow me to take the totals of each sheet and put the total in the main sheet? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I capture info from multiple sheets to main worksheet?
If you type one of the formulas , say =SUM(Sheet2:Sheet5!B10)
in B1 of Sheet1 and then copy it to C1, then C1 will read =SUM(Sheet2:Sheet5!C10) Experiment and see what you get best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "cempire5" wrote in message ... It worked. You're the best! I hope I'm not asking too much, but this spreadsheet has columns B-Y and rows 4-19. How do I copy that formula so that I don't have to retype each and every one for the remainder of the worksheet? "Bernard Liengme" wrote: Yes that would work So would =SUM(Sheet2:Sheet5!B10) If sheets have spaces in their names: =SUM('Jan data:March data'!B10) best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "cempire5" wrote in message ... Since there will be four sheets of different responses would I put: =Sheet2!B10+Sheet3!B10+Sheet4!B10 so that the total of each of these sheets calculates in the main worksheet? "Bernard Liengme" wrote: =Sheet2!B10 in Sheet1 will display the content of B10 in Sheet2 Or have I misunderstood? -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "cempire5" wrote in message ... I have a travel worksheet for budgeting purposes. We need to get the information (# of trips/# of days) submitted from the four people (all on separate sheets within the main worksheet document) to the main worksheet. Is there a formula that would allow me to take the totals of each sheet and put the total in the main sheet? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LINKING MAIN SHEET WITH MULTIPLE SUMMARY SHEETS | New Users to Excel | |||
| LINKING MAIN SHEET WITH MULTIPLE SUMMARY SHEETS | Excel Worksheet Functions | |||
| Need info to show on multiple sheets | Excel Discussion (Misc queries) | |||
| Using info on multiple Sheets | Excel Discussion (Misc queries) | |||
| pulling info from multiple sheets | Excel Discussion (Misc queries) | |||
Linear Mode
