Tech Support Guy banner

Reference a range of cells from one cell.

979 Views 4 Replies 3 Participants Last post by  athegn
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?
Status
Not open for further replies.
1 - 1 of 5 Posts
Is there perhaps a sample to which you could upload as to show us your data structure? That would be helpful. Sounds like you could use a structural reorganization.
1 - 1 of 5 Posts
Status
Not open for further replies.
Top