I need some help here, been trying on my own but not working at all.
I have more than 100 files to check on empty submission.
Am trying out "for each" loop, to check if cells A2: A100 in these workbooks are empty (these workbooks are stored in the same folder - budget folder). If range A2:A100 is empty, THEN activate another opened workbook (filename = macro.xlsm), worksheet (tab name = empty), and update the workbook name into the "empty" sheet.
The macro should also move to the next row upon updating the workbook name so that it does not overwrite the first entry.
Any advice and help is greatly appreciated!