Moving data from 1 form to another

D

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
_________________
 
D

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
 
Top