Find word on Sheet1 move all adjacent column values to sheet2

feeders - Feb 4, 2015 at 02:38 PM
 feeders - Feb 4, 2015 at 02:39 PM
I have a list of accounts and information on items inside the accounts along with the account owner.
It goes like this, A= account number, B-J = item information, K = owner name
A certain owner may own account 1, 17, 34, 50 and 102. I need to make a sheet for each owner that displays only the information on each account that the certain owner owns. Can anyone help?


1 response

OH, also, each account will frequently be added to (by inserting rows) and I would like the owner sheets to automatically display the new information.