Use VBA as data validation to eliminate copy/paste transferring

[mweick]

This has been very frustrating for some time now. We use this worksheet to request new items and sales people will fill out the first tab called the For Sales tab.

I put data validation on some of the columns based on certain restrictions/standards that had to be followed. The problem is when people copy and paste values from column to column, it also pastes the data validation from the column which screws up the process because certain things will not upload now because they violate certain restrictions for that column.

Is there any way to use VBA for data validation so a user can copy data from column to column without pasting the data validation from that column?

• Column B cannot exceed 15 characters, so less than or equal too 15 characters.
• Column D cannot exceed 31 characters, so less than or equal too 31 characters.
• Column E cannot exceed 31 characters, so less than or equal too 31 characters.
• Column W has to be two digits (01-99), so 1 would have to become 01 and so on...
• Column X has to be two digits (01-99, so 1 would have to become 01 and so on...
• Column AA cannot exceed 27 characters, so less than or equal to 27 characters.
• Column DU has to be two digits (01-99), so 1 would become 01 and so on...

I have attached a copy of the spreadsheet for assistance. The list above should only effect the For Sales tab. Any help is greatly appreciated in this frustrating matter!

Thanks