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

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-12-2015, 12:41 AM
skorasika skorasika is offline Need macro to fill data from different sheets based on selected item from drop down Windows 7 64bit Need macro to fill data from different sheets based on selected item from drop down Office 2007
Novice
Need macro to fill data from different sheets based on selected item from drop down
 
Join Date: Mar 2015
Posts: 1
skorasika is on a distinguished road
Default 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
File Type: xlsm Automated Software Map Workbook V1.0_v1.xlsm (375.7 KB, 7 views)
Reply With Quote
  #2  
Old 03-13-2015, 11:25 AM
charlesdh charlesdh is offline Need macro to fill data from different sheets based on selected item from drop down Windows 7 32bit Need macro to fill data from different sheets based on selected item from drop down Office 2010 32bit
Expert
 
Join Date: Apr 2014
Location: Mississippi
Posts: 382
charlesdh is on a distinguished road
Default

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?
Reply With Quote
Reply

Thread Tools
Display Modes


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
Need macro to fill data from different sheets based on selected item from drop down Conditional color fill based on presence of data avanderh Excel 11 07-28-2011 09:10 AM
Need macro to fill data from different sheets based on selected item from drop down creating macro for biffurcation in sheets according to data. Nirik Excel Programming 8 05-07-2011 05:11 AM


All times are GMT -7. The time now is 11:39 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft