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 home, work home without computer, tough questions, stat rankings, stat c, mysql data access, me excel, excel spreadsheet work home, c stat, best way work home, access work computer home, access home computer work, myql export update, excel update data form, excel makro update import, update data import excel, import update data, mysql export update, update excel data, uses excel, n excel, excel uses, best way get work, master excel, xml export

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