15 different workbooks saved in a common folder, some contain data and some doesn't. I hope to run a macro to determine which file contains data and which doesn't. Information will be input into a master data list. But I'm not sure what macro to use. Please help. Thank you.
