Calculation/Match in Excel for emails
- or -
Post a project like this2709
$$$
- Posted:
- Proposals: 15
- Remote
- #1335902
- Awarded
Business tools for today's environment using Excel, Access & VBA scripts...
Stoke-on-Trent
PowerPoint Template design | Brand Identity | Logo Design | UX design | Print design | Website design
Houston
139184213940151415095
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