If column match with rows, copy column one by one and paste to another excel

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 !

1 Like

Kindly elaborate this logic…sorry I didn’t get this @mashy2

Hi,

1.If one of the rows matches with column A, then it will copy entire column A and paste column A data to another excel.

2.Then it will loop again to next column, if columns dont match with rows then it will skip the rows.

3.If next column matches, it will repeat step 1 :slight_smile:

May I know from where this row value is coming is it from another excel or that part only I didn’t get buddy
Sorry to trouble…
Cheers @mashy2

It came from same excel but on the first column of the excel