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

Budget: $20
Delivery by November 17, 2012

Start Date

November 16, 2012

Details

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) 59 reviews

United Kingdom
London 04:38 AM

70 Jobs Posted
65% Hire Rate, 1 Open Job

$2,076 Total Spent
77 Hires, 1 Active

$5.12/hr Avg Hourly Rate Paid
139 Hours

Member Since Aug 7, 2009