Hi guys!
I am pretty good with excel but not code. I think my issue is going to need code as I dont think this is possible with if/then. The master excel sheet is constantly added to, so I cant use a manual filter/copy/paste approach. I cant add an image so I put the column names below.
What I need is something to search columns 'Agent1' 'Agent2' 'Agent3' for names. If the name of the agent comes up, then the row needs to be copy/pasted into a separate sheet under their name. I.e Agent1 can be Justin, Agent2 can be Ben, and Agent3 column blank. I will need the row to copy/paste into separate sheets one for Justin and one for Ben. Another example- Vikram as Agent1 and Agent2 and 3 blank. The row will need to copy/paste into Vikram's sheet.
The purpose of this is so I can have a master sheet but individual sheets for further calculation purposes. It is too big/complicating to all do on the same sheet. Any help will be greatly appreciated! Excel 2016 on a PC.
<colgroup><col width="395"><col width="56"><col width="54"><col width="56"><col width="88"><col width="113"><col width="84"><col width="95"><col width="118"><col width="84"><col width="118"><col width="76"><col width="118"><col width="83"></colgroup><tbody>
</tbody>
I am pretty good with excel but not code. I think my issue is going to need code as I dont think this is possible with if/then. The master excel sheet is constantly added to, so I cant use a manual filter/copy/paste approach. I cant add an image so I put the column names below.
What I need is something to search columns 'Agent1' 'Agent2' 'Agent3' for names. If the name of the agent comes up, then the row needs to be copy/pasted into a separate sheet under their name. I.e Agent1 can be Justin, Agent2 can be Ben, and Agent3 column blank. I will need the row to copy/paste into separate sheets one for Justin and one for Ben. Another example- Vikram as Agent1 and Agent2 and 3 blank. The row will need to copy/paste into Vikram's sheet.
The purpose of this is so I can have a master sheet but individual sheets for further calculation purposes. It is too big/complicating to all do on the same sheet. Any help will be greatly appreciated! Excel 2016 on a PC.
Client/Property Address | Buyer | Seller | Status | close date | Price | % | GCI total | Agent1 | GCI Agent1 | Agent2 | GCI Agent2 | Agent3 | GCI Agent3 |
<colgroup><col width="395"><col width="56"><col width="54"><col width="56"><col width="88"><col width="113"><col width="84"><col width="95"><col width="118"><col width="84"><col width="118"><col width="76"><col width="118"><col width="83"></colgroup><tbody>
</tbody>