R
robert R
I have searched the blogs and cannot seem to locate anything related
to my challenge. I know you guys are gurus when It comes to things
like this.
I have a worksheet that tracks employee productivity for each cost
center with a region.
My excel worksheet contains three validation dropdowns that use the
"indirect" function with various named ranges that link these
dropdowns . So for instance lets say that the first dropdown relates
to a region, the second relates to a cost center (there can be many
cost centers in a region), and the third is a worker in that cost
center (there can be many workers in a cost center). So, lets say
that I select Northwest Region à 10001 (Cost Center) à and Jim Stu,
John Doe, Bob Doe, and Jane Done can all be selected from this cost
center individually which changes the productivity data for each
worker.
Drop Down 1 (region) --> Drop Down 2 (cost center) -> Drop Down 3
(Worker)
Range1 = Region
Range2 = (indirect function from cell in Range 1)
Range3 = (indirect function from cell in Range 2)
What I would like to do is automate the printing process of the
workers within a selected cost center using these already defined
ranges. So for example in the example above I want to print all four
names dynamically if some one decides that they would like to print
all of the workers in ANY cost center. I am looking for the VBA code
for this endeavor. Is this feat possible without having to select
each
and every worker within that cost center? Also, to take it a step
further, is it possible to select all workers from every cost center
and print all cost centers at once?
to my challenge. I know you guys are gurus when It comes to things
like this.
I have a worksheet that tracks employee productivity for each cost
center with a region.
My excel worksheet contains three validation dropdowns that use the
"indirect" function with various named ranges that link these
dropdowns . So for instance lets say that the first dropdown relates
to a region, the second relates to a cost center (there can be many
cost centers in a region), and the third is a worker in that cost
center (there can be many workers in a cost center). So, lets say
that I select Northwest Region à 10001 (Cost Center) à and Jim Stu,
John Doe, Bob Doe, and Jane Done can all be selected from this cost
center individually which changes the productivity data for each
worker.
Drop Down 1 (region) --> Drop Down 2 (cost center) -> Drop Down 3
(Worker)
Range1 = Region
Range2 = (indirect function from cell in Range 1)
Range3 = (indirect function from cell in Range 2)
What I would like to do is automate the printing process of the
workers within a selected cost center using these already defined
ranges. So for example in the example above I want to print all four
names dynamically if some one decides that they would like to print
all of the workers in ANY cost center. I am looking for the VBA code
for this endeavor. Is this feat possible without having to select
each
and every worker within that cost center? Also, to take it a step
further, is it possible to select all workers from every cost center
and print all cost centers at once?