Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying Cells From Multiple Worksheets to Create Summary Sheet
I have multiple worksheets that have an identical form that different people
fill out. I would like to create a summary sheet that pulls from the same cells in each of the different worksheets. Is there to create a column on the worksheet that increments by a worksheet as it goes down. For example lets say I want to pull cell A20 from each worksheet i would want Sheet1 A20, Sheet2 A20, etc going down the column. I am doing this manually which is very tedious. Thanks for any help, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying Cells From Multiple Worksheets to Create Summary Sheet
Hi, Lee-
I'm not aware of any way to do this without VBA code- so I wrote the following code to do that task. Copy and paste this into your file as a macro. This will create a formula that references cell A20 from each tab in the workbook. You should try this out on a backed up copy of your data to avoid catastrophic data loss. Sub Three_D_Tab_Formula() Dim SheetName As Worksheet For Each SheetName In Sheets ActiveCell.Formula = "='" & SheetName.Name & "'!a20" ActiveCell.Offset(1, 0).Select Next SheetName End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summary of multiple spreadsheets: | Excel Worksheet Functions | |||
Multiple Workbook Data Capture Summary Sheet | Excel Discussion (Misc queries) | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
How do I display data from multiple worksheets in a summary sheet. | Excel Discussion (Misc queries) | |||
linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) |