Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
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

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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
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
Loop Macro a variable number of times thesaxonuk Excel Discussion (Misc queries) 11 October 31st 06 06:05 PM
Sumary of 150 sheets info in one sheet mantros Excel Discussion (Misc queries) 3 October 30th 06 09:32 PM
macro unouwanme Excel Discussion (Misc queries) 9 August 31st 06 09:38 PM
Inventory sheet to track, order & reduce quantity from master. drc536 New Users to Excel 2 October 23rd 05 05:36 PM
Make inventory sheet to track, order & reduce quantity from master drc536 Excel Worksheet Functions 1 October 23rd 05 05:35 PM


All times are GMT +1. The time now is 02:55 AM.

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

About Us

"It's about Microsoft Excel"