steve400243
Active Member
- Joined
- Sep 15, 2016
- Messages
- 429
- Office Version
- 365
- 2016
- Platform
- Windows
Hello, I use this cell formula to return the data to cell A3 - "Received or Shipped" I also need ""Order" to populate if a date is entered into cell G3. and "Storage" to Populate if M3 >2. Changing each time new dates are entered in to cells D3, G3, and F3 and when cell M3 is greater than 2.
Hope that makes sense? Please let me know if you need additional information. Thank you for your time.
Hope that makes sense? Please let me know if you need additional information. Thank you for your time.
VBA Code:
=IF(D3="","",IF(F3="","Received","Shipped"))