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

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

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.


--
MrSeagull
------------------------------------------------------------------------
MrSeagull's Profile: http://www.excelforum.com/member.php...o&userid=27722
View this thread: http://www.excelforum.com/showthread...hreadid=559418