Thanks, I could do that, but I need this setup for a very specific reason.
Is there a function for this?


"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
JN,

Don't use separate sheets - generally, a bad idea - just apply data
filters and choose the desired stockroom from the drop down. And you can
use pivot tables to create summaries.

HTH,
Bernie
MS Excel MVP


"JN" wrote in message
...
I have a worksheet that has a list of parts and the stockrooms they are
in. I want to have one sheet will all the raw data like so:

STOCKROOM PARTNUMBER QTY
----------------------------------------------
MAINSTOCK 123456789ABC 100
AUX-STOCK 123456789ABC 100
FINISHEDSTK XYZXYZ12345 500
MAINSTOCK XYZXYZ12345 100

And then create separate worksheets with the stockroom name in cell A1.
Based on A1 (Stockroom name) I want the remainder of the sheet to be
filled with all the rows from the Raw Data sheet so when I add or refresh
data each of the other sheets will refresh with the correct information.