Re: Need Help with a MACRO

You didn't include the code you are using so I have to give a generic
answer. In your code, you are copying and pasting. Your problem is
designating where to paste. I like to use a variable range that is the
first empty cell in some column, then offset from that cell for repeated
pasting.
You would use something like this line of code to set the destination cell.
Set Dest = Range("A" & Rows.Count).End(xlUp).Offset(1)
HTH Otto
"Obi-Wan Kenobi"
<Obi-Wan.Kenobi.24zb8c_1142876104.3492@xxxxxxxxxxxxxxxxxxxxx> wrote in
message news:Obi-Wan.Kenobi.24zb8c_1142876104.3492@xxxxxxxxxxxxxxxxxxxxxxxx

I need help with a macro. On my workbook I have two Worksheets.

Sheet1 is were I keep the form. Sheet2 is were the data is transferred
when I run the macro. The macro I have built works fine in transferring
the data from the form (Sheet1) to the table on sheet2. I also have a
clear button on sheet1 which when pressed the macro clears all data on
the form (Sheet1), so it is ready to input more data.

My problem starts from here, when I input new data on the form and run
the macro in order to transfer data across to the table on sheet2. The
previous data is overwritten and I can not build a list of customers.
Is there a way of building a macro that will select the NEXT LINE on
the table every time I run the transfer button?:eek:


--
Obi-Wan Kenobi
------------------------------------------------------------------------
Obi-Wan Kenobi's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=32578
View this thread: http://www.excelforum.com/showthread.php?threadid=524474



.