Collecting data from worksheets.

[MrSeagull]

Here is a frustrating scenario I have.
An employee collects data on people in a spreadsheet. Each worksheet within the file is a month, from January to June. Each month lists names with some numbers and totals at the end of the rows. Here is the hard part, each month has a different list of names. Some have names that re-occur, some don't.
He wants to create a new worksheet in the file listing all the names from every month (sorted alphabetically) with totals from a cell range in each month.
I've burned myself out on this problem, and I'm out of ideas.

[Marcelo]

Hi, Mr Seagull,

one way is copy all sheets in one (assuming that the columns are the same),
and use a pivot table, to solve it. course insert a new column with the month
information.

hth
regards from Brazil
Marcelo

"MrSeagull" escreveu:

>
> Here is a frustrating scenario I have.
> An employee collects data on people in a spreadsheet. Each worksheet
> within the file is a month, from January to June. Each month lists
> names with some numbers and totals at the end of the rows. Here is the
> hard part, each month has a different list of names. Some have names
> that re-occur, some don't.
> He wants to create a new worksheet in the file listing all the names
> from every month (sorted alphabetically) with totals from a cell range
> in each month.
> I've burned myself out on this problem, and I'm out of ideas.
>
>
> --
> MrSeagull
> ------------------------------------------------------------------------
> MrSeagull's Profile: http://www.excelforum.com/member.php...o&userid=27722
> View this thread: http://www.excelforum.com/showthread...hreadid=559418
>
>

[MrSeagull]

Well, the thing he was wanting to do is make it so that, if they make changes to the original content it would reflect on the summary.