Formula help please...

I thought that if each sheet had the same column headers on it, then the
newest version of Excel COULD generate pivot tables form multiple sheets. I
don't have an XP version of Excel, but perhaps someone else could
confirm...?


"Excel Dummy" wrote in message
...
I understand the difficulty of so many sheets as the data sources but
there
is no way around it. There is a lot of information entered on each daily
page
(300 rows, column A-AV)and I need to be able to just pull those lists out.
I
was originally leaning towards a sheet by sheet filter but it is not
practical for my needs. I'm going to try what Debra said and see it that
works. **keeping fingers crossed**

"Biff" wrote:

Lots of wisdom offered to you by some top notch folks!

My 2 cents:

I hate pivot tables. Can a pivot table have 31 sheets as the source?

Filters are OK but are not dynamic. Using a filter would require you to
repeat the proccess 31 times. No joy!

If you are intent on the layout of the file structure then formulas
could be
used for this but the output would not be exactly as you expect. You
would
need to extract the desired data from each of the 31 sheets to it's own
location and because the amount of data extracted from each sheet will
vary
there will be empty rows between data sets.

Biff

"Excel Dummy" Excel wrote in message
...
I have made a 33 page spreadsheet. One main for totals, 31 for daily
data,
and a blank final page. I want to filter some data (first names, last,
customer account number from the daily pages to list on the final page
only
if they made a purchase of a specific item. In other words, if all
conditions
were met (all 4 columns were used) it would be sorted to the final
page.
Each
of the daily ones have 40 plus possible entries. I am looking
specifically
to
create an independant list on the last page if those particular 4
columns
have data. Anyone have a suggestion?

Excel Dummy wrote:
I have made a 33 page spreadsheet. One main for totals, 31 for daily data,
and a blank final page. I want to filter some data (first names, last,
customer account number from the daily pages to list on the final page only
if they made a purchase of a specific item. In other words, if all conditions
were met (all 4 columns were used) it would be sorted to the final page. Each
of the daily ones have 40 plus possible entries. I am looking specifically to
create an independant list on the last page if those particular 4 columns
have data. Anyone have a suggestion?

Have you considered using Access? As I read this thread my first
thought was this is more suited for a database than a spreadsheet.

gls858

XP isn't the newest version, 2003 is. Either way, neither of them have a
friendly method of creating a Pivot table the way you would expect to be
able to if you use multiple sheets (called multiple consolidation ranges).
Even if all sheets are identical you will not see the columns you expect in
the field chooser.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------