LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Updating Individual Sheets from a master [email protected] Excel Worksheet Functions 1 June 8th 07 09:39 PM
Help: reference info from master spreadsheet to individual forms Tia Excel Worksheet Functions 1 March 6th 07 09:41 PM
Moving primary data from master sheet to individual sheets w/in wo willie091028 Excel Discussion (Misc queries) 1 January 13th 07 04:33 AM
Getting info from individual sheets into master sheet [email protected] Excel Worksheet Functions 4 November 21st 06 10:05 AM
Getting info from individual sheets into master sheet [email protected] Excel Discussion (Misc queries) 1 November 17th 06 05:24 PM


All times are GMT +1. The time now is 09:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"