Populating a form in excel from a different worksheet line by line

Hey all,

Would really appreciate any help, I'm new to VBA and despite getting off to a shaky start so far so good, but I've been able to solve this problem for a few days now and after much forum searching have been unable to adapt a solution and my deadline is quickly creeping up on me :(

I'm looking to create a macro that will pull information from a master worksheet (excel) and populate a summary terms of reference template (ToR) in the same workbook but each form (line of data) creating a separate worksheet named by the title column from the master sheet.

The original data is input to the master via a similar but more in-depth excel sheet, the form/worksheet template needing to be filled out is a simplified version for a high level summary. Therefore only specific cell references are need from the master (not entire the line, but I spose a table could be created fairly easily if this were to be a problem). For example a1 will need to populate b6. There are approx 20 cells of data to populate.

So far I have managed to find and adapt a code that opens a new worksheet, via the means of a unique list, of which each line names the title column.


So I guess my question is can there be a way of working the code mentioned above to open a template and take specific cell refs and populate them into the relevant space provided in the template?

*holds breath* :)

Laura

Could you provide a sample of you worksheet? It might make it a little easier to understand.

Thanks!

Thanks.

I've attached a sample spreadsheet.

To cut out the waffle:

I need the workbook to:
Populate the template in a new worksheet with the data in the Master Sheet, and create a new worksheet named by the title cell on a line by line basis.

wrong version updated - heres a better(ish) one

Would it also be good to upload the current code I've got?

Thank you so much for your help.

where would I nest the code above that the issue iv'e been having..

also code tags? this may be very naive of me but have a missed out something fundamenmtal here?

if you place [ code] at the at the start of your code and [ /code] at the end, it will display in such a way as to make it easier to read. Edit your post with the code in it with them tags and see the difference

important = remove the space inside the start of the bracket when you use them

thank Nigelog - for a moment there I thought id messed up the code itself - thanks for the info

Ok so I've worked on a much better example with the exisiting code included (button on the Form Table) as my noobity is coming through

So the Master Data will be copy and paste into the blank sheet "Master". The "Form Table" sheet will have Vlookups pulling the information needed from the master.

I need the current code to be adapted to open the "Template" sheet when creating the new sheets and then pull the information from the "Form Table" into each template created (one line of data = one template).

apologies for the delay ive been out of office

no there is no specific need for the unique list I just thought it necessary. Any help would be mucho apreciated