Copy entire row range based on data in one cell.

Copper Contributor

I am trying to create a spreadsheet whereby data is entered into the main register on the sheet labeled "Check Register". I have a column labeled "T-Account" with three options. I want to create three additional sheets, based on the data in the column "T-Account" I want to copy the entire row to the corresponding sheet. In the end, my goal is to have the main check register show the total of how much money is in the account, the three other pages will show the break down of how much money is allocated to the associated "T-Account". 

I sure would appreciate any help I can get on this.

0 Replies