Copy rows based on specific criteria
Hello,
I have a workbook with multiple projectsheets, one for each project I'm
working on.
One of the things I have on the projct sheets is my personal action list.
This list includes several rows. Per Row I have information like: nr., action
item, date raised and date due.
In addition to the project sheets I have one MAIN sheet. On this main sheet
I want to see a list of all action items (= copy the whole row) that are due
within e.g. 3(working) days from today. This way I don't have to go through
all tabs to see what action items needs my immediate attention.
Can anyone help me start out on this?
Thanks,
Alvin
|