coping rows using a loop... please advise

  • Thread starter Thread starter jim hensen
  • Start date Start date
J

jim hensen

Hey Ron.

Im not sure if i follow exactly what your saying. The
Range("A1:A100") " It varys each time i copy data to the blank sheet.
What is the code that you provided supposed to do. I ran it, and i
seems to do nothing
 
Hi Jim

It will look in A1:A100 for "station number" (in Sheet1)
It will copy the 4 rows below it to "Sheet2"
It will do this for every "station number" in the range
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

coping rows using a loop... please advise 1
entering value without acivating sheet 4
Copy columns and paste with blank column between 5
Loop Repeats - PLS HELP 2
coping rows using a loop... please advise 1
Do Until Loop 6
Do Until Loop 2
Problem with a loop and column references 27

Back
Top