Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 04-16-2019, 07:56 PM
Ashith Rai Ashith Rai is offline Windows 10 Office 2007
Novice
 
Join Date: Apr 2019
Posts: 1
Ashith Rai is on a distinguished road
Default Query regarding MS Excel usage

Hi,



I had a requirement from MS Excel.
Pls go through the Attachment

When I select "Turning" through Drop Down, F5 must become uneditable
When I select "Milling", D6, E6 & I6 must become uneditable

This helps me make requirements to the user more specific. Pls check & let me know if this is feasible

Thanks.
Attached Files
File Type: xlsx Query.xlsx (10.6 KB, 1 views)
Reply With Quote
  #2  
Old 04-16-2019, 10:48 PM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 426
ArviLaanemets will become famous soon enough
Default

In case every field in columns OD:Speed can have only a certain set of values determined by description, it is possible using data validation lists in all fields, and making those lists depending on selection in column Description. It doesn't ecxactly restrict the entry, but for columns you want to restrict entry there will be nothing allowed to enter (the data validation list will be empty).

Otherwise I don't see a way for this. VBA doesn't help, as there is no event fired on activating another cell (as much as I know).
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Export Resource Usage sheet into excel Jshields2009 Project 4 03-09-2017 09:47 AM
Query and Power Query not working Excel 2016 bl10 Excel 0 07-22-2016 06:25 PM
Copy resource usage to excel cossie2k Project 1 11-29-2015 10:05 AM
Exporting Resource Usage data to Excel samg54 Project 1 08-02-2013 05:28 AM
How to Query Text in MS-Excel 2010 or Import Data & Query outside of Excel? mag Excel 0 10-18-2012 11:15 AM


All times are GMT -7. The time now is 08:50 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft