Find freelancers. Lose those costly delays.

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

or, Register with Elance »

Refresh Excel named range with JSON data from Smartsheet
Sign in to Add to Watch List

IT & Programming > Other IT & Programming

View Change History

The client has made the following changes to the job.


Job awarded.

May 13, 2013

Job Description

  |  Change History >>


  • Posted: Fri, May 10, 2013
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:

    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: $100 or less
  • Fixed Price Job
  • Elance Escrow Protection
  • W9 Not Required
Sign in to view client's details

Smartsheet (  [obscured]  ) is an on-line project management tool that I use to maintain on-line data. Smartsheet has recently released an API (  [obscured]  /developers/api-documentation) allowing developers direct access to Smartsheet data.

I would like to be able to refresh a named range in an Excel worksheet with the data that I track in Smartsheet. I would like to right-click on the named range in Excel, click refresh, and have the system send an API call to Smartsheet (see attachment) and refresh the named range in Excel with the updated data returned from the Smartsheet API call. There are many ways to do this in Excel...macro, VBA, Get External Data...I will choose the winning bidder based on the approach defined in the proposal. Please briefly describe your approach when you submit your proposal.

The attachment named "commands.txt" has two cURL commands (in order to run the commands, you need to have cURL installed on your computer.)

1. The first comma...

Sign in or Register to see more

Desired Skills
Job ID: 41382505
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 India  |  
Expert programmer with multiple skills... 1. Office Automation - MS Excel Expert with deep knowledge of VBA/Macros and Formulas. Extensive...
 5.0   |  Private   |  5 Jobs
Bid ID: 41405776  |  Submitted: May 11, 2013 14:12 ET 
Within 3 days
Elance is now an Upwork company.
Upwork is the choice of 4M+ clients. Get started working on Upwork today.
Are you ready to post a job like this one?
Post a Similar Job »