mackemforever
New Member
- Joined
- Jun 29, 2020
- Messages
- 6
- Office Version
- 2019
- Platform
- Windows
This will require a bit of explaining.
Sheet A is my data entry sheet.
Sheet B is my master sheet.
Sheet B contains a list of all of my customers, complete with their most recent service.
Sheet A contains entry forms for new customers and new services.
The new service form on Sheet A allows me to select which customer it is via a drop-down menu that pulls the list from Column A on Sheet B.
When I have filled in the information in the new service form I want to be able to run a macro that will copy that information and paste it in to the row for that customer. So for example if I have selected customer Paul, his information is on Row E so the information from the new service sheet needs to be pasted in to Row E.
I've been playing around with this for a while and am absolutely stumped. How on earth would I achieve this?
Thanks.
Sheet A is my data entry sheet.
Sheet B is my master sheet.
Sheet B contains a list of all of my customers, complete with their most recent service.
Sheet A contains entry forms for new customers and new services.
The new service form on Sheet A allows me to select which customer it is via a drop-down menu that pulls the list from Column A on Sheet B.
When I have filled in the information in the new service form I want to be able to run a macro that will copy that information and paste it in to the row for that customer. So for example if I have selected customer Paul, his information is on Row E so the information from the new service sheet needs to be pasted in to Row E.
I've been playing around with this for a while and am absolutely stumped. How on earth would I achieve this?
Thanks.