Hi there,
I have a problem that I have tried to solve but cannot find suitable code (I can do flash not VB).
If it can't be solved I will resort to a manual copy paste solution :o( Arggh!

Excel 2003

I have a 'Naming Tool Excel' with 3 drop downs and 2 free text fields, on sheet1.
These inputs are concatenated into cell A31 on sheet1, which is the name.

This is a unique name, and we want to record each name in a summary list on the same sheet (e.g. column H).
But it needs to [put new ones in the next blank row of the column.
This will help the users know what names were already created. Perhaps VB on the click of a button?

Thank you