Copy and Paste specific data

  • Thread starter Thread starter lizb22
  • Start date Start date
L

lizb22

Hi,

I have 1 spreadsheet with ALL data
I have 2nd spreadsheet that has a selection of data from 1st sheet

I need help with a loop that will go to 1st spreadhsheet, copy the data
only pertainting to the second one, and paste it into 2nd spreadsheet;

This is where I started:

Sub PasteFromMaster()
Dim start As Range
Dim finish As Range

Workbooks("Test_Master").Activate

Set start = Workbooks("Test_Master").Sheets("sheet1").Range("a1:d1")
Set finish = Workbooks("Test_1").Sheets("sheet1").Range("a7")

start.Copy finish

Do While ActiveCell.Value <> ActiveCell.Offset(1, 0)
ActiveCell.Offset(1, 0).Select

'Range "start:finish".Select ** not sure about this
Selection.Copy
Windows("TEST_1.xls").Activate
Range("A7").Select
ActiveSheet.Paste

Loop

End Sub

thanks
Liz
 
for a better way, have a look in vba help for FIND and FINDNEXT. there is an
example.

I don't understand this statement
 
Back
Top