PC Review


Reply
Thread Tools Rate Thread

Data validation help

 
 
Louja
Guest
Posts: n/a
 
      13th Apr 2012
I think its data validation I need.

I am developing a sheet which will have the info entered into across
the page. There will be lots of rows of info entered on this sheet.
Each row will need the same rules.

The user will need to select the currency e.g. GBP if its GBP they
will be able to enter info into certain cells but not others. Also if
its non GBP there is another cell that will need to be entered into
and cells I won't want entered into.

Is there any way I can set up some rules to do that.
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
custom data validation on cells with data validation values AKrobbins Microsoft Excel Worksheet Functions 2 21st Jun 2011 04:20 PM
Data validation on data validation function Peter Microsoft Excel Misc 1 22nd Sep 2009 10:56 PM
Data Validation based on first, second or third data validation li =?Utf-8?B?U3V6YW5uZQ==?= Microsoft Excel Programming 2 5th Nov 2007 02:48 PM
When pasting data into a column with data validation I lose validation check Brad Microsoft Excel Misc 5 17th Apr 2004 01:11 PM
Help! Help! Help! Help! Help! Help! Help! Help! Help! Help! Help! Help! Help! -$- Windows XP Internet Explorer 2 21st Dec 2003 11:45 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:01 AM.