Creating multiple user forms based on a single data table

Hello everyone,

My problem is as it follows;

I have a table as shown in the picture below;

https://s22.postimg.org/412bsgdup/Slika_1.gif

What I need to do is to create a new offer form for every one of those vehicles, which contains all the information from the associated row.

So far I added a new column with offer numbers that I use as a reference point for index match function to fill out this data in the offer form. From there I usually create a copy of the offer sheet and change the offer number by hand. I do that for every single row in the main table.

Here's a picture of that offer form;

https://s22.postimg.org/omh3kcvfl/Slika_2.gif

Resultant conclusion is that I need excel/vba to go trough all offer numbers from the main table, and create a new offer form for all of them. Index match should take care of the form filling part.

Recently I've started to learn about VBA as it seems I'll need it, but it's still a long way to go, so every bit of insight would be helpful.

Hi eHector

Welcome to the Forum!!!

Pictures are of little value.

Please attach a sample workbook the Structure of which is the same as your actual workbook.

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

INCLUDE ANY CODE YOU'RE USING OR HAVE TRIED.

Remember to desensitize the data.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Thank you jaslake.

I've attached a sample workbook that represents my problem.

In the place of the first sheet is the Main List, and on the second sheet is already a finished Offer Form as it needs to be.

As it could be seen, data in the Offer Form is linked from the Main List via index match by changing the Offer number.

So what I need VBA to do is to create a new Offer Form for every Vehicle from the Main List.

Sequence of actions should be as it follows:

1. Create a copy of the Offer form and place it on end (as a last sheet)
2. Change the Offer number on that new form to the one below the previous number from the Main List.
3. Repeat the process for every Vehicle that exists in the Main List.

Unfortunately I haven't done any coding by myself, so if this seeks out too much effort to code, I'll appreciate any advice in which direction to point my research at.

Thank you.

Hi eHector

This Code is in the attached. Ctrl + x will fire the Code. Please be aware, there is a hidden Sheet called "Template".

Please Login or Register  to view this content.

Hi eHector

As you're no doubt aware including a "/" in a worksheet name is not allowed. So, the naming convention is changed from B2667/16 to B2667 16.

This code has been modified to look at Column B.

Please Login or Register  to view this content.

You're welcome...glad I could help. Thanks for the Rep.