Hi, wils_mathew,
maybe lookup the VBA-Help for SpecialCells(Constants, 3) which should narrow down the cells to copy. And for placing them something like the follwoing could be used:
Dim lngLast As Long
With Workbooks("Consolidated Report.xlsx").ActiveSheet
lngLast = .Cells(.Cells(.Rows.Count, "A").End(xlUp).Row + 1, "A").Row
End With
where lngLast can be used as rownumber into which will be written.
You didnīt mention if both workbooks will be open by the time of copying data across.
Ciao,
Holger
Bookmarks