Good day. I need the help of writing a macro for Excel. Task: There are cells whose value is text, these values are taken from another file. It is necessary to organize a search for this text in the database (this text is the name of the product), and then output specific values. Innocent explanation. Cell A1 = A1 (from another file, namely, the name of the product), in our file, this name is automatically searched and the ingredients are inserted into certain cells.
2 answers
Without an example, it is difficult to advise.
Create an array, cycle through it ...
Maybe he, macro? :)
=ВПР(A1;диапазон_другой_книги;столбец_поиска;) 
vikttur vikttur
5.475 3 gold marks 12 silver marks 22 bronze marks
|
- CDF and SUMMESS to another book with a large amount of data is evil. The best option is to write a request for a sheet with the product and place the result in a separate sheet. It will be so that at least the CDF will be on another sheet of the same book.
- It may be CDF, or it may be better to use Find.
Alexander Puzanov Alexander Puzanov
1,681 1 golden mark 14 silver marks 43 bronze marks
|