Elgoalio39
New Member
- Joined
- Sep 12, 2019
- Messages
- 1
Forgive me here guys. I'm completely self taught but have zero knowledge of visual basic and have come up against a problem that I believe can only be solved by visual basic
I have a worksheet of customer information called "data"
I then have another worksheet called "Agent View"
The agent view sheet is looking up information on the data sheet and presenting it in a form view. There are a few boxes that will be filled in on that sheet and then I want to create a button that will click to end that interaction but I want it to write the information from these boxes into the specific row on the "data" worksheet
For example, I have "Final Offer" in cell D25 on the "agent view" sheet. I want a macro/button that will lookup the customer reference number (in D3 of the "Agent View" sheet) and find the row in "data", then paste the "Final Offer" amount in column I of the correct row.
Any help is massively appreciated!
I have a worksheet of customer information called "data"
I then have another worksheet called "Agent View"
The agent view sheet is looking up information on the data sheet and presenting it in a form view. There are a few boxes that will be filled in on that sheet and then I want to create a button that will click to end that interaction but I want it to write the information from these boxes into the specific row on the "data" worksheet
For example, I have "Final Offer" in cell D25 on the "agent view" sheet. I want a macro/button that will lookup the customer reference number (in D3 of the "Agent View" sheet) and find the row in "data", then paste the "Final Offer" amount in column I of the correct row.
Any help is massively appreciated!
