Creating a table from one varying source

R

Rumblefish

Hello there. I am trying to create one table that updates the relevant details as and when i fill in sheet one (which is a an order form). When the order form is complete i would like sheet 2 to auto fill without overwriting the data that is already there from previous orders. If possible can someone give me some hints for the code 'cos i'm pulling my hair out now,

cheers
 
T

Tom Ogilvy

You could have a button that, when pressed, writes the data the second
sheet. It seems the only problem you might have is finding the bottom of
the data that exists currently.

Private Sub CommandButton1_Click()
Dim sh as Worksheet, rw as Long
' assumes there will be a header row for sheet2
set sh = worksheets("Sheet2")
rw = sh.cells(rows.count,1).End(xlup)(2).Row

with worksheets("Sheet1")
sh.cells(rw,1) = .Range("A5")
sh.Cells(rw,2) = .Range("B9")
sh.Cells(rw,3) = .Range("B10")
End with
End Sub

--
Regards,
Tom Ogilvy

Rumblefish said:
Hello there. I am trying to create one table that updates the relevant
Click to expand...
details as and when i fill in sheet one (which is a an order form). When
the order form is complete i would like sheet 2 to auto fill without
overwriting the data that is already there from previous orders. If
possible can someone give me some hints for the code 'cos i'm pulling my
hair out now,
 
Top