Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Updating Individual Sheets from a master | Excel Worksheet Functions | |||
Help: reference info from master spreadsheet to individual forms | Excel Worksheet Functions | |||
Moving primary data from master sheet to individual sheets w/in wo | Excel Discussion (Misc queries) | |||
Getting info from individual sheets into master sheet | Excel Worksheet Functions | |||
Getting info from individual sheets into master sheet | Excel Discussion (Misc queries) |