Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
multiple worksheets - getting data from same cell for a list
Hi - Could anyone assist please.
I have a workbook (just the one document) with around 60 pages of active data in it - all pages have the same format. Just the data (scores in this case) and page name (page1, page2 etc.) change. I am trying to do a master list on the front page which pulls the data from cell G192 from each page onto a master refrence list. Is there anyway to bring the contents to the master list other than write in cell A1 = Book1!G192 in cell A2 = Book2!G192 etc.,? I can do this 60 times but there must be a simpler way. Anyone got any tips please? Ta Andy |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
multiple worksheets - getting data from same cell for a list
Mention the sheet names in one column as shown below. In B1 enter this
formula. Drag the formula down A1 = Book1 A2 = Book2 =INDIRECT(A1&"!" & "G192") If this post helps click Yes --------------- Jacob Skaria "noy" wrote: Hi - Could anyone assist please. I have a workbook (just the one document) with around 60 pages of active data in it - all pages have the same format. Just the data (scores in this case) and page name (page1, page2 etc.) change. I am trying to do a master list on the front page which pulls the data from cell G192 from each page onto a master refrence list. Is there anyway to bring the contents to the master list other than write in cell A1 = Book1!G192 in cell A2 = Book2!G192 etc.,? I can do this 60 times but there must be a simpler way. Anyone got any tips please? Ta Andy |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
multiple worksheets - getting data from same cell for a list
try
Sub getlistfromshts() For i = 1 To Sheets.Count If Sheets(i).Name < "Master" Then Sheets("master").Cells(i, 1) = Sheets(i).Range("g192") End If Next i End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "noy" wrote in message ... Hi - Could anyone assist please. I have a workbook (just the one document) with around 60 pages of active data in it - all pages have the same format. Just the data (scores in this case) and page name (page1, page2 etc.) change. I am trying to do a master list on the front page which pulls the data from cell G192 from each page onto a master refrence list. Is there anyway to bring the contents to the master list other than write in cell A1 = Book1!G192 in cell A2 = Book2!G192 etc.,? I can do this 60 times but there must be a simpler way. Anyone got any tips please? Ta Andy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need Simple List...Multiple Columns and Multiple Worksheets | Excel Worksheet Functions | |||
Multiple Worksheets and Cell References - Data Output | Excel Discussion (Misc queries) | |||
Compile list of same cell from multiple worksheets | Excel Worksheet Functions | |||
list data of same cell on different worksheets. | Excel Worksheet Functions | |||
Extracting data from multiple worksheets into a list | Excel Worksheet Functions |