Hi there, i need some help with linking one sheet to another.
I have a Active Orders sheet which at the end you select two dates (template date & 14 days later the fit date) I want this to then go to the selected date on our template and fit planner. We dont use calendar view, just a sheet with a vertical calendar. Ill try and explain better below.
You manually select the dates you want on the far right, then i want this to populate the hightled cells (in one if poss) in the planner in the second screenshot.
Hope that makes sense!
Help Article Resources
Check out the Formula Handbook template!