I need to create a spreadsheet for data in a monthly spreadsheet and have the
data calculated by name. for example in the sheet named 1st I have in column
a my name and in row 2 another name and so on with data in column 3, 4, 5,
and so on. at the end of the month I want to have a data sheet with a
collectiion of all the data. How do I send the name in sheet named 1st to
the Data sheet at the end ? and How do I list the names in the end data sheet
when it is possible that the names in column 1 could be different each day.

Sorry if this is a bit long I hope you understand what I want to do!

Any Help
--
Thom

Insert a new worksheet and name it Data. Then highlight all the names
(and a heading) in column A of the sheet called 1st and copy/paste to
column A of Data. With this still highlighted, click on Data | Filter
| Advanced Filter and in the pop-up you should see your range - click
on Unique Records only and Copy to New Location (specify $C$1 as the
location). Click OK and you will then have a unique list of names in
column C - delete columns A and B.

I'm not sure exactly what you want to do then - perhaps a formula like
this in B2:

=SUMIF(1st!$A$2:$A$1000,$A2,1st!B$2:B$1000)

which will add all the entries in column B of the sheet called 1st
which have the name in A2 of the Data sheet. You can copy this formula
down for as many names as you have in column A, and you can copy it
across if you want to sum other columns.

Hope this helps.

Pete


On May 12, 8:00 pm, Thom wrote:
I need to create a spreadsheet for data in a monthly spreadsheet and have the
data calculated by name. for example in the sheet named 1st I have in column
a my name and in row 2 another name and so on with data in column 3, 4, 5,
and so on. at the end of the month I want to have a data sheet with a
collectiion of all the data. How do I send the name in sheet named 1st to
the Data sheet at the end ? and How do I list the names in the end data sheet
when it is possible that the names in column 1 could be different each day.

Sorry if this is a bit long I hope you understand what I want to do!

Any Help
--
Thom