Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting info from individual sheets into master sheet
Hi Guys,
I made a database for personal information. I gave every person one sheet with a fixed format. I have about 200 sheets now all named according to the individual. Now I would like to have one master sheet, the first sheet, in the excel workbook that list all the names of the other sheets in one column and in the next column a cell that refers to one cell in each sheet with a remark in there. This way I have one overview from which sheets I need to change something and which ones are ok. I just don't have a clue how to do this. Is there an excel function or macro function? Would really appreciate the help. Regards, Maurits |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting info from individual sheets into master sheet
Hello Colleagues,
Maurtis' issue is similar to a problem that I am experiencing. While I am not attempting to have a column of tab names, I also have a spreadsheet with several hundred sheets in a uniform format, and would like to copy cell "D10" from all of the sheets into a column on a summary sheet. I thought I could use Copy Special, Value, Transpose, BUT copying multiple selections is not permitted. Is there another method that would do the same thing? Pivot table? All suggestions will be welcome. Thanks, EricT " wrote: Hi Guys, I made a database for personal information. I gave every person one sheet with a fixed format. I have about 200 sheets now all named according to the individual. Now I would like to have one master sheet, the first sheet, in the excel workbook that list all the names of the other sheets in one column and in the next column a cell that refers to one cell in each sheet with a remark in there. This way I have one overview from which sheets I need to change something and which ones are ok. I just don't have a clue how to do this. Is there an excel function or macro function? Would really appreciate the help. Regards, Maurits |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Loop Macro a variable number of times | Excel Discussion (Misc queries) | |||
Sumary of 150 sheets info in one sheet | Excel Discussion (Misc queries) | |||
macro | Excel Discussion (Misc queries) | |||
Inventory sheet to track, order & reduce quantity from master. | New Users to Excel | |||
Make inventory sheet to track, order & reduce quantity from master | Excel Worksheet Functions |