Moving data from 1 form to another

[daniels012]

We use a proposal that has address, phone, company name, proposa
number, etc. that I would like to transfer to another exce
spreadsheet.

I used the "record macro as you go" method to make a quick macro. I
works fine but it enters the data over the same line. Not where I hav
the cursor!

How can I get the data to enter into the current line of the cursor
And all the cells to the right respectfully?

Any code that you could offer would be of great assistance.

Michael
_________________

 

[daniels012]

How do I write in code to get me to the current cell????????????


Michae

 

[Dave Peterson]

Are you building a log of your quotes?

if yes, then maybe you can pick out a column that always has data and use that
to find the next available row to write your data in.

dim LogWks as worksheet
dim curWks as worksheet
dim NextRow as long

set curwks = worksheets("where the data is")
set logwks = worksheets("where the log data is")

with logwks
nextrow = .cells(.rows.count,"A").end(xlup).row + 1
.cells(nextrow,"A").value = curwks.range("a1").value
.cells(nextrow,"B").value = curwks.range("b33").value
....
end with