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)

Rajasekar M.      
Rajasekar M.'s identity has been verified.  Learn More
 India  |  
I have 9 years experience in VB.net,VBA,VSTO,WPF.I am providing solutions for Microsoft Excel,Word ,PowerPoint ,Access ,Outlook ,Google API...
6
  |  
 3.7   |  Private   |  30 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 >100+ projects successfully delivered...
6
  |  
 4.5   |  $49,184 Earnings   |  55 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 8 years in Database technologies & software testing I am...
2
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 33222378  |  Submitted: Sep 3, 2012 08:04 ET 
Proposal SEALED

Miklos Kalozi      
Miklos Kalozi's identity has been verified.  Learn More
 Serbia  |  
We can not solve our problems with the same level of thinking that created them.
9
  |  
 4.9   |  Private   |  27 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
6
  |  
 4.5   |  Private   |  31 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...
6
  |  
 5.0   |  Private   |  4 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...
4
  |  
 5.0   |  Private   |  12 Jobs
Bid ID: 33161172  |  Submitted: Aug 31, 2012 06:06 ET 
Proposal SEALED

 Russia  |  
I provide VBA/macros, Excel automation and vb.net application solutions. Expertise in: -writing macroses, applications and add-ins for Excel...
Skills: VB.NET
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 33157886  |  Submitted: Aug 31, 2012 03:04 ET 
Proposal SEALED

Ioan Octavian G.      
Ioan Octavian G.'s identity has been verified.  Learn More
 Romania  |  
In theory many are good so instead talking much about myself I would prefer to prove my skills in practice. Still few words are needed: -15 years...
5
  |  
 5.0   |  Private   |  10 Jobs
Bid ID: 33150750  |  Submitted: Aug 30, 2012 19:04 ET 
Proposal SEALED
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »