Good day,
I have 4 sheets in my workbook which represents the various departments. The headings are the same in all 4 sheets:
We want to create a master sheet where we combine the data of the 4 sheets into 1. This is in order to track a staff member within all 4 departments also to have the dates in order.
So I'm not sure if a =Filter function can work across 4 sheets. So any advise assistance will be greatly appreciated.
I have 4 sheets in my workbook which represents the various departments. The headings are the same in all 4 sheets:
Date | Name of staff | Type of Incident | Negative/Positive | Result of Issue | Action Taken | Comments |
We want to create a master sheet where we combine the data of the 4 sheets into 1. This is in order to track a staff member within all 4 departments also to have the dates in order.
So I'm not sure if a =Filter function can work across 4 sheets. So any advise assistance will be greatly appreciated.