Need macro to fill data from different sheets based on selected item from drop down

skorasika · #1 03-12-2015, 12:41 AM

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.

charlesdh · #2 03-13-2015, 11:25 AM

Hi,

I reviewed your request and I do not see the data after you make a selection from the dropdown in the destination sheet. Can you provide a better example of what you need?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using Drop Down Menu to present Selected data in same sheet	awaisdotcom	Excel Programming	1	04-04-2015 12:40 PM
Populate Word Drop-down list with Excel column then auto fill form fields with Excel data	Faldinio	Word VBA	7	10-19-2014 06:03 AM
Returning a specific value when item is selected from a drop-down list	J Press	Excel	4	09-10-2012 06:12 AM
Conditional color fill based on presence of data	avanderh	Excel	11	07-28-2011 09:10 AM
creating macro for biffurcation in sheets according to data.	Nirik	Excel Programming	8	05-07-2011 05:11 AM