I apologize for my limited Excel VBA knowledge and need some guidance in how to go about referencing data in specific columns and rows spaced equally. I have data from a web download and only want to capture one row for all the locations. They are spaced 35 rows apart and I need columns from B - N. If anyone has an example of how to do this I'd really appreciate seeing it.

Thank you!!


Robin Young

There are several ways of managing this depending on how you want to use the data. Such as :-

1. Data/Filter/Autofilter
2. Sort the data
3. Macro


-----------------------
Regards BrianB
Most problems occur from starting at the wrong place.
Use a cup of coffee to make Windows run faster.
It is easy until you know how.

Brian,

Thanks for the reply! Actually the only think I'm wanting to do with this data is to be able to view it sequentially and import it into Access. The rows I'm interested in are spaced 35 rows apart.

Thanks again,


Robin Young