176985602337900

Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Utility program needed for excel files
Sign in to Add to Watch List

IT & Programming > Software Application

View Change History

The client has made the following changes to the job.

Description
Date
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Thu, Aug 30, 2012
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:
    Anywhere

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: Not Sure
  • Fixed Price Job
  • Elance Escrow Protection
  • U.S. freelancers must have W9
Sign in to view client's details

First, let me describe each file I attached here for you.

1 - backup_products...... - This is my sample inventory exported to Excel from OpenCart.

2 - Backorders - This comes from my supplier and lists the items that are on back-order as well as the ones that are no longer on back-order.

3 - Clearance - This comes from the supplier. These are items that have limited availability.

4 - ProductFeed - this is the main product feed that comes from the supplier. I cut out most of the rows on this file, as it is a VERY large file.

You should note the the column SKU on the productfeed file and backup_products file and the Column ItemID on the Clearance and Backorder file are one and the same.

In essence, I would like to be able to run a report that does the following actions:
Based on my current inventory via the SKU.

Report 1 - Compare the items that are currently on Backorder to my inventory, report the results, change the the Quantity field (in the backup_products file) t...

Sign in or Register to see more

Desired Skills
.NET Framework, Java, PHP, VBA
Job ID: 33148907
 
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

OFFICE ADDINS | CAD PLUGINS |...      
One or more team members at  are verified.  Learn More
 India  |  
.Net and VBA expert with 15 years of experience on MS Office development(Excel,Powerpoint,Outlook,Visio) and CAD software customization(Proe...
4
  |  
 5.0   |  Private   |  4 Jobs
Bid ID: 33284210  |  Submitted: Sep 5, 2012 07:18 ET 
Proposal SEALED

 India  |  
Based out of Bangalore, Excel Technologies specializes in developing Customized Visual Basic, Microsoft Access, Microsoft Excel and VBA Solutions....
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 33244292  |  Submitted: Sep 4, 2012 02:35 ET 
Proposal SEALED

Rated top 1 percentile in Excel/VBA and Analytical capabilities, we are expert programmers and trainers with >500+ projects successfully delivered...
11
  |  
 4.9   |  $127,566 Earnings   |  75 Jobs
Bid ID: 33224142  |  Submitted: Sep 3, 2012 09:16 ET 
Proposal SEALED

 India  |  
Hi I am an experienced software professional and having experience of more than 10 years in Database technologies & software testing I am...
4
  |  
 5.0   |  Private   |  4 Jobs
Bid ID: 33222378  |  Submitted: Sep 3, 2012 08:04 ET 
Proposal SEALED

Miklós Kalózi      
Miklós Kalózi's identity has been verified.  Learn More
 Serbia  |  
"We can not solve our problems with the same level of thinking that created them."
7
  |  
 4.9   |  Private   |  32 Jobs
Bid ID: 33212098  |  Submitted: Sep 2, 2012 23:54 ET 
Proposal SEALED

Ahmed M.      
Ahmed M.'s identity has been verified.  Learn More
 Bangladesh  |  
Statistical Analyst cum Programmer
2
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 33198873  |  Submitted: Sep 2, 2012 05:10 ET 
Proposal SEALED

 India  |  
I have 5 years of experience in the .NET environment and worked on heterogeneous domains. Love to work on challenging projects and strive to...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 33191224  |  Submitted: Sep 1, 2012 14:52 ET 
Proposal SEALED

 United Kingdom  |  
Winner
Expert Excel and C# developer with over 10 years industry experience covering the engineering and financial sectors. Strong focus on delivering...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 33175966  |  Submitted: Aug 31, 2012 18:25 ET 
Delivery
Within 3 days
$98.63

 France  |  
Work in IT for 10 years as programmer, consultant and project manager. I'm expert in Excel / VBA development and I am regularly creating VBA...
1
  |  
 0.0   |  Private   |  3 Jobs
Bid ID: 33161172  |  Submitted: Aug 31, 2012 06:06 ET 
Proposal SEALED

 Russia  |  
I hold a Mathematics degree, worked at investment bank in reporting group, now working in one of big 4 accounting firm I provide VBA/macros, Excel...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 33157886  |  Submitted: Aug 31, 2012 03:04 ET 
Proposal SEALED

 Romania
-
5
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 33150750  |  Submitted: Aug 30, 2012 19:04 ET 
Proposal SEALED
Elance is now an Upwork company.
Upwork is the choise of 4M+ clients. Get started working on Upwork today.
Are you ready to post a job like this one?
Post a Similar Job »