I have multiple protected spreadsheets using data validation performed by
list using named range create on a summary spreadsheet. An individual can
add names on the summary sheet within the list's named-range so that the name
is available to select from the other spreadsheets within the workbook.
Each individual spreadsheet can contain any combination of names from the
list and has a representative column set up on the summary sheet to pull in
totals from individual sheets. Since the summary sheet uses vlookup formula
to match the name I thought using data validation would restrict data entry
to match the names entered in the validation list on the summary sheet.
IF(ISNA(VLOOKUP($A4,INDIRECT(B$2),16,FALSE)),0,VLOOKUP($A4,INDIRECT(B$2),16,FALSE))
However, since cell must be unlocked, the data validation doesn't restrict
copy | paste. I do not want users to be able to copy | paste into cells that
are to be restricted using data validation on the individual spreadsheets.
Any suggestions on how to restrict cell entries to only names entered on
summary sheet and not allow the copying and pasting into these cells?
It would seem that Sheet Protection should provide a check box option to
allow users to select from data validation list, as with the "use autofilter"
option and others.
Thank you!
|
Similar Threads
