Consolidating sheets

G

Guest

Hi

We are buying a company and I need to create a stock spreadsheet from their
workbook. I would like a single sheet containing the information from about
25 of their sheets. They have one sheet per type of stock item (all in one
book), so some of their sheets have 1 row and some have 50! Bearing in mind
that some of the rows are hidden (which I don't want) what is the easiest
way to consolidate their information into a single sheet, containing all of
the info from the individual sheets?
Cheers.
Andy.
 
G

Guest

Hi

I've tried that but it includes the hidden rows - which I don't want! Andy
ideas?

Andy.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup from different sheets 2
Problem consolidating data. 1
Accessing Other Sheet Tabs from within Excel 2
Consolidate information from multiple pivot tables 2
How do I reorder sheets in excel 5
Sorting data from multiple worksheets into a master sheet/tab 5
LOOKUP across Multiple Sheets 4
How to paste data to alternating cells down a column? 1

Top