Design a Macro to replace a copy and paaste function in Excel
- or -
Post a project like this1504
£20(approx. $25)
- Posted:
- Proposals: 14
- Remote
- #2731318
- Completed
TOP PRO - Excel, Word, PowerPoint, VBA, Google Sheet, Outlook, Access, Database, Scripting
Bay Minette
Virtual Assistant | Web Research Specialist | Excel | Fillable / Editable PDF |Data Mining Specialist |Data Extraction | & Project Coordinator
Cairo
WordPress Expert✮Shopify Expert✮Graphic Designer✮AutoCAD 2D & 3D✮CV Writer & Designer✮Fullstack developer
Rawalpindi
20827050666694576126446314709651711586178829018385703077764352773936365733712647
Description
Experience Level: Entry
I am looking for someone to design a macro which I can use time after time for Excel sheets
In the worksheet I have are 2 separate spreadsheets called Visit Report and Customer List. What I want to be able to do is click on the customer code in the customer list sheet say cell A3 and it will automatically put it into cell B4 in the client report. This is to automate the copy and paste procedure I have to do every time. When I click on the next code in the customer list it will automatically populate the next cell down in the visit report eg cell B5. So for example if I want to select SCO006 (A5) I would at the moment copy this cell and paste it into the next available space in the Customer List (B4) this procedure is repeated until the list is complete. The existing vlookup formula will work in the normal way.
The customer list contains at least 3000 lines and therefore to narrow down the selection I filter by sales area and postcode. Every sheet is different and there can be as many as 5 sheets per week so you can see why I want to automate this function.
I hope that is clear. I am looking for someone experienced who can get this job done quickly. If you think you are able to do this please get in touch.
In the worksheet I have are 2 separate spreadsheets called Visit Report and Customer List. What I want to be able to do is click on the customer code in the customer list sheet say cell A3 and it will automatically put it into cell B4 in the client report. This is to automate the copy and paste procedure I have to do every time. When I click on the next code in the customer list it will automatically populate the next cell down in the visit report eg cell B5. So for example if I want to select SCO006 (A5) I would at the moment copy this cell and paste it into the next available space in the Customer List (B4) this procedure is repeated until the list is complete. The existing vlookup formula will work in the normal way.
The customer list contains at least 3000 lines and therefore to narrow down the selection I filter by sales area and postcode. Every sheet is different and there can be as many as 5 sheets per week so you can see why I want to automate this function.
I hope that is clear. I am looking for someone experienced who can get this job done quickly. If you think you are able to do this please get in touch.
Steve C.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
67%
Last project
27 Feb 2020
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Steve, are you able to up load your document? Cheers Matty
895025
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies