I have an application that has a user paste data into a set group of columns
and up to 100 rows. The data is sales information. They then click a button
and the data is exported into a flat file. I need the data to be validated
before the flat file is created. 1. I need field length validation on some
columns (13 characters max) and 2. I need the data in two columns to be
validated against a code list (MN, KN, TD, or GD). I am thinking that doing
this as a Macro is best because selecting the "Data" "Validation" for a
range is erased once new data is pasted into a cell.