Merge multiple worksheets into one
 

I have excel reports I receive with information on a daily basis. These are
saved in separate tabs within an excel workbook. I'm looking to add 2 things.

1. One tab with all the detail from the days (without having to copy and
paste each day). I need to exclude the top few rows of the spreadsheet, as
it has merged cells - only report names and times that I'm not interested in.
2. A Summary tab with totals, for example, by vendor # (without having to
create a pivot table each time I want this view.

For a specific example, I have a file with vendor receipts - vendor #,
vendor name, sku, item description, pcs, date, cost and extended cost. I
want to pull all rows.

Thanks,
C.

Merge multiple worksheets into one
 

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"nitengale" wrote in message
...
I have excel reports I receive with information on a daily basis. These
are
saved in separate tabs within an excel workbook. I'm looking to add 2
things.

1. One tab with all the detail from the days (without having to copy and
paste each day). I need to exclude the top few rows of the spreadsheet,
as
it has merged cells - only report names and times that I'm not interested
in.
2. A Summary tab with totals, for example, by vendor # (without having to
create a pivot table each time I want this view.

For a specific example, I have a file with vendor receipts - vendor #,
vendor name, sku, item description, pcs, date, cost and extended cost. I
want to pull all rows.

Thanks,
C.