Hi very new to this with limited ability. I have a workbook that has separate sheets for each week of the year. "week 1" "Week 2" etc. it contains information for invoices sent with a column to record if they have paid. The column is blank if they have not paid and "YES" if they have paid.
I want to extract the information for all those who have not paid into a new spread sheet with all the row data. The workbook is updated daily and the new spread sheet would need to change accordingly. Sorry if I've not explained it very well.
Many Thanks