Here's a non-array formulas set-up which can deliver the desired functionality

Take this sample construct from my archives:
http://www.savefile.com/files/430142
AutoCopy Lines to Resp Sht Non Array.xls
(Full details inside, nicely rendered. Easy to adapt ..)

Data is continuously entered in a master ("parent") sheet, with lines neatly
auto-copied to each individual ("child") sheet based on the values within a
key col.

In the sample, the key col in the master sheet is the "State" col, which may
contain eg: NY, CA, NV, SD, AZ, etc. All lines with "NY" in the key col will
be auto-copied to the sheet named: NY, and appear neatly bunched at the top,
w/o any intervening blank lines. Ditto for lines with "CA", "NV", etc which
will be copied into their respective sheets.

Propagation of the "child" sheet is as simple as making a copy of the
initial one, then renaming it accordingly as the next key col value. Eg we
first formulate one child sheet for "NY", dress it up nicely, then just make
copies of the "NY" sheet, and rename these as: CA, NV, SD, etc.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"NBROWN" wrote:
I am trying to save data in target worksheets based on column value of cell
found in source(Master) spreadsheet. I know I can consolidate several
spreadsheets into one master but I want to do it the other way by having one
master and having it update multiple spreadsheets based on colum value on
Master.