Excel sheet acting as user form

[sanket_sk]

Hi All,


I am looking for solution where multiple users can update some data in local excel sheet which and it will get transferred to central excel which will be located on one drive.


Our Limitations –

Our organisation is not allowing to use Google Form . Google drive, We have MS form , One Drive and share drive in which we can share access of one drive to some extent but SharePoint cant be shared with out sliders how ever we want them to share details.


Is there any way ( VBA, Export Technic ) which will help is purpose, just hint can also help.


Sanket

 

[MrSyyr]

Hi,
If your local worksheets are all stored in a shared drive, but only updated by one person each, then try importing data this data to another, collation worksheet, where you have all the data. Then you can refresh the data easily from the collate worksheet.
Does that sound like it might work you you?