Donaldducks
New Member
- Joined
- Feb 22, 2021
- Messages
- 1
Hi all,
I would like to write a vba to specifically explore the 'report' tab in the same folder (About 100 workbooks). All the data is the same formula in the report tab. Column A1:N1 is the header and A2:N2 is the data (ex: A1 - Account Number, A2: 123456 - as the account #, B1 - Name, B2: ABC Company).
So the end result should be A1:N1 as the column name and A2:N100 should be all the different data (ex: A1 account number, A2:A100 are all the diff account number)
Thank you!!
I would like to write a vba to specifically explore the 'report' tab in the same folder (About 100 workbooks). All the data is the same formula in the report tab. Column A1:N1 is the header and A2:N2 is the data (ex: A1 - Account Number, A2: 123456 - as the account #, B1 - Name, B2: ABC Company).
So the end result should be A1:N1 as the column name and A2:N100 should be all the different data (ex: A1 account number, A2:A100 are all the diff account number)
Thank you!!