Help with data population

erikah

New Member
Joined
Jul 15, 2016
Messages
2
Hello! I am having trouble figuring out how to take the data from one sheet and create and populate other sheets based off of that data.

I have 200 books on a master list, and I am trying to add those books Title, Author, and Series number to a template that I made. One sheet for every book. However I can't seem to find out how this is possible. Does anyone know how?

I am attaching the template that I made. The top three merged columns are what I am trying to populate with another 3 column by 200 row sheet of data. Once new template sheet for every row...

https://drive.google.com/open?id=0Bz-z7QSN8IPLeHR3ZmhzVGQ2aWc
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
Hi, welcome to the board :)

Not all members are able - or willing - to access file hosting sites (I know I cannot), so can you show a sample of what you are dealing with here, please?
 
Upvote 0
Does this work?

Screen_Shot_2016_07_15_at_5_17_48_PM.png
 
Upvote 0
I think it depends on the browser that is being used. I am using IE11 right now and still cannot see the image. If you posted a .png, try it in .jpg format, or just copy/paste some sample data
 
Upvote 0

Forum statistics

Threads
1,220,965
Messages
6,157,119
Members
451,399
Latest member
alchavar

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
Back
Top