I had been coerced into 'keeping an eye' on a spreadsheet.

The workbook is laid out with 5 worksheets, 'Full' and 4 others which are
basically sections of 'Full' called 'NA', 'NB', 'NC', and 'ND'. The sheets
themselves are list of customers with 16 pieces of information in separate
columns. Needless to say every entry in 'Full' has to be duplicated in the
sectional sheet. I tried to explain about the possibility of dumping the
sectional sheets and using simple filtering to show the sectional data
straight from 'Full'. From the facial expressions this produced I wondered
if I'd grown 3 extra heads. I've now been asked if typing an entry in
'Full' can cause the same entry to be added to the corresponding section
sheet. This would actually suit me as it would cut down on errors and
mismatches between the sheets. Given the inane questions I've already been
asked I'm not inclined to start a discussion about copying and pasting and
assumed it would be fairly easy to do this with a conditional formula. I'm
now having difficulty achieving this.

If a formula is the solution then it merely has to act on the presence of
NA, NB, NC or ND in column 7, (it could obviously be any column), and input
all the data from that row to the next available row in the sectional sheet.

Has anyone any helpful hints, preferably before I put in my notice and check
into the funny farm,. which really could be any day now.

I should say I'm not an advanced user, (how'd you guess), but I could handle
further research if pointed in the right direction.

Thanks for any help

Donald Macleod