Copy data from a worksheet

[clarefoxly]

Hi, I have two worksheets in my workbook, im calling the first ‘master’ and he second ‘input’ basically the master is a list of important invoices which have to be correct,. The input sheet is design to be a holding sheet for the date being inputted, so it can be checked before being added to the bottom of the master list. This is done weekly and there are normally between 5 – 20 rows.

Would I need to uses some kind of macro to select all the rows and columns to then be copied to the next free row at the bottom of the master list?

Thanks in advance.

Clare

[Tom Ogilvy]

sub copyrows()
Dim rng as Range, rng1 as Range
with worksheets("Inputs")
set rng = .Range(.Cells(2,1),.Cells(rows.count,1).End(xlup))
End With
with Worksheets("Master")
set rng1 = .Cells(rows.count,1).End(xlup)(2)
End with
rng.EntireRow.copy Destination:=rng1
End Sub

--
Regards,
Tom Ogilvy


"clarefoxly" <[email protected]> wrote
in message news:[email protected]...
>
> Hi, I have two worksheets in my workbook, im calling the first 'master'
> and he second 'input' basically the master is a list of important
> invoices which have to be correct,. The input sheet is design to be a
> holding sheet for the date being inputted, so it can be checked before
> being added to the bottom of the master list. This is done weekly and
> there are normally between 5 - 20 rows.
>
> Would I need to uses some kind of macro to select all the rows and
> columns to then be copied to the next free row at the bottom of the
> master list?
>
> Thanks in advance.
>
> Clare
>
>
> --
> clarefoxly
> ------------------------------------------------------------------------
> clarefoxly's Profile:
http://www.excelforum.com/member.php...o&userid=24183
> View this thread: http://www.excelforum.com/showthread...hreadid=384485
>

[clarefoxly]

thank you Tom, was most helpful!

Clare