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