Donald,

I would suggest that your idea of Autofiltering the data and copying to the
appropriate sheets is the way to go. You can record a Macro to do it for the
users - this would remove the possibility of user errors.

Post back if you need further help with the Macro.
--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"Donald Macleod" wrote in message
.. .
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