"NEXT" macro

[ricdamiani]

Hi Guys,


The goal is very simple: using a reference cell located in tab 1, find this reference in tab 2, go the next cell down, and paste that value to the reference cell in tab 1.


I have attached an example spreadsheet and I believe the steps would be:

1) Tab 1, reference is located in cell B7 (for example 70100098230)
2) Go to Tab 2, and find where this reference is located (for the example above, the reference is located in A3)
3) Move one cell down (for the example above, A4)
4) Copy the value (for the example above, the value in A4 is 70100098232)
5) Go back to Tab 1 and past it (value only) in B7


If someone could help would appreciate very much.

Thanks,

Rick

[MarvinP]

Hi ricdamiani,

Try this macro for Next:

Please Login or Register  to view this content.

Part of your problem is that on Tab 1 that cell is a number and on Tab 2 it is text (or vice versa).

[ricdamiani]

Part of your problem is that on Tab 1 that cell is a number and on Tab 2 it is text (or vice versa).

Hi MarvinP, thanks for your help.

And what would be the solution for this problem? Making all as numbers?

The macro is working well, thanks for that. But can you please also provide another macro, but this time instead of going to the next item (cell down) goes to the previous item (cell up)?

Appreciate your help again.

Regards,

Rick

[jindon]

Try this

Please Login or Register  to view this content.

[ricdamiani]

It's working well. Thanks jindon and MarvinP.

Kind regards,

Rick

[MarvinP]

Please Login or Register  to view this content.

[ricdamiani]

Hi jingdon and MarvinP

I have been using this macro on daily basis for over a year now, but I need to make some changes.
Original request was below, and the requested changes are in bold:

1) Tab 1, reference is located in cell B7 (for example 70100098230).The reference now is a combination of two values, cell B7 and cell A7 (for example 70100098230 in B7 and 1371 in A7).
2) Go to Tab 2, and find where this reference is located (for the example above, the reference is located in A3).B7 reference is located somewhere in column A, and reference in A7 is located in column B.
3) Move one cell down (for the example above, A4)
4) Copy the value (for the example above, the value in A4 is 70100098232)
5) Go back to Tab 1 and past it (value only) in B7

Could you please help me with that?

Cheers

[jindon]

You mean like this?

Please Login or Register  to view this content.

[ricdamiani]

Yes, it works. As always, thanks jindon