M
macquarl
I have a list the is in one sheet - this list contains names an
departments and then the data that I seek.
Currently there are seperate lists on different "department" sheet
that break down the people that are on the complete list so tha
department managers can click on their sheet and just view their data.
This is all done manually.
The problem: With turnaround (hiring, firing, dpeartment moves, etc
these sheets are becoming a nightmare to maintain.
The question: Is there a formula that I can use that will use the mai
listing as a starting point that will filter the other sheets based o
the department listed in column B so that column A and Column C (th
data) will appear in the various department sheets?
Any help would be greatly appreciated
departments and then the data that I seek.
Currently there are seperate lists on different "department" sheet
that break down the people that are on the complete list so tha
department managers can click on their sheet and just view their data.
This is all done manually.
The problem: With turnaround (hiring, firing, dpeartment moves, etc
these sheets are becoming a nightmare to maintain.
The question: Is there a formula that I can use that will use the mai
listing as a starting point that will filter the other sheets based o
the department listed in column B so that column A and Column C (th
data) will appear in the various department sheets?
Any help would be greatly appreciated