I need help combining data onto one master spreadsheet from several spreadsheets. Can I write an array macro that can do this?
For instance, the sheets examples are:
Bain, R.
Ebert, B.
and etc.
On these sheets it has their stat information.
I want the macro to take that stat information copy and paste it onto another master sheet. I need it to locate the same name on the master sheet as well. Anyone know how to do this?
Thanks
For instance, the sheets examples are:
Bain, R.
Ebert, B.
and etc.
On these sheets it has their stat information.
I want the macro to take that stat information copy and paste it onto another master sheet. I need it to locate the same name on the master sheet as well. Anyone know how to do this?
Thanks