Dynamic Input and Join *urgent help needed*

[satya04]

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.

[Towers]

Hi @satya04 ,

I think Ive solved the problem using a batch macro with a dynamic input. 

Let me know what you think!