Create Excel Macro
Closed - This job posting has been filled and work has been completed.
I need a Macro created. Process is
1. Open 2 different Excel files
Merge files together
2. Use date field to delete data from today and yesterday only
Count total records
3. Create a formula that identifies if field > 500
4. For those records over 500
Create pivot table
5. For those records under 500
Add filter > Create pivot table
Add seperate filter > Create seperate pivot table
Probably best to set up a 30 minute Skype call to demo the process.