| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
An easy way to make a "summation"-sheet
I got a worksheet with 100 identical sheets containing data from 100
different projectparticipators. I want to make a sheet, where I have the same data for each of the 100 participators. The data is calculated in each of the 100 worksheet. It is not a sum of the data from the 100 worksheet but the exact data from each worksheet. Ex: Partipator 1: .... Participator 2:.... Can I do that in an easy way? -- Jane |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
An easy way to make a "summation"-sheet
Assuming your summation sheet is sheet1
Sub getemall() For i = 2 To Worksheets.Count Cells(i, 1) = Sheets(i).Range("a3") Next i End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Jane" wrote in message ... I got a worksheet with 100 identical sheets containing data from 100 different projectparticipators. I want to make a sheet, where I have the same data for each of the 100 participators. The data is calculated in each of the 100 worksheet. It is not a sum of the data from the 100 worksheet but the exact data from each worksheet. Ex: Partipator 1: .... Participator 2:.... Can I do that in an easy way? -- Jane |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
An easy way to make a "summation"-sheet
Thanks!
A stupid question: I have to make it in VBA? -- Jane "Don Guillett" skrev: Assuming your summation sheet is sheet1 Sub getemall() For i = 2 To Worksheets.Count Cells(i, 1) = Sheets(i).Range("a3") Next i End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Jane" wrote in message ... I got a worksheet with 100 identical sheets containing data from 100 different projectparticipators. I want to make a sheet, where I have the same data for each of the 100 participators. The data is calculated in each of the 100 worksheet. It is not a sum of the data from the 100 worksheet but the exact data from each worksheet. Ex: Partipator 1: .... Participator 2:.... Can I do that in an easy way? -- Jane |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
An easy way to make a "summation"-sheet
If your sheet names are NOT sheet1, sheet2, etc. Make a list and use this
idea. =INDIRECT("'"&a2&"'!$A$3") -- Don Guillett Microsoft MVP Excel SalesAid Software "Don Guillett" wrote in message ... No. Try this copied down =INDIRECT("Sheet"&ROW(A2)&"!$A$3") -- Don Guillett Microsoft MVP Excel SalesAid Software "Jane" wrote in message ... Thanks! A stupid question: I have to make it in VBA? -- Jane "Don Guillett" skrev: Assuming your summation sheet is sheet1 Sub getemall() For i = 2 To Worksheets.Count Cells(i, 1) = Sheets(i).Range("a3") Next i End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Jane" wrote in message ... I got a worksheet with 100 identical sheets containing data from 100 different projectparticipators. I want to make a sheet, where I have the same data for each of the 100 participators. The data is calculated in each of the 100 worksheet. It is not a sum of the data from the 100 worksheet but the exact data from each worksheet. Ex: Partipator 1: .... Participator 2:.... Can I do that in an easy way? -- Jane |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
An easy way to make a "summation"-sheet
Yes, it works! Thanks!
Jane "Don Guillett" skrev: If your sheet names are NOT sheet1, sheet2, etc. Make a list and use this idea. =INDIRECT("'"&a2&"'!$A$3") -- Don Guillett Microsoft MVP Excel SalesAid Software "Don Guillett" wrote in message ... No. Try this copied down =INDIRECT("Sheet"&ROW(A2)&"!$A$3") -- Don Guillett Microsoft MVP Excel SalesAid Software "Jane" wrote in message ... Thanks! A stupid question: I have to make it in VBA? -- Jane "Don Guillett" skrev: Assuming your summation sheet is sheet1 Sub getemall() For i = 2 To Worksheets.Count Cells(i, 1) = Sheets(i).Range("a3") Next i End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Jane" wrote in message ... I got a worksheet with 100 identical sheets containing data from 100 different projectparticipators. I want to make a sheet, where I have the same data for each of the 100 participators. The data is calculated in each of the 100 worksheet. It is not a sum of the data from the 100 worksheet but the exact data from each worksheet. Ex: Partipator 1: .... Participator 2:.... Can I do that in an easy way? -- Jane |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
An easy way to make a "summation"-sheet
Glad to help
-- Don Guillett Microsoft MVP Excel SalesAid Software "Jane" wrote in message ... Yes, it works! Thanks! Jane "Don Guillett" skrev: If your sheet names are NOT sheet1, sheet2, etc. Make a list and use this idea. =INDIRECT("'"&a2&"'!$A$3") -- Don Guillett Microsoft MVP Excel SalesAid Software "Don Guillett" wrote in message ... No. Try this copied down =INDIRECT("Sheet"&ROW(A2)&"!$A$3") -- Don Guillett Microsoft MVP Excel SalesAid Software "Jane" wrote in message ... Thanks! A stupid question: I have to make it in VBA? -- Jane "Don Guillett" skrev: Assuming your summation sheet is sheet1 Sub getemall() For i = 2 To Worksheets.Count Cells(i, 1) = Sheets(i).Range("a3") Next i End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Jane" wrote in message ... I got a worksheet with 100 identical sheets containing data from 100 different projectparticipators. I want to make a sheet, where I have the same data for each of the 100 participators. The data is calculated in each of the 100 worksheet. It is not a sum of the data from the 100 worksheet but the exact data from each worksheet. Ex: Partipator 1: .... Participator 2:.... Can I do that in an easy way? -- Jane |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I find ""Easy Sum" Not Auto Sum | Excel Discussion (Misc queries) | |||
| make "F51668H200AU" into "F5166-8H200AU" | Excel Discussion (Misc queries) | |||
| Make "Edit" mode default, rather than "Enter"? | Excel Discussion (Misc queries) | |||
| How do i enable "Group" & "Ungroup" in a protected sheet | Excel Discussion (Misc queries) | |||
| how can I make an excel cell "mark" or "unmark" when clicked on? | Excel Discussion (Misc queries) | |||
Linear Mode
