Collecting data from worksheets.
 

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

Collecting data from worksheets.
 

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

Collecting data from worksheets.
 

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