ManUBlueJay
Active Member
- Joined
- Aug 30, 2012
- Messages
- 304
- Office Version
- 2016
- Platform
- Windows
I have a table (Table1) in one file called File1 that is linked to the data in another file we will call "File2. The Data is not in a table. It starts in A3, will always be 6 Cols wide, but will have different number of Rows
Is there a way to update the size of table1 in File1 without opening file 2.
This can either be using VBA or a function that counts the rows in File2.
The only way I can manage is opening the file which I would like to avoid.
Cheers in advance
Is there a way to update the size of table1 in File1 without opening file 2.
This can either be using VBA or a function that counts the rows in File2.
The only way I can manage is opening the file which I would like to avoid.
Cheers in advance