I am working on a file which needs to be copied and pasted into respective tabs based upon the name. For eg: in the below tablei have few columns data in excel which i want to segregate.
Name GL code RC amount description
ABCD 123456 98765 500 Food Expenses
EFGH 789101 84320 1000 travelling expenses
I have different tabs in the same sheet starting with the RC name ( 98765 - Kumar). I want the 98765 complete line to be copied from the data and pasted in the respective tab ( if there is a data already in 98765 - Kumar tab, then it should be pasted below the already existing data (it should not overwrite the previous data)