Hi All,
Hope Everyone is all right.
I have searched many forums the fact below that make me stuck. Hope someone here will help me.
I have a Large datasheet. In this datasheet, I want to use input box code to simplify my data entry. But I am unable to do it on my own as I am not an expert. So I need Expert help.
This is the table where the ROW heading is in ROW 8.
B | C | D | E | F | G | AA | AQ |
Types | Open Date | Saving | Loan | ||||
Debit | 12/12/2021 | 18/03/2022 | |||||
Credit | 11/11/2021 | 13/01/2022 | |||||
13/01/2020 | 20/11/2021 |
In the above table when E column data is entered then an input box opens based on B column value.
if B column value is Debit then the input box opens to ask for "Date of Loan Creation" after the date enter it unload in AQ Cell and will show a message as "Loan Creation date is 18/02/2022.
if B column has Credit or nothing then the input box opens to ask for "Date of Savings Entry Creation" after the date enter it unload in AA Cell and will show a message as "Savings Entry date is 13/01/2022. All Date will be "dd/mm/yyyy"
Hope I am able to describe the fact and someone will help me to ease my data entry.
Thanks in advance.