Help - Based on input suggest next column text

[ExcelUser2707]

Hi Experts,

REQUIRE YOUR VALUABLE HELP ….scenario is as follows

Below list was store separately in “sheet2”. Assume I am working in “sheet1” In column/Row A2, if I pick “part A” input. In column/Row B2 Excel will shows related subgroup i.e. ASN - 1001-No, ASN - 1001- SFT, ASN - 1001-CAN. Same for column/Row C3 i.e. ASN1001NO-01, ASN1001SFT-02, ASN1001SFT-03 and so on…

I am having massive data in this order, right now it is very difficult to way-out the right path…

If any trick / formula / validation will works, please suggest. Apologies, if I explained in text is not convenient to understand. I am attaching file with desire result.

Thanks in advance
image.jpg

[LeoTaxi]

something like this ?


Kind regards
Leo

[ExcelUser2707]

Hi LeoTaxi

Regret about delay reply.

Thanks a lot for your great and valuable reply. Your suggestion, really fulfill my requirement. Your code works superb…. THANKS A LOT TO GUIDE ME AND ATTEND MY THREAD

I tried your code to work my real requirement.. but I fail to do that, it’s due to inadequate knowledge about code.

It will be very helpful to me, if you can guide me or add same code for attach file.

Once again thanks a lot…

Regards

ExcelUser2707

[LeoTaxi]

Hello ExcelUser

in wich rows and columns the validation ?


Kind regards
Leo

[ExcelUser2707]

Hi LEO

Thanks for your prompt reply, actually I added require result in attachment… sorry for not mentioned the same in text…..

Data kept in sheet Mat group, Require result in sheet Master from column/row E107:E206 1st option to adopt, F:106:F206 & G106:G206 require to show there options.

If you help me to sort my query… it will be really appreciate

THANKS

ExcelUser2707

[LeoTaxi]

See if this is ok
there i a button on the master sheet it brings the lowest
row to sheet val ( needed for new parts )


Kind regards
Leo

[ExcelUser2707]

Hi Leo,

It’s amazing Sir…… THANKS A TON TO RESOLVE MY QUERY…

What a brilliant knowledge you have, I really appreciate. as you added key to add data for future requirement’s. great....

Thanks a lot… god bless you

Regards

Exceluser2707