storing data

If I want a form that gathers data and places it in a spreadsheet, then clears the form and other set of data is entered and placed one step below the previous and, so on, how would I do this?

I already have the form made and the data going into the correct colums, but how do I increment to the next row.

Also if I close the spreadsheet and reopen it how do I find the next empty row for the data to go into?

Finally if I have multiple spreadsheets how do I make sure that the data always goes to one spreadsheet? I noticed that if I had another spreadsheet open and ran my form it would copy the data into that spread sheet.

I also have to ask if there are any tutorials on this stuff?

'Find next empty cell to add data into
Range("A65536").End(xlUp).Offset(1, 0).Select

To make sure that your data goes into the correct spreadsheet, include it's
name in the code i.e. Workbooks("Book1.xls").Activate or
Worksheets("Sheet2").Activate

"jimbo_jones" wrote:

>
> If I want a form that gathers data and places it in a spreadsheet, then
> clears the form and other set of data is entered and placed one step
> below the previous and, so on, how would I do this?
>
> I already have the form made and the data going into the correct
> colums, but how do I increment to the next row.
>
> Also if I close the spreadsheet and reopen it how do I find the next
> empty row for the data to go into?
>
> Finally if I have multiple spreadsheets how do I make sure that the
> data always goes to one spreadsheet? I noticed that if I had another
> spreadsheet open and ran my form it would copy the data into that
> spread sheet.
>
> I also have to ask if there are any tutorials on this stuff?
>
>
> --
> jimbo_jones
> ------------------------------------------------------------------------
> jimbo_jones's Profile: http://www.excelforum.com/member.php...o&userid=27244
> View this thread: http://www.excelforum.com/showthread...hreadid=469275
>
>

Thanks bigwheel! Could you suggest a tutorial or link where I can learn Excel VB at this level?

Well, there are many good books available or you could try a search on the net.
One good starting point would be
http://www.mvps.org/dmcritchie/excel/excel.htm where there are some tutorial
pages or http://www.cpearson.com/excel.htm.

Several other contibutors to these newsgroups also give links to their sites
which have a wealth of information. Best of luck.

"jimbo_jones" wrote:

>
> Thanks bigwheel! Could you suggest a tutorial or link where I can learn
> Excel VB at this level?
>
>
> --
> jimbo_jones
> ------------------------------------------------------------------------
> jimbo_jones's Profile: http://www.excelforum.com/member.php...o&userid=27244
> View this thread: http://www.excelforum.com/showthread...hreadid=469275
>
>