I gang

Excel Data Import, Export, Update

I'm not even sure where to start. I think this isn't all that tough to do I just don't think I can get it done without a lot of headaches so I'm reaching out. I'm looking for a suggestion and the ability for you to modify my current spreadsheet to work the way I envision it.

Here's what I have now. Our website [url removed, login to view] offers a spreadsheet to members that uses a macro to customize player rankings based on projected stats that are stored on several worksheets within the workbook. I then update the spreadsheet projections daily and then members must download the newest version to get the updates.

What I what is for my members, with their local spreadsheet saved to their home computer to be able to click a button to get the latest projections. This will then get the latest data for the stat projection worksheets from my main, master copy or this data stored somewhere (table on web, access db on a server, MySQL on my webhost, ???) remotely.

So - what is the best way to accomplish this that is easy for my members (click button in spreadsheet to get latest projections) and is easy for me updating the data on the master - easy export to XML file and upload, just save the excel file, export to MySQL, export to Access. Whatever is easy for me that remains secure and easy to access for my users will win the bid! I will then need you to modify the spreadsheet so I can provide my users with a version with the aforementioned update data button rather than the updated master as I currently provide.

Follow all that......?

Please e-mail with any questions.

Thanks

Færdigheder: Excel, Visual Basic, XML

Se mere: work remotely from home, work home without computer, work from home without a computer, what is the best way to work from home, tough questions, stat rankings, stat c, mysql data access, me excel, excel spreadsheet work from home, excel macro to get data from website, excel &, db import export, c stat, com stat, can i access my home computer from work, best way to work from home, access my work computer from home, access home computer from work, myql export update, excel update data form, excel makro update import, button import update data access, using bids import excel data, excel button update data

Om arbejdsgiveren:
( 14 bedømmelser ) Shawnee, United States

Projekt-ID: #290605

Tildelt til:

xamdam91

Looking forward to working with you.

$100 USD in 0 dage
(60 bedømmelser)
6.1

12 freelancere byder i gennemsnit $103 for dette job

creatorul

Professional work.

$250 USD på 1 dag
(79 bedømmelser)
7.0
simonchen

Plz check PM.

$250 USD in 14 dage
(13 bedømmelser)
5.3
NashTrump

hi there, Extremely easy this. I can do this for you in a matter of half an hour. I am an expert vba programmer and can link up excel to the internet very easily. Let me know if you want a demostration. Kin Mere

$40 USD in 0 dage
(17 bedømmelser)
4.7
mcgrogan40

It seems easy as it is! An Excel based query and some associated formatting should get you to where you want to be :)

$35 USD in 0 dage
(5 bedømmelser)
2.8
macejd

Hi sendsley, please check PM for my suggestion.

$50 USD in 3 dage
(6 bedømmelser)
2.7
dnugraha

details on pm

$75 USD in 5 dage
(2 bedømmelser)
0.0
VSRawat

please see my PM.

$100 USD in 3 dage
(0 bedømmelser)
0.0
chongsa

Check my PM. thanks.

$150 USD in 7 dage
(0 bedømmelser)
0.0
nehalpandya

I am verry good in excel and window, pls check my pm

$50 USD in 2 dage
(0 bedømmelser)
0.0
shoh

We have 5 years of Excel/VBA experience. And this project seems really easy.

$100 USD in 2 dage
(0 bedømmelser)
0.0
rmukeshauto

Quality and Documentation guaranteed.

$30 USD in 5 dage
(0 bedømmelser)
0.0