Calculation/Match in Excel for emails
- or -
Post a project like this2716
$$$
- Posted:
- Proposals: 15
- Remote
- #1335902
- Awarded
Excel Expert, Excel Spreadsheets, Excel VBA & Access Database Developer, Data modelling & Analysis
London
Excel Dashboard, Reporting Expert | VBA, Macros |Business Intelligence and Data Analytics | Power BI | Financial Analysis | Google Spreadsheet Design and Scripting | Python Expert | MT4 | MT4 Manager
Pune
MBA Global Business Strategy, Export Bussiness Developement, Study Methods Teacher, Excel Developer, Amateur artist, Seller,
Lima
104128890327128156270269328852486495573552649865968368102532712280501390210
Description
Experience Level: Expert
Calculation/Match in Excel for emails
We are having a marketplace, different categories and worldwide. Users can sign up to get notified about new advertisements. But they can choose if they want requested and/or offered ads, they can select some categories which they want to see, if they would like to receive emails weekly or daily. The distance from their location to location of the advertisement.
What I want, is one list, that I can fill in one date, and that I can see in a report who needs which email at what time. So we need to match the two reports below.
I've already got two list with all the information:
1. Export from users with notification settings (Name Email Signup URL Member Group Selection Type Selection Frequency Selections Radius Zipcode)
2. ID Name Description Thumbnail Offered / Requested URL Category Location When daily, then emailed at: When weekly, then emailed at: Group
What we need :
One click on a button (or filling in date), to calculate which advertisements need to go to which user.
Skills:
I've got the lists in Microsoft Excel. And I would like to have the list calculated with Excel/VBA.
We are having a marketplace, different categories and worldwide. Users can sign up to get notified about new advertisements. But they can choose if they want requested and/or offered ads, they can select some categories which they want to see, if they would like to receive emails weekly or daily. The distance from their location to location of the advertisement.
What I want, is one list, that I can fill in one date, and that I can see in a report who needs which email at what time. So we need to match the two reports below.
I've already got two list with all the information:
1. Export from users with notification settings (Name Email Signup URL Member Group Selection Type Selection Frequency Selections Radius Zipcode)
2. ID Name Description Thumbnail Offered / Requested URL Category Location When daily, then emailed at: When weekly, then emailed at: Group
What we need :
One click on a button (or filling in date), to calculate which advertisements need to go to which user.
Skills:
I've got the lists in Microsoft Excel. And I would like to have the list calculated with Excel/VBA.
Rob H.
100% (47)Projects Completed
56
Freelancers worked with
50
Projects awarded
41%
Last project
6 Aug 2021
Netherlands
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Dear Robs,
A dynamic automated excel template can help you i performing the task.
If you would like to find out more about dynamic automated excel template, please feel free to contact me.
Regards,
Hazel -
Hi Rob,
Could you share me both XLS files ?
Thanks
Sumit
SaS Technologies
208234204169
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