Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 03-31-2006, 05:08 AM
paulrm906 paulrm906 is offline
Enter Number on any sheet one time only.
Join Date: Mar 2006
Posts: 3
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
Reply With Quote
Old 04-28-2006, 07:35 AM
aceensor aceensor is offline
Join Date: Apr 2006
Posts: 5

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

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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:22 PM.

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