Harlan2010
New Member
- Joined
- Sep 9, 2010
- Messages
- 14
I'm using Excel as a log for transactions one of which is purchase orders. I have a block of numbers available for purchase orders - 100 -250.
What I would like to do is format a column called PO Numbers and let people pull the num,ber form the list for making an entry on that row. However I would like in subsequent rows on that column to no show numbers which had been previously used.
So my list would be:
100
101
102
103
104
105
106
107
108
109
110
A person could pick say 104 and complete an entry for PO # 104 on that row
100
101
102
103
104
105
106
107
108
109
110
When another person goes to make a new entry in the log they would have these numbers to pick from
100
101
102
103
105
106
107
108
109
110
104 would no longer be available
Is there a function or other operation that I can employ?
What I would like to do is format a column called PO Numbers and let people pull the num,ber form the list for making an entry on that row. However I would like in subsequent rows on that column to no show numbers which had been previously used.
So my list would be:
100
101
102
103
104
105
106
107
108
109
110
A person could pick say 104 and complete an entry for PO # 104 on that row
100
101
102
103
104
105
106
107
108
109
110
When another person goes to make a new entry in the log they would have these numbers to pick from
100
101
102
103
105
106
107
108
109
110
104 would no longer be available
Is there a function or other operation that I can employ?