Thanks for your help with this, but when I try to run this I get a
syntax error. I am not familiar with Visual Basic, so not sure what
likely problems could be. Would it be possible for you to check my
coding - copied below
Sub CopyDataRow()
nInputRow = 2
nOutputRowStarts = 2
nRowsLogged =
Sheet2.Cells(nOutputRowStarts, 1).CurrentRegion.Rows.Count
For Each xCell In Sheet1.Rows(nInputRow).Cells
Sheet2.Cells(nRowsLogged + 1, xCell.Column) = xCell.Value
Next xCell
End Sub
Is that all coding or is any of it a comment, as I say not sure about
all the fine detail. Dim or what!
Jenno
--
Jenno
------------------------------------------------------------------------
Jenno's Profile:
http://www.excelforum.com/member.php...o&userid=26236
View this thread:
http://www.excelforum.com/showthread...hreadid=395283