Tech Support Guy banner
Cancel

Reference a range of cells from one cell.

978 Views 4 Replies 3 Participants Last post by  athegn, 
A
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?
Save
Like
Status
Not open for further replies.
1 - 1 of 5 Posts
O
Rather than using a formula I would use a Visula Basic Macro.
Copy the first 8 rows (2 columns), paste at your print destination.
Print the selection.
Move down 8 rows, copy and paste to your print destination.
Print the selection.
And so on until you have a cell with nothing in it.
Save
Like
1 - 1 of 5 Posts
Status
Not open for further replies.
Tech Support Guy
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!
Full Forum Listing
Explore Our Forums
Hardware Virus & Other Malware Removal Off Topic Lounge Thread Games & Discussion Networking
Top