Row incrementing

[dachadster13]

Hey everyone,

I have an excel macro that is getting the better of me. What I am trying to accomplish is when I click the submit button on file A it writes to a different workbook. That part currently works, however it overwrites the same cell each time. I need it to start in Column D2 for example. Once that field is populated, the next time something should be written should populate in field D3, then D4 and so on. I was looking into using the Offset and x1down commands but cannot get them working correctly. Any help on this would be greatly appreciated. Thank you.

[patel45]

attach please a sample file with your macro

[JOHN H. DAVIS]

Maybe:

Range("D" & rows.count).End(3)(2)

[zbor]

You can search for last row each time:

     Dim wkB As Workbook
    Dim LastRow As Long
LastRow = wkB.Sheets("Sheet1").Range("A65536").End(xlUp).Row

And then write your data in for example

Range("D" & LastRow +1)

[dachadster13]

Thanks everyone for the replies. I got pulled off of this and into other things, hence my absense. The higher ups have taken a different direction on this and I don't need to implement this, however it may be handy in the future. Thanks again.