Trying to get info from next column not next row - VBA

Dear all,

below is my code, which works great except for one purpose. The info that comes from worksheet two, needs to be one from column to the right. The only thing I can manage to change is the row but not the column. I expect I need to make a difference in the following line but I can't see how:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thanks!
Gini

https://www.excelforum.com/excel-pro...ml#post5524557

What do you want to do this time?

I am trying to use your amazing code to go one column to the right with the Y variable. I have figured out how to adapt for most of my information but not how to move the column for Worksheet Verpackungen.

Are you talking about this line?

Please Login or Register  to view this content.

y is the variable only holding the row references where Col.B of Verpackungen has "Article Number".
So if you say, "one col to the right" would mean col ref to output? or referencing column of source data?

The line you mention currently when I change = ws2.Cells(y(i) + 1, "i") to for example = ws2.Cells(y(i) + 2, "i") it'll get the data from one row below. Instead I would like to get the data from the same row but one column to the right

If you want from the same row, just delete + 1, however you have merged cell in I:J, so changing col ref to "j" doesn't make sense unless you have different data layouts.

Hi Jindon,

what if I don't want to change the row for that part of the VBA but the column? The information I'm trying to grab is one column to the right

"i" is the column reference for col.I.

So try change it to something else like "j", "k", "c","d" etc. and see what happens for yourself.

Thank you yes! That's perfect!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Done thanks once again! Trying to figure out another thing but will try again myself first of course!