Prev: controlling chart location
Next: Excel VBA ?
From: nitengale on 12 Mar 2010 13:20
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.
From: Don Guillett on 12 Mar 2010 15:23
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
dguillett(a)gmail.com
"nitengale" <nitengale(a)discussions.microsoft.com> wrote in message
news:D790504C-DC80-45B5-8F24-12BCA13ED9BD(a)microsoft.com...
>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.

 | 
Pages: 1
Prev: controlling chart location
Next: Excel VBA ?