PDA

View Full Version : Excel 2002 - data validation and copy/paste



mbarss
11-06-2007, 01:51 PM
Hello Group.

I am working on a spreadsheet where I have 2 requirements. The first is that I have 4 columns that are using data validation and 4 lists. I want to force the user that if they put any data in column 1 that the 4 columns have to be completed. The data is in column 1 (A) can be up to 60 characters. I'm also not sure how many rows there will be as this can vary from user to user. I just want to ensure that if they enter data in a1 to a10 or a1 to a2000 extra, that the corresponding cells for columns F, I, L and O are field out.

The second problem I have is copy/paste when it comes to the columns that have data validation. I have seen code to disable the cut/paste function, but that does it on the whole work sheet. I just want to stop the user from pasting in to the 4 columns as this cause the data validation not to occur becuase of the way Excel handles the copy/paste.

Any insight would be greatly appreciated.

Mack