Using Excell I have a table, on worksheet 'Attendees', with First names in column A and Last names in column B.
I have another worksheet that I use to print place names. Place names have to be printed 8 per sheet.
So I have a formula, on worksheet 'Placenames', in cell E7 '=Attendees!A2' and in F7 'Attendees!B2' then down for the next 7 rows. The actual place name cells use the formulae =E7&" "&F7 etc
I amend cell E7 to start at the next 8 names e.g E10 and drag/copy E7 over F7 then drag/copy E7 & F7 down over the following 7 rows.
I would like formulae in cells F7 and E8-F14 that would reference cell E7. I would then only have to amend Cell E7 and the place name fields would be updated.
Would I use INDIRECT, OFFSET or some other formulae in these cells?
Can anyone please advise?