![phoenix](https://d1a29h5kxv3oc2.cloudfront.net/dist/img/phoenix.81914efc7207f6a059bd10f5d3fd5f89.png)
Excel macro or script
- or -
Post a project like this1661
£150(approx. $193)
- Posted:
- Proposals: 47
- Remote
- #2642293
- OPPORTUNITY
- Awarded
Excel Expert |WordPress| Google Sheets |VBA & Google App Script | Woocommerce
![Top Endorsed Top Endorsed](https://dw3i9sxi97owk.cloudfront.net/uploads/prizes/badges/ffdd1b856a16c89191f1150e4430076b.png)
PPH TOP (79 Experts)Logo Designer|Graphic designer| Architect| Explainer Video Creator| Animator |Proofread|3D design | |Photoshop |
![Top Endorsed Top Endorsed](https://dw3i9sxi97owk.cloudfront.net/uploads/prizes/badges/ffdd1b856a16c89191f1150e4430076b.png)
Excel VBA, MS PRoject Expert, Web Scraper, Arena, Simulation, Spreadsheet, Wordpress customisation
![Top Endorsed Top Endorsed](https://dw3i9sxi97owk.cloudfront.net/uploads/prizes/badges/ffdd1b856a16c89191f1150e4430076b.png)
1053250301554927829772780631130044932824302744138956183226305854870014358895745
![Younis M.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/d527648114a46e84c9e3ddbab3332739_70x70.jpg)
![Muhammad Barkat H.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/3abcda39e25a9b90db8894602c9b543b_70x70.png)
![Raj K.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/e61a35f819a78ef9d6a610b5cacaa771_70x70.jpg)
![Baran B.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/03bd895bacb700eaeac5374e36e61f55_70x70.jpg)
Description
Experience Level: Entry
I'm looking for an excel expert to write a query/macro or similar to produce a specific set of complex actions in excel. I will attempt to explain what we need as follows;
One excel sheet will be the reference sheet (1) which will have a list of contacts including firstname, lastname, company name, email address.
the second excel sheet will be the active sheet (2) it will have a list of contacts including firstname, lastname, company name.
The macro will need to perform the following functions;
1. look at the company name in sheet 2 search for a match in sheet 1
2. when it finds a match look at the format for the email address in sheet 1 eg firstname.surname@***.com
3. create the email address in sheet 2 using the available firstname/lastname and the format and @***.com from sheet 1
it will also need to cope with other email formats eg initial.lastname@ etc
hopefully that makes sense, let me know if you have any queries.
thanks
One excel sheet will be the reference sheet (1) which will have a list of contacts including firstname, lastname, company name, email address.
the second excel sheet will be the active sheet (2) it will have a list of contacts including firstname, lastname, company name.
The macro will need to perform the following functions;
1. look at the company name in sheet 2 search for a match in sheet 1
2. when it finds a match look at the format for the email address in sheet 1 eg firstname.surname@***.com
3. create the email address in sheet 2 using the available firstname/lastname and the format and @***.com from sheet 1
it will also need to cope with other email formats eg initial.lastname@ etc
hopefully that makes sense, let me know if you have any queries.
thanks
![Nathan B.](https://www.peopleperhour.com/imgs/default_avatar_light_70x70.png)
Nathan B.
100% (37)Projects Completed
18
Freelancers worked with
18
Projects awarded
17%
Last project
6 Mar 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Are you able to share the spreadsheets or some sample data to show what can be done please. Also if you could expand a bit more on what the ultimate goal of this action is to achieve may help. Are you looking to then email to these people in which case a mail merge solution combined with word may be more beneficial.
Regards
874050
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