Hi Ron, that link you gave me is so cool. It is able to save the whole
row from sheet1 to sheet2 right? Is it possible to save from sheet1 of
workbook1 to sheet1 of workbook2? different workbook instead of the
same workbook. this is because database and the form are 2 different
files. Thanks

Ron de Bruin Wrote:
Do you mean like a database
http://www.rondebruin.nl/copy1.htm

If you use a row below your form with links to the cells(you can hide
that row)
in A50 =c10 and in B50 g20 ........

You can copy a range like A50:Z50 to the database sheet


--
Regards Ron de Bruin
http://www.rondebruin.nl


[/color]


--
Spartanz
------------------------------------------------------------------------
Spartanz's Profile: http://www.excelforum.com/member.php...o&userid=28830
View this thread: http://www.excelforum.com/showthread...hreadid=485785