A formula to filter data and copy it from one worksheet to another
Define: large inventory of equipment.
How many rows and how many columns?
Biff
"GeneR" wrote in message
...
I currently have one worksheet setup that contains a large inventory of
equipment. I want to be able to setup another worksheet for users to
input a
number (department code) and have it filter and copy the inventory from
the
large inventory. In other words, I only want them to be able to call up
their individual inventories by simply inputing their code, without having
to
see or worry about anything else.
Any suggestions?
|