Hi,

I have got a database, with several columns and a lot of rows. On
column is for part numbers. On another Sheet, I have got 2 rows, where
I have all the existing part numbers, and formulas which count ho
often each part numbers occur, in the part number column in th
previous sheet. With Data Validation, I prevent, that someone i
entering an already existing part number. But I would now like to hav
a button, which extracts me all the new entrys in the part numbe
column from sheet 1 and put them automatically onto the row from
sheet2, so that I don't have to type them in manually.

Thanks

Stepha

--
Message posted from http://www.ExcelForum.com