Merge data into cells on a page in excel?

ad1234

Board Regular
Joined
Jan 16, 2008
Messages
163
I have set up a series of student worksheets to test a skill, for example binary addition. Steps:

1. I set up a series of random numbers which I've converted to 8 bit binary
2. I copied/pasted these so that there are 18 questions per page
3. I hid the columns and copied pasted the cells so that I have 36 pages on the worksheet
4. I print pages 1 to 36 and get 36 unique worksheets which a great :) I get a unique set every time I open the workbook to print some more too.

What is the best way to:

Add a student name, from a list, to each page in the worksheet. I could probably work out a messy solution but I wondered if there was a decent way to do this?

So I want the student names to appear in the yellow cells on attached image.

Thanks for any ideas...

view
 
Last edited:

Some videos you may like

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

nwfinance

Board Regular
Joined
Jan 22, 2016
Messages
67
Office Version
  1. 365
Platform
  1. Windows
Why not have a list of student names as its own sheet and then each page reference a specific cell. So on sheet "Test3" (or something like it) it would reference cell A3 on "StudentNames"? It would automatically update when you put new names in the "StudentNames" sheet, but you'd be limited to sets of 18 students or however many sheets you started out with.

Is that what you were thinking or am I not understanding your problem?
 

ad1234

Board Regular
Joined
Jan 16, 2008
Messages
163
You are understanding the problem yes, and breaking it down as you suggest makes it a bit easier. That is the best solution so far. Thank you.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,518
Messages
5,596,630
Members
414,082
Latest member
sasmita

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top