Writing the macro for Excel on VBA
We have an Excel book that consists of two letters.
List of 1
List of 2
You need to combine the column E of 1 and the column D of 2 of the list.
If you have found the coincidence in a copy, then in the letter 1 next to the corresponding line you need to transfer the information from the letter 2.
This is so:
Nuance - in letter 1 the value is always with a literal index (e.g. ZMB-4102), and in letter 2 it can be with the same index, or without it - 4102, or together with another number 4102/B-231 or 4102, B-231.
-
1 day11 USD
812 15 0 1 day11 USD
I do, call me.
=================================================
-
1 day22 USD
4461 102 0 1 day22 USD
Good day . Can you show the base? There are ways to solve this task.
-
1 day11 USD
419 13 0 1 day11 USD
Welcome to!
I work with Excel and Google tables.
Ready to help with a formula or macro (scripts).
I will be happy to cooperate.
-
1 day11 USD
2864 72 0 1 day11 USD
From 500 to 1000 UAH
Let’s write and talk. Today it will be ready.
-
1 day18 USD
2141 85 0 1 day18 USD
Готов сделать.
оооооооооооооооооооооооооооооооооооооооооооооооо
-
1 day11 USD
1115 109 0 1 day11 USD
Good day .
I write a macro VBA. You need an original file for work.
-
1 day22 USD
3668 107 0 1 day22 USD
That is, the macros must first outline the number of the order the same numbers.
The numbers are searched in the second letter.
Can you show the base?
To look at the scope and complexity of the implementation.
-
1 day11 USD
735 4 0 1 day11 USD
The column format is strict (i.e. We are interested in the numbers at the end) or a possible situation of the type IVA-34354-45345 - i.e. 2 or more defects or any other symbols?
-
1 day11 USD
525 6 0 1 day11 USD
Ready to help you.
There are a few ways to solve the problem.
-
1 day11 USD
661 38 2 1 day11 USD
The task is simple, ready to be done. Great experience in creating simple and complex excellence macros.
Chernovtsy