Spreadsheet: 718038d1612961308-copy-rows-based-on-cell-value-home-finances-sample-for-excel-forum
Sheet: Sheet1

 | January |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Emergency Account |  |  |  |  |  |  | Flex Saver Account
 | TOTAL MONTHLY INCOME |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL MONTHLY SAVINGS |  |  | CLOSING BALANCE |  |  |  |  |  |  | BALANCE |  |  |  |  |  |  |  | BALANCE
 | SUM OF D20:D58 |  |  |  |  |  |  |  |  |  |  |  |  | SUM OF R20:R58 |  |  | TOTAL INCOME-TOTAL EXPENSES-TOTAL SAVINGS |  |  |  |  |  |  | SUM OF Z20:Z58 |  |  |  |  |  |  |  | SUM OF AG20:AG58
 |  | Monthly Income |  |  |  |  |  |  |  |  |  |  |  |  | Monthly Savings |  |  |  |  |  |  |  |  | Monthly Savings |  |  |  |  |  |  |  | Monthly Savings
 | ITEM | DUE DATE | AMOUNT |  |  |  |  |  |  |  |  |  |  | DATE | ACCOUNT | DEBIT | CREDIT |  |  |  |  | DATE |  | ACCOUNT | DEBIT | CREDIT |  |  |  | DATE |  | ACCOUNT | DEBIT | CREDIT
 |  |  |  | True
 | Income 1 | 2021-09-22 00:00:00 | 0 | False |  |  |  |  |  |  |  |  |  | 2020-09-23 00:00:00 | TR. To Emergency Account |  | 0 | False |  |  |  | 2020-09-23 00:00:00 |  | TR. To Emergency Account |  | 0 | False |  |  | 2020-09-23 00:00:00 |  | TR. To [NAME] |  | 0 | False
 | Income 2 | 2021-09-21 00:00:00 | 0 | False |  |  |  |  |  |  |  |  |  | 2020-09-23 00:00:00 | TR. To [NAME] |  | 0 | False |  |  |  | 44097 |  |  |  |  | False |  |  |  |  |  |  |  | False
 | TR. From Emergency Account into Personal Account | 2021-09-24 00:00:00 | 0 | False |  |  |  |  |  |  |  |  |  | 2021-09-24 00:00:00 | TR. From Emergency Account into Personal Account | 0 |  | False |  |  |  |  |  |  |  |  | False |  |  |  |  |  |  |  | False
 | TR. From Flex Saver into Personal Account | 2021-09-27 00:00:00 | 0 | False |  |  |  |  |  |  |  |  |  | 2021-09-27 00:00:00 | TR. From Flex Saver into Personal Account | 0 |  | False |  |  |  |  |  |  |  |  | False |  |  |  |  |  |  |  | False
 |  |  |  | False |  |  |  |  |  |  |  |  |  |  |  |  |  | False |  |  |  |  |  |  |  |  | False |  |  |  |  |  |  |  | False
 |  |  |  | False |  |  |  |  |  |  |  |  |  |  |  |  |  | False |  |  |  |  |  |  |  |  | False |  |  |  |  |  |  |  | False
 |  |  |  | False |  |  |  |  |  |  |  |  |  |  |  |  |  | False |  |  |  |  |  |  |  |  | False |  |  |  |  |  |  |  | False
 |  |  |  | False |  |  |  |  |  |  |  |  |  |  |  |  |  | False |  |  |  |  |  |  |  |  | False |  |  |  |  |  |  |  | False
 |  |  |  | False |  |  |  |  |  |  |  |  |  |  |  |  |  | False |  |  |  |  |  |  |  |  | False |  |  |  |  |  |  |  | False
 |  |  |  | False |  |  |  |  |  |  |  |  |  |  |  |  |  | False |  |  |  |  |  |  |  |  | False |  |  |  |  |  |  |  | False
 |  |  |  | True |  |  |  |  |  |  |  |  |  |  |  |  |  | False |  |  |  |  |  |  |  |  | False |  |  |  |  |  |  |  | False
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EMERGENCY ACCOUNT |  |  |  |  |  |  |  | FLEX SAVER
 | B20-B137 is a Searchable Drop Down Menu, which I have accomplished by creating Tables in a |  |  |  |  |  |  |  |  |  |  |  |  | P20-P58 is a Searchable Drop Down Menu, which I have accomplished by creating Tables in a |  |  |  |  |  |  |  | Y20-Y58 is a Searchable Drop Down Menu, which I have accomplished by creating Tables in a |  |  |  |  |  |  |  | AG20-AG58 is a Searchable Drop Down Menu, which I have accomplished by creating Tables in a
 | separate worksheet entitled MasterData. |  |  |  |  |  |  |  |  |  |  |  |  | separate worksheet entitled MasterData. |  |  |  |  |  |  |  | separate worksheet entitled MasterData. |  |  |  |  |  |  |  | separate worksheet entitled MasterData.
 | I also have an issue with this: |  |  |  |  |  |  |  |  |  |  |  |  | I also have an issue with this: |  |  |  |  |  |  |  | You guys assisted me to accommplished this by the following formulas: |  |  |  |  |  |  |  | You guys assisted me to accommplished this by the following formulas:
 | When I type the first letter or few letters into the searchable dropdown and click on the arrow, |  |  |  |  |  |  |  |  |  |  |  |  | When I type the first letter or few letters into the searchable dropdown and click on the arrow, |  |  |  |  |  |  |  | In W20 -  =IFERROR(INDEX($O$20:$O$58,AGGREGATE(15,6,(ROW($O$20:$O$58)-ROW($O$19))/ |  |  |  |  |  |  |  | In AE20 - =IFERROR(INDEX($O$20:$O$58,AGGREGATE(15,6,(ROW($O$20:$O$58)-ROW($O$19))/
 | it displays the full dropdown list, instead of the sorted list, i.e. if I were to type EME, the results |  |  |  |  |  |  |  |  |  |  |  |  | it displays the full dropdown list, instead of the sorted list, i.e. if I were to type EME, the results |  |  |  |  |  |  |  | (ISNUMBER(SEARCH(Y$61,$P$20:$P$58))),ROWS($A$1:$A1))),"") |  |  |  |  |  |  |  | (ISNUMBER(SEARCH(AG$61,$P$20:$P$58))),ROWS($A$1:$A1))),"")
 | would be the entire list, instead of TR. To Emergency Account. |  |  |  |  |  |  |  |  |  |  |  |  | would be the entire list, instead of TR. To Emergency Account.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Y20 - =IF(ISNUMBER(W20),"TR. To Emergency Account","") |  |  |  |  |  |  |  | In AG20 - =IF(ISNUMBER(AE20),"TR. To [NAME]","")
 | I can only accomplish this by clicking away from the cell that contains the dropdown list and |  |  |  |  |  |  |  |  |  |  |  |  | I can only accomplish this by clicking away from the cell that contains the dropdown list and
 | then re-clicking that cell and the list then updates with the correct options for me to select. |  |  |  |  |  |  |  |  |  |  |  |  | then reclicking that cell and the list then updates with the correct options for me to select. |  |  |  |  |  |  |  | In AA20 - =IF(Y20="","",INDEX($R$20:$R$58,AGGREGATE(15,6,(ROW($O$20:$O$58)-ROW($O$19))/ |  |  |  |  |  |  |  | In AI20 - =IF(AG20="","",INDEX($R$20:$R$58,AGGREGATE(15,6,(ROW($O$20:$O$58)-ROW($O$19))/
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (ISNUMBER(SEARCH(Y$61,$P$20:$P$58))),ROWS($A$1:$A1)))) |  |  |  |  |  |  |  | (ISNUMBER(SEARCH(AG$61,$P$20:$P$58))),ROWS($A$1:$A1))))
 | **  I AM [NAME] IF IT’S A DESIGN ISSUE OR A MAC ISSUE  ** |  |  |  |  |  |  |  |  |  |  |  |  | **  I AM [NAME] IF IT’S A DESIGN ISSUE OR A MAC ISSUE  **
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], when selected, will fill entire rows, W20:AB20 with the corresponding blue above, |  |  |  |  |  |  |  | [NAME], when selected, will fill entire rows, AE20:AJ20 with the corresponding blue above,
 | [NAME], when selected, will fill entire rows, [NAME]:E20 with the corresponding blue above, |  |  |  |  |  |  |  |  |  |  |  |  | When, 'TR. To Emergency Account' is selected from Drop Down Menu in Column P and it’s a 'CREDIT' amount. |  |  |  |  |  |  |  | for example and strikeout the transaction. |  |  |  |  |  |  |  | for example and strikeout the transaction.
 | for example and strikeout the transaction. |  |  |  |  |  |  |  |  |  |  |  |  | I would like the actual date, account and amount to be copied into their respective, columns,
 |  |  |  |  |  |  |  |  |  |  |  |  |  | for example, into, W20, Y20 AND AA20.
 |  |  |  |  |  |  |  |  |  |  |  |  |  | or
 |  |  |  |  |  |  |  |  |  |  |  |  |  | When, 'TR. To Flex' is selected from Drop Down Menu in Column P  and it’s a 'CREDIT' amount.
 |  |  |  |  |  |  |  |  |  |  |  |  |  | I would like the actual date, account and amount to be copied into their respective, columns,
 |  |  |  |  |  |  |  |  |  |  |  |  |  | for example, into, AE20, AG20 and AI20 instead.
 |  |  |  |  |  |  |  |  |  |  |  |  |  | HOWEVER, ADDITIONALLY I WOULD NOW LIKE SOME ASSISTANCE WITH THE FOLLOWING:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | When, 'TR. From Emergency Account' is selected from Drop Down Menu in Column P and it’s a 'DEBIT' amount.
 |  |  |  |  |  |  |  |  |  |  |  |  |  | I would like the actual date, account and amount to be copied into their respective, columns,
 |  |  |  |  |  |  |  |  |  |  |  |  |  | for example, account into [NAME], date into C20 and amount into D20, as well as still copying 'TR. From Emergency Account' into Y20,
 |  |  |  |  |  |  |  |  |  |  |  |  |  | the respective date into W20 and the Debit amount into Z20.
 |  |  |  |  |  |  |  |  |  |  |  |  |  | or
 |  |  |  |  |  |  |  |  |  |  |  |  |  | When, 'TR. From Flex' when is selected from Drop Down Menu in Column P and it’s a 'DEBIT' amount.
 |  |  |  |  |  |  |  |  |  |  |  |  |  | I would like the actual date, account and amount to be copied into their respective, columns,
 |  |  |  |  |  |  |  |  |  |  |  |  |  | for example, into, account into [NAME], date into C20 and amount into D20, as well as still copying 'TR. From Flex' into AG20,
 |  |  |  |  |  |  |  |  |  |  |  |  |  | the respective date into AE20 and the Debit amount into AH20.
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], when selected, will fill entire rows, O20:S20 with the corresponding blue above,
 |  |  |  |  |  |  |  |  |  |  |  |  |  | for example and strikeout the transaction.