Karthikeyanbt
New Member
- Joined
- Oct 5, 2023
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
I have multiple .xlsm files in a folder. I want to compile data from a specific sheet from all the files and edit the data there which should update the respective source file in the folder.
I consolidated data using MS-Excel>Data>Get Data> From file> from folder option. I tried macros but in vein. I also tried Microsoft access but it showed This Recordset is not updatable. Expecting - Editable Masterdata for xlsm files.
I consolidated data using MS-Excel>Data>Get Data> From file> from folder option. I tried macros but in vein. I also tried Microsoft access but it showed This Recordset is not updatable. Expecting - Editable Masterdata for xlsm files.