Copy names from one sheet to other workbook sheets

[DrOC10]

HI

I have a scoring sheet and on Sheet 2 i have a list of the organisations and project names to be scored. each sheet in the workbook is a single scoring sheet for each organisation.

Is there any way that i can get excel to have the name of the organisation appear in A2 on each sheet and the project name appear in B2 on each sheet from the list of names and organsiations on sheet 2 - rather than doing it manually? as in ==Sheet2!A2.

I will have a lot and i was looking for a more efficient way to do it if possible - thanks all for your time!

Spreadsheet attached.

[PeteABC123]

Have you tried copy, group the sheets, and paste? Then Ungroup.

Pete

[DrOC10]

Hi Pete

Thanks for that. How would I do that - I just dont understand the process.

[PeteABC123]

Hi DrOC10:
(Try and practice on a sample worksheet. . .you'll get the hang of it.)

Copy your two cells.
Holding down your CTRL key, select the other tabs by clicking on the various worksheet tabs and keeping the CTRL key depressed This will group the worksheets. Paste your contents into the desired cells, and it will copy to each sheet. Try and either paste as values, or paste an absolute cell reference if it's going to different cell locations from the source worksheet.

Hope this helps.

Pete