Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-17-2016, 05:53 PM
vmangano vmangano is offline Auto Populating Data with Drop Down Menu Windows XP Auto Populating Data with Drop Down Menu Office 2013
Novice
Auto Populating Data with Drop Down Menu
 
Join Date: Dec 2016
Posts: 2
vmangano is on a distinguished road
Default Auto Populating Data with Drop Down Menu

Hello All,



I was wondering if it's possible to auto populate data from one worksheet to another. Specifically: I have a drop down menu in one column, that has names. When I select a name from that drop down menu, how can I have the data from that row populate into another worksheet?
Reply With Quote
  #2  
Old 12-19-2016, 02:20 AM
xor xor is offline Auto Populating Data with Drop Down Menu Windows 10 Auto Populating Data with Drop Down Menu Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

Choose name in Sheet2!B4.
Attached Files
File Type: xlsx vmangano.xlsx (10.6 KB, 10 views)
Reply With Quote
  #3  
Old 12-19-2016, 12:58 PM
vmangano vmangano is offline Auto Populating Data with Drop Down Menu Windows XP Auto Populating Data with Drop Down Menu Office 2013
Novice
Auto Populating Data with Drop Down Menu
 
Join Date: Dec 2016
Posts: 2
vmangano is on a distinguished road
Default

Quote:
Originally Posted by xor View Post
Choose name in Sheet2!B4.
Thank you for your response! I was actually wondering if it's possible to do something a little different.

In the worksheet 'Service Tracking', when filling in the information, is it possible to have the information from a row populate into another worksheet? When I select a name from a drop down menu, can I have that row of information populate in another worksheet? And as I fill in the remaining rows, can I have that information keep populating into the other worksheet?
Attached Files
File Type: xlsx 2017 Tracking.xlsx (47.7 KB, 10 views)
Reply With Quote
  #4  
Old 12-19-2016, 11:45 PM
xor xor is offline Auto Populating Data with Drop Down Menu Windows 10 Auto Populating Data with Drop Down Menu Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

I will take a look at it later today.
Reply With Quote
  #5  
Old 12-20-2016, 09:03 AM
xor xor is offline Auto Populating Data with Drop Down Menu Windows 10 Auto Populating Data with Drop Down Menu Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

It is a very small example you give so I am not sure if this is what you want.
Attached Files
File Type: xlsx 2017_Tracking_2.xlsx (50.5 KB, 7 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto Populating Data with Drop Down Menu pull data using drop down menu nfsmith Excel 8 03-23-2016 11:28 PM
Using Drop Down Menu to present Selected data in same sheet awaisdotcom Excel Programming 1 04-04-2015 12:40 PM
Auto Populating Data with Drop Down Menu HELP -- Drop Menu for Reoccuring Data?? cscaudle Word 1 03-02-2014 10:19 AM
Auto Populating Data with Drop Down Menu "Auto-populating" data-worksheet to worksheet. meggenm Excel 4 02-04-2012 02:04 AM
Auto Populating Data with Drop Down Menu Populating ComboBox or Drop Down list with contents of a text field Billy_McSkintos Word VBA 1 09-13-2011 05:50 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:27 AM.


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