Please refer to the attached file. Main group tab has certain names (for instance H04M 11/00).
There are separate sheets for each prefix ( for instance H04M) and column B of that sheet will include the name for H04M 11/00 (Telephonic communication systems specially adapted for combination with other electrical systems). Please refer to cell B25 in the tab named H04M.
I will have to bring the value of that record to the main group tab and have it in column b as a corresponding record to H04M 11/00. I am trying to do this with dynamic input and the connection is not working. Please guide me on how this can be done.
Hi @satya04 ,
I think Ive solved the problem using a batch macro with a dynamic input.
Let me know what you think!