Still toiling away in Excel 2007.

Trying to massage an INDIRECT function to do what I want it to, and having problems. Someone on this forum had given me this formula years ago, and it has worked perfectly. Now, I'm trying to adapt it to sort some other fields, and cannot figure for the life of me how to get it right.

The formula I have been using is: =INDIRECT("Sales!M"&ROW()*3+4), but will need changing.

The values I am using are being taken from an internet site, and for the new formula, I want to stay on the same worksheet.

I am pasting them as text in column A, so changed the first part of the formula to =INDIRECT("A"&ROW()

The second part of the formula has me stumped, and I've tried as many variations of numbers there as I can, but I simply do not understand the logic behind the choice of numbers in the first place, so that is what is keeping me from succeeding.

The info I'm pasting has the needed values repeating every 14 rows.

I've attached a sample worksheet, but I'll explain a little.

A1 is a reminder to my foggy memory. A3 is where the data from the internet will be pasted as text. As you can see, the data repeats the 14th row after the first instance, with a space (blank row) in-between.

Column C is where the values for A4, A18 and A32 and so on need to wind up.

Column E is where the values for A6, A20 and A34 and so on will go.

And you can see the pattern. I've filled C3, C4, C5, etc just to show which value needs to go where. What you see is a representation of where the value for that field should be coming from. I.e. value from A4 needs to show up in C3, value from A18 in C4, etc.

If you can help with a formula, that'll be great. Even better though, would be if you also will explain the logic behind the 2nd part of the formula so I can understand it, and see how to do this myself in the future.

I hope the sample spreadsheet is attached. The way this forum does it seems a little funky to me.

Thanks for any help.

## Bookmarks