Posts by Cherry34

Hello,

Yes, I am. I already have the data on an excel sheet and just need a better way to track what I am doing. I am rewatching his data mapping video to make sure I am doing the right thing.

Quote from royUK

Try this

Code

 Sheet2.Cells(1, ProvCol).Value = Sheet2.Cells(ProvRow, ProvCol).Value

To replace

Code

.Range(Sheet2.Cells(1, ProvCol).Value).Value = Sheet2.Cells(ProvRow, ProvCol).Value

Hello,

I tried that but still receiving an error. I am going to start over and see why I am getting these error

Quote from Carim

Seems that the order of instructions was garbled ...

see attached modification

Hope this will help

Display More

Hello, Thank you but still receiving an error. When I input the new record it save on sheet 3 instead of sheet 2. I don't know why that is happening. I am going to start over and look and see where I made my mistake. What I want to happen sound easy but it is hard with getting the VBA code to work.

Quote from Carim

Hello and Welcome to the Forum

For somebody who just started out ... All my Congratulations ...!!!

At this stage, what is precisely the next issue you would like to fix ....

Edit:

found a tiny mistake in your macro : Prov_Load

Display More

Thank you for your kind words and looking over my VBA. At this time I am having an issue with saving new records. I am receiving the attach message .

Hello,

I am currently trying to create a Client form for work and followed a You tube tutorial to complete the form. However, I have tried data mapping(this help with knowing where all the information on sheet 1 should go on sheet2) before completing the ViBA code. however , when I go to enter the next set of code all of the data mapping I used previously keep erasing. The premise for the form is to input information on sheet 1 which is the form and have it save to save sheet2. I am a newbie so your help is greatly appreciated. Thanks. I have attached the workbook for review.