Hi Bernard,
Yes I have column headings, as follows:
A Employee #
B Full Name
C Last Name
D First Name
E Mid Initial
F Department
G Position
H Hire Date
I Birth Date
J Years Worked (calculated field)
K Current Age (calculated field)
L Years until retirement (calculated field)
M Lower
N Upper
O Range
P Count
(the above is for charting years until retirement)
Q Lower
R Upper
S Range
T Count
(Columns Q-T is for charting age groups)
When filtering "Department" columns M through T loses some rows.
Thank you, Bernard.
--
MB
"Bernard Liengme" wrote:
Not sure what you mean by "it filters these column too"
You can select ALL for each of these to show all records for any one
department.
You do have a top row with column headers such as "Department", etc?
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"MB" wrote in message
...
I tried auto filter, but I have the following in columns P through S
Lower Upper Range Count
0 5 0-5 (formula here)
6 10 6-10
11 15 11-15
(through to 35+)
This is needed to chart how many years in each range group. I have the
same
in columns T through W that calculates age groups. When I filter the
department column, it filters these columns, too. I need a chart for all
employees and then a separate chart for each department. I can't figure
out
how to do this.
Thank you.
MB
"Bernard Liengme" wrote:
It is very poor database management practice to have duplicate data. I
believe everything you want to do could be accomplished using Data Auto
Filter
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"MB" wrote in message
...
Hello,
I have a spreadsheet listing all employees and other data (birth date,
hire
date, department name, etc.). I need a separate sheet for each
department
within the same book. For example, all Administration in one sheet,
all
Engineering in another, etc.
My data ranges from A2:0141 (headings are in row 1). What is the
formula
to
pull each department into it's own sheet? The departments are in
column
F.
Thank you.
--
MB