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.
I've got the lists in Microsoft Excel. And I would like to have the list calculated with Excel/VBA.
Rob H.100% (37)
Create an account now and send a proposal now to get this project.Sign up
Clarification Board Ask a Question
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.
Could you share me both XLS files ?