vba to process file based on cell value

[lynnsong986]

Hello, I need help with the following task:

I have a transaction tab named "Data" with many individual transactions listed in a workbook. one of the columns (column L) has account strings. In the same workbook, i have many other tabs containing transactions for each account. I need to loop through all the tranasactions in "Data" tab and compare cell content in column L (starting in row 6) to cell value A1 of each selected other tabs. (A1 on these other tabs has account string), if a particular cell in column L on "data" tab in the looping process matches A1 content in one of the other tabs (one worksheet for each account string here), the code will then copy that entire row in "data" tab and paste it on the matched tab after finding last row on that tab. I wrote something but it didn't work. Can someone pls take a look and fix it?? thx so much.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. Part of the reason for this is to preserve indentation, but you didn't use indentation so I added that too. It is recommended. --6StringJazzer

Please Login or Register  to view this content.