Refresh Multiple Excel Sheets at Once

$30-250 USD

Closed

Posted

over 6 years ago

$30-250 USD

Paid on delivery

I work for a company that sends out report cards to around 350 suppliers. The report cards are in Excel and contain around 13 tabs. Data is fed to the excel report cards by an Access database and have to be opened up and manually refreshed using the "Refresh All" button in the Data tab in excel. I want an Access database or tool that will refresh all report cards at the click of a button. My vision is that the Access database has a main screen with only 2 buttons. One being the Refresh All button and the second button opening up a list of all the links to the report card. This list can be edited as needed, with records being added or deleted as well. The database would update the report cards based on their link address.

Software Architecture

Windows Desktop

Project ID: 15330488

About the project

17 proposals

Remote project

Active 6 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

17 freelancers are bidding on average $174 USD for this job

@aanvikm

Hello Sir, I am an expert with MSAccess and VBA and I should be able to help with this issue. Could you please share the excel with me for review? Thanks Aanvik Relevant Skills and Experience VBA, Excel Proposed Milestones $155 USD - Milestone

$155 USD in 3 days

5.0

(45 reviews)

6.8

@rinabuoy13

Creating control tool to refresh all excel tabs Relevant Skills and Experience Very well versed in excel, vba, database etc. Proposed Milestones $222 USD - final deliverable

$222 USD in 3 days

5.0

(69 reviews)

6.2

@paris2785

Hi, my name is Paris. By reading your project's scope two options come to my mind, either an Access-based or an Excel-based solution. Relevant Skills and Experience I have 7 years experience in designing and developing MS Access database as well as Excel spreadsheets filled with formulas and VBA code. Proposed Milestones $200 USD - Deliver final version of the file. The milestone will be released only if you are happy with it. I'd like to have a short chat with you to develop my ideas further. I am looking forward to.

$200 USD in 7 days

4.9

(60 reviews)

6.4

@P0L

Hello, I’m an Excel VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss. Regards.

$200 USD in 3 days

5.0

(23 reviews)

5.5

@katilinas

Hello, I can provide solution for refreshing Multiple Excel Sheets at Once. I like your idea about Access database with only 2 buttons, it can be implemented. Relevant Skills and Experience Excel VBA, Access VBA, Microsoft AddIn's Proposed Milestones $60 USD - code to update data $70 USD - add In with two buttons

$130 USD in 3 days

5.0

(8 reviews)

4.1

@huongth

Hi. I can create auto scripts to scrape websites, auto click, format txt, csv, xls, xlsx, doc, docx, rtf, json, xml, database files as you request. I can start right now Relevant Skills and Experience I am an expert in VBA, VBScript, Visual Basic, C#, F#, C, C++, ASM, Delphi, Java, iMacros, Flash, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle Proposed Milestones $100 USD - complete

$100 USD in 3 days

4.6

(15 reviews)

4.1

@freelancerkpis

We are happy to bid on this project. We provides dedicate developers and Development and design services as well. ***** We are having a great team of Mobile developers with 7-8 years of experience Relevant Skills and Experience Software Architecture,Windows Desktop, Proposed Milestones $277 USD - Complete project

$277 USD in 3 days

5.0

(1 review)

3.7

@elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards Habilidades y experiencia relevante VBA Htos propuestos $200 USD - final delivery

$200 USD in 5 days

5.0

(10 reviews)

3.8

@The24CarrotsInc

A proposal has not yet been provided

$100 USD in 1 day

5.0

(10 reviews)

3.4

@tbrifki64

Reading your short description, I anticipated that it can also be done by creating small tools using C# or Visual Basic. The final product will be executable file functioning as described. Relevant Skills and Experience I am able to write code to solve the problem. Proposed Milestones $150 USD - Upon Award Do you depend on the current version of Ms Office (2010 and 2013) or will change to a new version?

$150 USD in 5 days

0.0

(1 review)

0.0

@abhisheksura

I understand your requirements clearly, and think it would be better to have an Excel macro that can refresh the spreadsheets. I have created similar macros in the past and can turnaround quickly. Relevant Skills and Experience I am an experienced VBA developer with extensive expertise in Excel spreadsheets. In my experience as a freelancer, I have worked with a variety of macros across multitude of businesses. Proposed Milestones $50 USD - First draft $61 USD - Final document with the tool Are the spreadsheets stored locally or are they stored online? Please PM for a sample of the tool.

$111 USD in 3 days

0.0

(0 reviews)

0.0

@maheshashetty

I have 13 years+ experience in handling MIS in top . I would be providing an application for your desktop which on clicking will refresh the excel sheet automatically from your access database. Relevant Skills and Experience 13+ years of Experience in Ms Office, Ms Access, Visual basic and analytical skills

$155 USD in 3 days