Create Excel Macro

Closed - This job posting has been filled and work has been completed.
IT & Networking Database Administration Posted 3 years ago

Fixed Price

Delivery by November 17, 2012




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.

About the Client

(5.00) 61 reviews

United Kingdom
London 11:11 PM

71 Jobs Posted
65% Hire Rate, 1 Open Job

$2,136 Total Spent
78 Hires, 0 Active

$5.12/hr Avg Hourly Rate Paid
139 Hours

Member Since Aug 7, 2009