VBA Codes who insert the automatic worksheet when click a cell and all datas of its

I have an excel file having more than 150000 rows.It is to be downloaded from the available system.

Now,I want a VBA codes or macro working who help me at that time when I click a particular cell then process the automatic steps of the following:-

1-Insert sheet with the code name when click on that cell from a sheet.
2-Insert the all columns and rows of that click cell code on this sheet.

For more clarification,please refer my attach file.

In this file,when I click on the cell H6,H126 and H145 and so on ( from details worksheet ),then the automatic insert the worksheet of FNDADRKCC,FNDADRKSC and GLRADRSCC with their respective all columns and rows datas e.g.Range B6:G20 in the case of FNDADRKCC and so on depends upon the code exist in the "Details" worksheet.


Is it possible from VBA Codes working?

put this code in Details worksheet module

Please Login or Register  to view this content.

Not working.I have put the codes on Details sheet.

Can you put up the same and send the save attach file?

see attached file

Glad to receive the desired result.Excellent.Thanks for this efforts.

Regards