S
sgtpsychosis
I have a large amount of data on one worksheet. The data on this worksheet
applies to all the personnel in the entire organization.
One column in this worksheet identifies which workgroup each person is a
member of (Column E, values are "WG1","WG2","WG3", and "WG4").
I have created worksheets for the separate workgroups.
How can I have the data specific for each workgroup automatically copied
from the total organization worksheet to each working groups individual
worksheet, based on the value in Column E?
applies to all the personnel in the entire organization.
One column in this worksheet identifies which workgroup each person is a
member of (Column E, values are "WG1","WG2","WG3", and "WG4").
I have created worksheets for the separate workgroups.
How can I have the data specific for each workgroup automatically copied
from the total organization worksheet to each working groups individual
worksheet, based on the value in Column E?