Need macro to fill data from different sheets based on selected item from drop down
Hi,
I have 27 sheets in work book with data range from A3:H20 each sheet.
I need this data display in new sheet from range starts from D27:J41 when user selected data from drop down menu.
attached sheet here to understand more.
Sheet name - Requirement Input , user will select sheet from drop down from C7.
data need to display in "Output Software Maps" tab from D27: I45
Thanks
Sekhar.
|