Microsoft Office Forums Enter Number on any sheet one time only.

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-31-2006, 05:08 AM
paulrm906 paulrm906 is offline
Novice
Enter Number on any sheet one time only.
 
Join Date: Mar 2006
Posts: 3
paulrm906
Default Enter Number on any sheet one time only.

hello everyone

What I have is a sheet which is called "Credit Slip No" with all numbers from 1 to 1000 in Column A, now when they enter the Voucher number on any sheet (which may end up being lots of sheets) all the information pertaining to this Credit Slip No is then recorded in the sheet "Credit Slip No". Now my question is. Is it possable to prevent any person from entering the same Credit Slip No more then one time on any of the other sheets beside the sheet called "Credit Slip No". This Credit Slip No when entered on the other sheets is always entered into column A. So in actual fact the number is already in Sheet "Credit Slip No" in column A so now it can only be entered one more time on any of the other sheets. I hope I have not totally confused everyone with my explanation.

Paul Maynard
Moscow


Russia
Reply With Quote
  #2  
Old 04-28-2006, 07:35 AM
aceensor aceensor is offline
Novice
 
Join Date: Apr 2006
Posts: 5
aceensor
Default

If I'm understanding correctly, you're trying to avoid duplicate numbers - is that right?? Have you considered "Conditional Formatting"??
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Enter Number on any sheet one time only. Last Number in a Column paulrm906 Excel 1 12-05-2008 07:51 PM
Setting up Analysis Sheet when data does not exist, yet. burnoutdetective Excel 0 10-13-2008 05:57 AM
Enter Number on any sheet one time only. Enter Key issue vearls Word 1 07-23-2007 02:50 PM
No page number on appendix please davidaexp1 Word 0 08-22-2006 06:19 PM
sheet linking, sorting nickbfe Excel 0 05-19-2006 11:00 AM


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


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