hello,
I'm trying to find a way to pull worksheets from different workbooks and combine them into one master worksheet. The ranges are dynamic so they will be updated ever hour or so I'd like to have a macro that, when ran, combines them into one worksheet.
The workbooks are always open on their respective computers and are shared over a private network with no internet.
Also, this probably belongs in the Access forum, but is there a way to update an excel file that is opened as a linked table in Access without closing the table in Access first? I get an error that the file is locked.
I'm trying to find a way to pull worksheets from different workbooks and combine them into one master worksheet. The ranges are dynamic so they will be updated ever hour or so I'd like to have a macro that, when ran, combines them into one worksheet.
The workbooks are always open on their respective computers and are shared over a private network with no internet.
Also, this probably belongs in the Access forum, but is there a way to update an excel file that is opened as a linked table in Access without closing the table in Access first? I get an error that the file is locked.