Hi all. I have combined several sub routines into one worksheet change. I have the master report (SIGN_IN) and I am transferring Data between 3 other sheets (CREDIT_CARD) (HP_DEPOSIT) and (CAP_PD_DEPOSIT). I keep getting error "End If without Block If" error and augment not required to part of my code using statement Range("O" & Target.Row). I have attached a sample workbook with the sheets. Please help me get this working. All help is appreciated!
I also have the (HP_DEPOSIT) and (CAP_PD_DEPOSIT) that does not transfer properly. When "RLMO" or "RPMO" is entered into column K if column O is blank ("") then the transfer is to (HP_DEPOSIT) and if column O has "X" then the transfer is to go to (CAP_PD_DEPOSIT) but it all goes to (HP_DEPOSIT). The reason for 3 checks if that sometimes customers will bring in three checks for $50.00 each or sometimes two checks for a total of $150.00 combined so we have to sometimes make multiple entries of the form.
Again all help is appreciated.
Please Login or Register to view this content.
Bookmarks