Generate separate excel sheets for each row of data using vba

[jessicapiper]

Hello,

I have a spreadsheet with rows of data. I want to generate a separate sheet for each row of data. I want the name of the sheet to come from the data in column A. I want the data in the other columns to populate cells in the new spreadsheet by reference, so that when I update the master spreadsheet it will feed the new individual sheets. I've searched multiple forums, websites, etc. and can't seem to find the right macro to work with my situation.

Thank you for your help!

[shg]

Welcome to the board, Jessica,

How's this?

[jaslake]

Hi jessicapiper

Welcome to the Forum!!!

Just looking at your workbook...where will Bidder Name and Phone Number pull from/how will they be entered?

Please describe the entire process (start to finish) best you can.

Edit: Never mind Jessica...you're in the best of the best hands with shg.

[jessicapiper]

Thank you! This spreadsheet will be used to track items that are donated to our school silent auction. As we receive items, we will fill out the master spreadsheet. Each item will have a number and we will assign the starting bid and increments. In the past we would take that data and then open a separate file to generate the bid sheet, which is then printed out and placed with the donated item on a table for people to write in their names and information. I want the master spreadsheet that we use to log donated items to feed these separate tabs which will become the bid sheets, that we can print off (to eliminate needing to enter the data twice and to also prevent mistakes). I hope that helps.


The bidder name and phone number will be physically written, the bid sheets will be printed out and the bidders will write their names in during our auction

[jessicapiper]

That is perfect, thank you so very much!!! This will save our volunteers so much time and I cannot wait to show them!

[shg]

You're welcome.