Jun 01 2021 02:05 PM
Hello. I am trying to edit my purchase/sales schedule for RM and the formula is throwing me off a bit.
The input at the top is weeks, and based on how many weeks is entered I need row 16 to move in columns the # of weeks & to row 9.
Jun 01 2021 10:06 PM
@fcrabtree I'm afraid you need to put a bit more effort into explaining what you need. What do you mean by "to move in columns the # of weeks & to row 9"?
Would be helpful if you could give a realistic example of what you would like to see (manually entered) as a result if the lead time is 4 weeks, for instance. And uploading the example file would be extremely helpful as well.
Jun 02 2021 07:08 AM
Jun 02 2021 07:25 AM