james_simpson1998
New Member
- Joined
- Jul 30, 2020
- Messages
- 9
- Office Version
- 365
- Platform
- Windows
- Mobile
Now what if I wanted to take it a step further...
what if i had a separate table on another sheet which told me, for example transit times in weeks. Lets use for example 4 weeks total transit time.
And what I would like to do is to insert a week number into cell M92 for example, and total transit time for this example is 4 weeks which is what is on the table on the other sheet. So, M92 = 35 (for example), i would like P92 to pull through the date of week 35, O92 to pull through P92-4 total weeks from the other table? Does this make sense?
To make things easier, lets use a live example of what I am trying to achieve.
this is the info on the other sheet. and what I am trying to achieve is:
what if i had a separate table on another sheet which told me, for example transit times in weeks. Lets use for example 4 weeks total transit time.
And what I would like to do is to insert a week number into cell M92 for example, and total transit time for this example is 4 weeks which is what is on the table on the other sheet. So, M92 = 35 (for example), i would like P92 to pull through the date of week 35, O92 to pull through P92-4 total weeks from the other table? Does this make sense?
To make things easier, lets use a live example of what I am trying to achieve.
Supplier | Origin Country | Origin port | Destination port | Origin loading & trucking (weeks) | Quay-quay sailing / door-door trucking time (weeks) | Delivery to UK warehouse (weeks) |
Example 1 | USA | Norfolk | LGW | 1 | 3 | 1 |
this is the info on the other sheet. and what I am trying to achieve is:
Origin port | Dest port | Requested Ex Factory WK | Requested Ship WK | Requested UK Port WK | Requested Delivery WK | Requested Ship Date | Requested UK Port Date | Requested Delivery Date |
Norfolk | LGW | Insert week | =requested delivery date-3 weeks sailing time pulled through from other sheet (quay-quay value) | =requested delivery week in date format |