have reference cells move in rows while I move in columns

[gryffin13]

Im filling in data in a table in a worksheet, but the data is coming from another worksheet. But the catch is that the data I'm using to fill, doesn't match the same layout as the table I'm filling. I've attached an example of what I'm talking about, but basically the issue is that if I do the first column by hand, I can't just "drag it over" or copy the formulas because as I move to the right, excel moves the reference cell to the right. Is there any way to tell excel that as I move to the right, the reference cell should move down?

Is that clear? Thanks in advance.

I did not mean to post that yet. The excel file is not useful. I'll repost once it's been fixed
-it should make sense now what I am trying to do

[antoka05]

You could use this code:

Please Login or Register  to view this content.

Regards,
Antonio