View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff Biff is offline
external usenet poster
 
Posts: 1,688
Default 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?