Project Detail

Excel: refresh web queries and lock position of pictures  

Excel: refresh web queries and lock position of pictures is project number 197987
posted at Freelancer.com. Click here to post your own project.

 

| More Free Trial For New Buyers
 

Status:

Selected Providers: cykwong

Budget: $30-100

Created: 11/22/2007 at 22:26 EST

Bid Count: 9

Average Bid:
$ 68

11/27/2007 at 22:26 EST

Project Creator: nextlevelmedia
Employer Rating: 9.7222/109.7222/109.7222/109.7222/109.7222/109.7222/109.7222/109.7222/109.7222/109.7222/10 (36 reviews)

Bid On This Project
 

Description

Hello,
I have a spreadsheet that contains two worksheets. One sheet holds data, and the other contains a pivot table.

Data sheet:
The information in the data sheet is auto-populated using a web query pointing to an intranet url (so it may not work on your end).

Right now I have the data refreshing itself, but the user is prompted to "Enable data refresh". I would like to get rid of that and have the data refreshed through a macro.

The data is qualitative data; there's no numbers involved.

Pivot table:
I also have two pictures in the spreadsheet. I would like to "lock" the position so that users can't move them around, and that they don't move around when users resize columns.

And could you fix the print layout so that it's as legible as possible? Can this be done through a macro?

If you have any creative ideas on how to do this, or if you think of something cool to add, please let me know :)

Thanks,
M

ps: no generic bids please

Messages Posted:0 View project clarification board Post message on project clarification board

Bid On This Project
 

If you are the project creator or one of the bidders Log In for more options

 

80

3 days

11-23-2007 05:23 EST

VBA developer since 1997. Can do. Regards, Svet

help

 

50

0 days

11-25-2007 17:11 EST

Hi there, I am an expert in Excel and VBA. I can do this task no problems at all. Please note that I am based in the UK so some timing differences may occur. Kind regards Nash

help

 

60

1 day

11-24-2007 03:17 EST

Please PM me the part of the spreadsheet contain the drawings. I would like to see what it is and what print option will be best for it.

help

 

100

2 days

11-23-2007 02:40 EST

This sounds like the sort of thing we're good at, with our extensive Excel / VBA experience. Could you post a copy of the spreadsheet so that we can see what we'd be letting ourselves in for ? Some data from the URL would be good too - even we find it difficult to test code without data - but we can make some up if necessary. As long as there are no nasty surprises in the spreadsheet we could get it done over the weekend. Neil

help

 

70

1 day

11-23-2007 03:54 EST

, I finished this type of project early. It is one day job. On peut communiquer en français si vous voulez.

help

 

50

1 day

11-23-2007 00:06 EST

(No Feedback Yet)

Hi Check pm for detail Thanks

help

 

100

3 days

11-23-2007 03:17 EST

(No Feedback Yet)

have ideas how to do this job

help

 

30

3 days

11-23-2007 07:05 EST

(No Feedback Yet)

Hello; Let me have your file and go through. REgards

help

 

75

1 day

11-23-2007 09:14 EST

(No Feedback Yet)

Hi. I'm an Excel Jedi with 16 years of experience with many corporate clients including The Body Shop, Rolls-Royce Motor Cars and Estee Lauder. This doesn't sound too complicated. I'll turn this around for you in a day. Regards

help


    Bid on this Project