Hi, Is there any idea how to perform this?
For an example:
Column: Accounts A B C D
Rows: TI
Rows: T2
The Logic is:
If Rows is T1,
Copy whole column A and paste to another excel.
Copy whole column B and paste to another excel.
Copy whole column C and paste to another excel.
If Rows is T2,
Copy whole column B and paste to another excel.
Copy whole column C and paste to another excel.
Copy whole column D and paste to another excel.
Thanks so much for those that contribute to this thread !