raccoon588
Board Regular
- Joined
- Aug 5, 2016
- Messages
- 118
On one sheet(RequestLog) i have employees names and the date they have requested off along with some other data. Id like to filter this data and carry it over to another sheet(calendar).
Ex id like to pull all info if the date requested off is in June 2018.
there is a third criteria and that is if the request has been approved. there is a column on (requestLog) titles approved? if this has a yes then it needs to be brought in.
Ex filter all people who retested time off in June of 2018 and have a yes in the approved column.
then next id like to bring in people who requested dates in July and have been approved.
I was thinking some sort of macro with an advanced filter would be best or is there a formula that would do the work?
Ex id like to pull all info if the date requested off is in June 2018.
there is a third criteria and that is if the request has been approved. there is a column on (requestLog) titles approved? if this has a yes then it needs to be brought in.
Ex filter all people who retested time off in June of 2018 and have a yes in the approved column.
then next id like to bring in people who requested dates in July and have been approved.
I was thinking some sort of macro with an advanced filter would be best or is there a formula that would do the work?
