Forum Discussion
Solved
VBA in a Worksheet_Change Event (instead of a IFERROR/INDEX/MATCH formula)
Hello, I am looking to use a VBA in a worksheet_change event instead of formula, so I can leave the cell empty ready for user interface/when the conditions are met the value can be put in the cell au...
See if you can use the attached workbook as inspiration.
Right-click the sheet tab and select View Code from the context menu to see the code.
Thank you so much for your help! I tried to tweak the code, however no luck. I am using the below table. Column D (Age) populates using a formula. I am struggling to have the unique identifier auto-generate columns with Client DOB, Gender, Sex and Client Type if possible.
Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Thanks in advance.