Hello all,
I am trying to use a formula that references the prior sheet. I was wondering if anyone can help me figure out how to do this without going into each sheet individually. This is VERY time consuming and I am sure there is a quicker way. I just have been unable to figure it out. When ever I try to select all sheets and put the formula in, It just references sheet 1. I need it to reference the prior sheet. I also need sheet 1 on reference the last sheet in the next row.
Please see example workbook.
Any help is greatly appreciated.
Thank you in advance!
-John
Bookmarks