LinkBack URL
About LinkBacks
Hello,
Looking for suggestions on how to create an inventory tracking sheet that will track items received to end of life cycle/recycle or resale
Hello,
Looking for suggestions on how to create an inventory tracking sheet that will track items received to end of life cycle/recycle or resale
Hi ecotech,
There are a lot of methods on how to track inventory with Excel,
but what are you trying to do,
We are a help forum, your question is very open ended and can go in any direction.
What are the requirements and what do you have right now and what is your desired outcome?
Then attached that sheet alongside your question.
Last column i need if sea frieght plus 70 days,air frieght plus 20 days and road transport ddp plus 1 day to from delivery date column.
Last column i need if sea frieght plus 70 days,air frieght plus 20 days and road transport ddp plus 1 day to from delivery date column.
Please help me on the attached
Create sheet2 "A1" Description "B1" Days
"A2" Sea Freight "B2" 70
"A3" Free delivered / Truck "B3" 1
"A4" Air Freight "B4" 20
"M2"copy paste down up to end data range.Formula:
Please Login or Register to view this content.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
Try, =LOOKUP(K2,{"","Air Freight","Free delivered / Truck","Sea Freight"},{"",20,1,70})
Re: Inventory tracking
i need end resutl actual date = dleivery date(column E) + frieght mode
Last edited by kalis; 02-18-2023 at 01:44 AM.
see post 6
I just need to track items that I receive and once processed how many are repurposed and what is recycled. Thank you hope this is a helpful
Perhaps, M2=LOOKUP(K2,{"","Air Freight","Free delivered / Truck","Sea Freight"},{"",20,1,70})+F2
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks