LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Data Validation On A Cells With Data From A Different Spreadsheet

Hi All,

I know that in Excel it says that you cannot reference a diffetent worksheet
when it comes to data validation, however is there any macro that I could use
or is there a formular or is there any other way ?



Your help would be greatly appreaciated.



Thanks in advance
Nat Govender
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Validation Blank Cells Louis Markowski Excel Worksheet Functions 2 October 11th 07 05:24 PM
Data Validation in Calculated Cells Gregory Winters Excel Discussion (Misc queries) 14 March 30th 07 06:48 PM
Data Validation based on other cells Jan Excel Worksheet Functions 3 February 28th 07 05:41 AM
How do set data validation using cells on a different worksheet? Paul Excel Discussion (Misc queries) 2 September 7th 06 04:59 PM
Data Validation (in a range of cells) Andrew Lindsay via OfficeKB.com Excel Worksheet Functions 2 May 26th 05 09:42 PM


All times are GMT +1. The time now is 07:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"