i have a spread sheet set up with a macro in it.
the macro will copy an entire row from one sheet and paste it into a sheet setup to be a compilation of everything.
i want the macro to validate the info to make sure its not already in there.
for instance, if you look in my book, the first two columns are location and #... if a location and number is already being used, i dont want it to paste.
i can have muplitple part numbers, but only one location and number can be used.
thanks
nick
Bookmarks