Hi all, new here and thank you so much for any help you can give. I've got a sheet for each month of tenant info for a rental company. I'm trying to improve workflow by creating an "Urgent" sheet of people that haven't reapplied, pulling from the other 12 sheets. There is a column titled "Submission Complete Date", and EMPTY cells in this column need to have their corresponding rows copied to the "Urgent" sheet.
These rows start at '7' and the column we're checking for blanks is 'J'.
Please let me know if you need more info, lots online is pointing to VBA, and I'll really need my hand held if that's the case. Thanks a bunch!
These rows start at '7' and the column we're checking for blanks is 'J'.
Please let me know if you need more info, lots online is pointing to VBA, and I'll really need my hand held if that's the case. Thanks a bunch!