Enter value on sheet 1 --> values in sheet 2

[sjoerdd87]

Hello everyone,

I've been looking for the following for a long time:

On sheet1 the values are entered on A2 and B2, the value B2 must come after the correct number in Sheet2. in the real file even in the 3rd column (C)

Now I've been working on VLOOKUP in VBA, searching for the value A2 in Sheet2 tab, then in column 3 displaying the value of Sheet1! B2 False.
But I don't get this working properly.

Of course I can do it as in the example but then I have to create an IF for each number, in the example there are 5 but in the real file almost 100.

Please Login or Register  to view this content.

I would like to hear if this is possible, and what exactly the code entails so that I can adjust this if necessary.

If someone also has a good working VBA code to keep track of changes in, for example, Sheet3 with the name, date, time and the change, this would also be a good tip!

Thank you very much for the help!

[oeldere]

HOW TO ATTACH YOUR SAMPLE WORKBOOK:

Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

[sjoerdd87]

I can not upload any files... when i press attachments there are no options...

[oeldere]

Did you followed #2. That should work.

[sjoerdd87]

Did you followed #2. That should work.

#2? I don't know?

[JeteMc]

...when i press attachments there are no options...

The paperclip icon does not work. Please scroll down to MANAGE ATTACHMENTS.
Let us know if you have any questions.