Requesting another little miracle.

[aurbo]

Greetings

I would like to be able to click a button on a worksheet, open a form or dialog which the user then inputs;

First Name ' destination cell=(1, newcolumn)
Last Name ' destination cell=(2, newcolumn)
Address ' destination cell=(3, newcolumn)
phone ' destination cell=(4, newcolumn)
email ' destination cell=(5, newcolumn)

On the form,

a.) A Button to clean itself of input data.

b.) A Button to close itself.

c.) A Button to add the data into a single column of cells.

Check row 5 ".Range(A5:A200)", for duplicate email, if no duplicate found, procede with the function. if a duplicate is found return a msgbox.
Check first 200 columns of the worksheet ".Range(A1:A200)", find the appropriate column in alphabetical order by Last Name, Insert a new column, then drop the data into that new column.

Or insert the data into column 201(the next un-used column), and resort columns 1 thru 201 ".Range(A1:A201)by alphabetical order.


Any help in this is greatly appreciated.

Thanks in advance.

Steve

 

[rmikesmith]

Steve,

I wouldn't mind working on this (in fact, I've already started) but I recommend using worksheet rows as individual records and columns for field names (First Name, Last Name, etc.) since you are limited to 256 columns but have 65536 rows at your disposal. I will set things up along those lines. I'll email you a copy when ready.

Regards,
Mike