Hi, I need a piece of code that copies a range, ie B10:K100 plus. This range
would vary in size depending on the amount of data. I then need this data to
be copied and pasted values onto a different tab (Database) and inserted
below the previous data. I can do most of the code apart from where it looks
for the previous data and drops it below the last occupied cells. Below is my
poor attempt

Sub Macro2()

Application.ScreenUpdating = False

Dim iRow As Long

Application.Goto Reference:="Data"

Selection.Copy

Sheets("Database").Select

iFreeRow = Cells(Rows.Count, "B").End(xlUp)

Selection.PasteSpecial Paste:=xlPasteValues

Sheets("Input").Select

Range("B6").Select

End Sub

Any help, greatly appreciated

Regards

John