Cell Linking Iterations
I was wondering if there may be a way to format iterations to cell linking. I have an Intake Sheet, which then goes to multiple sheets. Being the "master" sheet, most of our Leadership will only be looking at this sheet. Is there a way where I can link an approval date, and then run an iteration or function to always link to the same sheet, just one row down?
I am trying to eliminate going into each row on the information sheet and linking it back to the master sheet. Thanks!