Sedang Disiapkan

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

Kemahiran: Excel, Visual Basic, XML

Lihat lebih lanjut: 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

Tentang Majikan:
( 14 ulasan ) Shawnee, United States

ID Projek: #290605

Dianugerahkan kepada:

xamdam91

Looking forward to working with you.

$100 USD dalam 0 hari
(60 Ulasan)
6.1

12 freelancers are bidding on average $103 for this job

creatorul

Professional work.

$250 USD dalam sehari
(79 Ulasan)
7.0
simonchen

Plz check PM.

$250 USD dalam 14 hari
(13 Ulasan)
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 Lagi

$40 USD dalam 0 hari
(17 Ulasan)
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 dalam 0 hari
(5 Ulasan)
2.8
macejd

Hi sendsley, please check PM for my suggestion.

$50 USD dalam 3 hari
(6 Ulasan)
2.7
dnugraha

details on pm

$75 USD dalam 5 hari
(2 Ulasan)
0.0
VSRawat

please see my PM.

$100 USD dalam 3 hari
(0 Ulasan)
0.0
chongsa

Check my PM. thanks.

$150 USD dalam 7 hari
(0 Ulasan)
0.0
nehalpandya

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

$50 USD dalam 2 hari
(0 Ulasan)
0.0
shoh

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

$100 USD dalam 2 hari
(0 Ulasan)
0.0
rmukeshauto

Quality and Documentation guaranteed.

$30 USD dalam 5 hari
(0 Ulasan)
0.0