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

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Need macro to fill data from different sheets based on selected item from drop down

FAQ

Thread Tools

Display Modes

03-12-2015, 12:41 AM

skorasika

Windows 7 64bit Need macro to fill data from different sheets based on selected item from drop down

Office 2007

Novice

Join Date: Mar 2015

Posts: 1

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.

Attached Files

Automated Software Map Workbook V1.0_v1.xlsm (375.7 KB, 16 views)

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