View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JI[_2_] JI[_2_] is offline
external usenet poster
 
Posts: 11
Default Loop that Copys from one sheet and pastes to another

Im trying to find a vba loop sample of something that would look at all
the values in
column A:A of "sheet1" if they equaled "Sheet2, Cell A5" then copy
columns
B:F on that row and paste it to "sheet2" starting in row 7 column A:A.
Keep cycling through the data until the last row. Thanks