Loops and relative references?

I am looking for some help with loops. This is more for provoking my thought than getting specific about code.

I have a fully functioning macro that takes texts and sorts it into columns based on set delimeters. It also, for example, clears cells that are not needed and rearranges them based on the order that the next, separate, spreadsheet will use them (it uses formulas that searches for the entry in the first column and takes one cell of data from each row).

It works great for a single set of data. However, I am running into an issue when I want to paste, say, 10 sets of data, each multiple rows long.

The code I have used, as an example, is as follows:

Please Login or Register  to view this content.

However, this is based on an absolute cell reference. How would I start to go about using a loop with relative references? Example: I would need the above piece of code to run at B2, B6, B10, etc.

Thanks in advance!

Please Login or Register  to view this content.

Note: there is no need to select the cells

Regards

Please Login or Register  to view this content.

Regards

Also, is there a way to have several of the statements you posted in a row? For example, I want to manipulate two different cells. As an example, I want to move B4 to C4 then B3 to E3 (and mutiples thereof).

Please Login or Register  to view this content.

Thoughts?

Are there going to be many more extensions to the original question?

Maybe something like (untested):

Please Login or Register  to view this content.

I don't think so. Sorry about extending the original topic.

To contribute, I found a way to do what I want:

Please Login or Register  to view this content.

This will find rows with "SomeValue" in Column A, then move that row's Column B cell to Column E.

Thanks!