Macro to auto dropdown while typing

[nbuddhi]

Dear Team,

I need your help to get an excell macro to fulfill below requirements

1.0 There is a workbook with multiple sheets including a specific sheet called "Acc Names" and column "A" and "B" have some lists
2.0 I need to auto list down while typing on any sheet cells of column "C" with the list details of sheet "Acc Names", column "A"
3.0 Similar to above, need to list down while typing on any sheet cells of column "D" with the list details of sheet "Acc Names", column "B"

Greatly appreciate your support on this regards.

Thanks & Best Rgds,
nbuddhi