Create Excel Macro

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

Fixed Price

Delivery by November 17, 2012

$20.00

Budget

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

United Kingdom
London 01:50 PM

67 Jobs Posted
65% Hire Rate, 1 Open Job

$2,001 Total Spent
75 Hires, 0 Active

$5.12/hr Avg Hourly Rate Paid
139 Hours

Member Since Aug 7, 2009