Not sure what to title this....

Drdave1958

Board Regular
Joined
Mar 10, 2002
Messages
204
227G01 Tracking_newdates_111703.xls
ABCDEF
1JobNumberP14P15NeedMat'lbyShipDate
2PiecesinInventory40
3800914X20-Feb20-Feb05-Mar
4800916X24-Feb24-Feb09-Mar
5800917X05-Mar05-Mar19-Mar
6800918X12-Mar12-Mar26-Mar
780091918-Mar18-Mar18-Mar01-Apr
880092028-Mar28-Mar28-Mar11-Apr
980092104-Apr04-Apr04-Apr18-Apr
1080092211-Apr11-Apr11-Apr25-Apr
1180092318-Apr18-Apr18-Apr02-May
1280092425-Apr25-Apr25-Apr09-May
1380092502-May02-May02-May16-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-
 

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Watch MrExcel Video

Forum statistics

Threads
1,122,469
Messages
5,596,329
Members
414,055
Latest member
mcarduner

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top