Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-29-2014, 12:37 PM
paulys paulys is offline data validation from another sheet Windows 7 32bit data validation from another sheet Office 2007
Novice
data validation from another sheet
 
Join Date: Aug 2012
Location: Nayarambalam, Kochi, India
Posts: 11
paulys is on a distinguished road
Default data validation from another sheet


Hello friend, how can a select a list from sheet2 for data validation for a cell in sheet1?

Last edited by paulys; 06-30-2014 at 12:42 AM. Reason: i could get a solution to my problem myself. Thanks
Reply With Quote
  #2  
Old 06-30-2014, 01:40 AM
gebobs gebobs is offline data validation from another sheet Windows 7 64bit data validation from another sheet Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Put the data in another tab on your sheet1.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
data validation from another sheet Help Coloring a cell in Sheet one if data is missing from another sheet Aeducan Excel 1 06-22-2014 04:49 PM
data validation from another sheet Data Validation drop down rkalapura Excel 1 05-27-2012 02:23 AM
If/then formulas with data validation shira47 Excel 1 04-09-2012 05:14 AM
data validation from another sheet Data validation using indirect function BullMouse Excel 2 11-30-2011 05:25 PM
Data validation with IF Klyxrastafari Excel 1 10-03-2011 04:41 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:58 AM.


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