Drdave1958
Board Regular
- Joined
- Mar 10, 2002
- Messages
- 204
227G01 Tracking_newdates_111703.xls | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | JobNumber | P14 | P15 | NeedMat'lby | ShipDate | |||
2 | PiecesinInventory | 4 | 0 | |||||
3 | 800914 | X | 20-Feb | 20-Feb | 05-Mar | |||
4 | 800916 | X | 24-Feb | 24-Feb | 09-Mar | |||
5 | 800917 | X | 05-Mar | 05-Mar | 19-Mar | |||
6 | 800918 | X | 12-Mar | 12-Mar | 26-Mar | |||
7 | 800919 | 18-Mar | 18-Mar | 18-Mar | 01-Apr | |||
8 | 800920 | 28-Mar | 28-Mar | 28-Mar | 11-Apr | |||
9 | 800921 | 04-Apr | 04-Apr | 04-Apr | 18-Apr | |||
10 | 800922 | 11-Apr | 11-Apr | 11-Apr | 25-Apr | |||
11 | 800923 | 18-Apr | 18-Apr | 18-Apr | 02-May | |||
12 | 800924 | 25-Apr | 25-Apr | 25-Apr | 09-May | |||
13 | 800925 | 02-May | 02-May | 02-May | 16-May | |||
Test |
The above sheet shows a small portion of a huge tracking sheet for an assembly. Row 2 shows the quantity of stock in inventory, of individual pieces (P14 & P15) that make up the assy. This is a number I will manually key in. I also will key in the ship date in column F, which drives column E. What I want to happen (I'm not sure if this is possible), If the number I key into D2 is< 1, (zero or blank will work), then D3:D13 will display the date in column E.
The second criteria is the more tricky one. If I key in a number > 0, (like 4 in my example) then that number of X"s will appear in the rows C3:C13. At the same time if I change the 4 back to a zero, then the X"s will disappear and the date driven by column E will re-appear. NOTE: Columns C & D are the same but show the two different results that are required.
Please advise if more clarity is needed.
Thanks in advance,
-Dave-