Moving a row that meets certain criteria fom one worksheet to another worksheet

Hi

I have an 'AA' worksheet. When I select 'AAC' I'd like that row to move to the first empty row to 'BB'worksheet. Also, when I select 'AAD' I'd like that row to move to the 'CC' worksheet. The cell that will contain 'AAC', 'AAD' or other values will be in DS column.And I'd like the rows from the 'AA' worksheet to move up so there is no blank row once a row is moved either to 'BB' or 'CC' worksheet.The Worksheets contain formulas and have a header (row 1&2) in each worksheet.I have tried for days to work out the coding for it and I just cant get anything to work. . Please please help

You first record the macros whatever you want to do. Then interlink (call the macros) based on your condition with proper if condition.

Krishna
https://www.youtube.com/watch?v=lcMF...mYYcDwGCD9-P-X

Hi,
Thank you for your reply, unfortunately I am not very experienced with macros