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 |
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 |
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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 10:57 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com