Hi
10 users are working on their own excel workbooks.
i have a master workbook. I need 10 users data in master workbook.
at least i need one cell value from 10 users. all the files are saved on same sharedrive.
and 10 users are working on 10 systems. i am working on my system. if i give cell reference from 10 excel files to master file it is not automatically updating. i need to open 10 files on my system then it is updating. without opening 10 files on my system this should update?
I need a macro/vba code/way to do this?
if we put one button on master file, it should retrieve all the data from 10 users.
is there any chance like this?
10 users are working on their own excel workbooks.
i have a master workbook. I need 10 users data in master workbook.
at least i need one cell value from 10 users. all the files are saved on same sharedrive.
and 10 users are working on 10 systems. i am working on my system. if i give cell reference from 10 excel files to master file it is not automatically updating. i need to open 10 files on my system then it is updating. without opening 10 files on my system this should update?
I need a macro/vba code/way to do this?
if we put one button on master file, it should retrieve all the data from 10 users.
is there any chance like this?