I admit I have zero vba experience but have to enhance our expense form at work. Here is what I am trying to achieve with the Macro:
if employee enters a value in the table column "Amount" And the corresponding cell (same row) in "Description" is left blank then highlight the empty cell and provide message box to indicate to the user that information is missing in that cell/row. Macro to go through the table and check from first row to the last row of the table. This sub is called prior to generating the summary report.
I need to set it up with specific references to the table (not general to the spread sheet columns) as I have multiple tables on the spread sheet for different types of expenses. I tried different things but nothing is working.
Thanks for any help!