Data sorting [Closed]

Report
-
Posts
2673
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 26, 2020
-
Hi Folks,

I need your help in data sorting.

Basically I just want to automate the data to be sorted to another table, Names from table1 to table2 according to Reasons as shown below.

Table1:
Names std1 std2 std3 std4 std5
Reasons MC AL MC MC SL


Table2:
AL SL MC




Thank you for your help.
Jearnizck



2 replies

can it be done using if in macro?
Posts
2673
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 26, 2020
446
Hi Jearnizck,

When you select the second row of table 1 and apply Advanced Filter, check the unique records box and choose your destination where you want the result to be copied to. Result will be transposed, so transpose it back. Delete all unwanted data.

If you do all that while recording a macro, you can simply run the recorded macro to filter again.

But I've got a feeling I'm misunderstanding you. If I did then please explain in greater detail.

Best regards,
Trowa