Ditutup

Syncing 3 Excel Spreadsheets with an Access database

I need to create the following setup.

- Two Shared excel workbooks, each with 6 tabs. different users should be able to use the workbook simultaneously.

- A macro on each of these tabs that sends the data on the spreadsheets to an access database. Whenever the data is sent from Excel to Access, the data is purged from excel.

-The access database appends any new data, notes the timestamp, as well as which one of the two spreadsheets the data comes from

-The third excel spreadsheet is linked to the database and pulls up the cumulative dataset. I should be able to refresh the page to pull new data. One tab from the third excel spreadsheet also has a pie chart that dynamically updates as the data is refreshed.

Thanks.

Kemahiran: Pemasukan Data, Pemprosesan Data, Excel

Lihat lebih lanjut: syncing data excel access, syncing excel workbooks access, syncing excel access, pie database, shared excel workbooks, timestamp, spreadsheets, macro excel, create access database spreadsheet, setup database excel, access chart, data syncing, refresh excel spreadsheet, refresh spreadsheet macro excel, access notes database, excel refresh, excel timestamp, create workbook, excel macro access, macro excel database, excel macro refresh, excel create macro, macro create spreadsheet excel, macro create excel spreadsheets, access database data entry

Tentang Majikan:
( 8 ulasan ) Poughkeepsie, United States

ID Projek: #1541752

9 pekerja bebas membida secara purata $30 untuk pekerjaan ini

Kamalkishover

We have done similar project, Pls Check PM

$30 USD dalam sehari
(210 Ulasan)
6.5
binaryromel

##### Excel expert here! Please check PM. #####

$30 USD dalam sehari
(44 Ulasan)
5.1
rakichowdhury

Please check PM for details.....

$30 USD dalam 3 hari
(20 Ulasan)
4.4
shahalam00

Iam dataentry expert.

$30 USD dalam 7 hari
(0 Ulasan)
0.0
diponkar43

hi. im ready to start.

$30 USD dalam 3 hari
(0 Ulasan)
0.0
gauravbe

I've executed several of such projects. This will not take me more than couple of hours to complete and send it to you.

$30 USD dalam sehari
(0 Ulasan)
0.0
eegoogleplusfbf

Please check PMB

$30 USD dalam sehari
(0 Ulasan)
0.0
jaken05

i work in power plant , and i made a simple application that alike with what you want. i am familliar with excel , access, and VBA

$30 USD dalam 2 hari
(0 Ulasan)
0.0
abhidmaestro

I am a manual Test Engineer for one of the reputed software companies in India.I have been working on spreadsheets since the last few years. I am new to freelancing and thus have a lot of enthusiasm in performing th Lagi

$30 USD dalam 2 hari
(0 Ulasan)
0.0