Merging seperate spreadsheets

[inanegeek]

I have 6 members of staff. Each member of staff has an excel spreadsheet that they fill in with headers such as office, office owner, etc.

I have a master sheet that i cut and paste all their info into.

I wanted to know if there was a way to create 6 spreadsheets that will automatically fill in the larger master sheet.

[aydeegee]

The attached will work for 10 columns of data.

Just make sure that the worksheet name is the name that you want to appear on the Master list, and press Ctrl-shift-Q.

Is this what you were looking for?

Regards

Alastair

[inanegeek]

The attached will work for 10 columns of data.

Just make sure that the worksheet name is the name that you want to appear on the Master list, and press Ctrl-shift-Q.

Is this what you were looking for?

Regards

Alastair

i never knew you could do that andthatsa cool trick how do you set it up so the Spreadhseets know which one is the master?

[aydeegee]

The clue's in the name - it's called "Master"

It will only work with Master open (that's where the macro is stored - hence its name of Master.xlsm rather than .xlsx)

Regards

Alastair