I'm new to excel and need help in combining statistics from multiple
workbooks. I currently have 5 seperate workbooks (5 years) with different
data in each one. All the data applys to individual people. Let say person
"A" has data in one year and has diffferent data in a different workbook and
on a different sheet in another year. I just need to add this data togetherin
a new workbook. I know I can open both workbooks and have the add statement
do this, but year after year it getting to be a very big statement. Is there
a macro that can scan the workbook for a patricular person and get the data
assocaiated with it? I'm not for sure I'm real clear, but I would appreciate
any help.

Mark

Mark if I understood you could use the VLOOKUP function

hope it helps
Regards from Brazil
Marcelo

"Mark" escreveu:

> I'm new to excel and need help in combining statistics from multiple
> workbooks. I currently have 5 seperate workbooks (5 years) with different
> data in each one. All the data applys to individual people. Let say person
> "A" has data in one year and has diffferent data in a different workbook and
> on a different sheet in another year. I just need to add this data togetherin
> a new workbook. I know I can open both workbooks and have the add statement
> do this, but year after year it getting to be a very big statement. Is there
> a macro that can scan the workbook for a patricular person and get the data
> assocaiated with it? I'm not for sure I'm real clear, but I would appreciate
> any help.
>
> Mark