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.

 

[Guest]

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:

 

[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.