Create Excel Macro

Closed - This job posting has been filled and work has been completed.

Job Description

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.