Screenshot 2019-04-18 at 22.37.58.pngScreenshot 2019-04-18 at 22.37.27.png
hi all.
In the first image i'm going to have names in cells B10 -> B150
On sheet 2, i want to add a formula where each print page area, has one name in cell B3, B35, B66 Etc.
Whenever i do B3 = Attendance!B10 it works, but when i copy and paste to next sheet, rather than automatically becoming = Attendance!B11 it becomes = Attendance!B42
I don't want to manually input this 150 times.
Eventually, each page on sheet three is going to have around 13 cells with data from the attendance sheet, and i want it to be the same for every page.
Any ideas?
Thanks
Ben
Bookmarks