Đã hoàn thành

140065 MS Excel - connect 3 files

My client has 3 Excel files:

[url removed, login to view], [url removed, login to view], [url removed, login to view]

File1 is the Main file. File2 and File3 are sub files.

These files need to be connected in a simple way. We are looking for a quick and easy solution to do the follwing:

All 3 files have some identical columns.

Here is what client wants:

If the value of a field in [url removed, login to view] is changed, the value of the field in [url removed, login to view] and [url removed, login to view] needs to be change automatically.

For Example:

File1: Height = 10cm

File2: Height = 10cm

File3: Height = 10cm

Client wants to change Height = 20cm in all 3 files, but they only want to edit the Mainfile, not all 3 files.

We need some instructions how we can place a reference into the 2 Subfiles and refer to the value in the Mainfile. All 3 files are open in Excel all the time.

Additional note:

My client is using high security setting in Excel, so if possible we are looking to do this without Macro execution.

But I think that Macro might be required, if that's the case I will advise client to change the security settings.

If any questions let me know in PMB.

Who can help with this?



Kĩ năng: Bất kì công việc gì, Nhập liệu, Microsoft Access, MySQL, SQL

Xem nhiều hơn: excel macro how to, what is ms sql, what is macro in excel, ms sql client, ms excel help, file2, change security questions, need help with excel, ms-excel, ms excel, macro excel, macro + excel, excel to sql, excel to my sql, quick excel, edit macro, excel can open file, excel additional, connect using, excel macro reference, edit note file, files edit, edit macro excel, excel edit, excel macro open file

Về Bên Thuê:
( 81 nhận xét ) Wallkill,

ID dự án: #1886240

Được trao cho:


Please see pmb

$25 USD trong 0 ngày
(176 Đánh Giá)