Copy data from a worksheet
 

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

Copy data from a worksheet
 

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" wrote
in message ...

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

Copy data from a worksheet
 

thank you Tom, was most helpful!

Clare


--
clarefoxly
------------------------------------------------------------------------
clarefoxly's Profile: http://www.excelforum.com/member.php...o&userid=24183
View this thread: http://www.excelforum.com/showthread...hreadid=384485