I am repairing a time sheet and need to link from an input page to a summary page. My problem Is I have 7 different types of leave and on the Input page it contains the persons name in rows A and B and in row C is the different types of leave which run vertically down the worksheet, therefore every 8 cell in it restarts for the next person. In column AF is the totals I need to link to the summary page. But on the summary page where I need to link these totals it runs runs horizontally across where each type of leave has its own column from EZ to FF and each person has one row.
For example Summary page EZ5 needs to input page =AF5 and FA5 needs to = AF6 and so on. When I get down to AF11 It returns back to EZ where the next person starts.
I am also not able to change the layout of either the summary page or the input page.
Any help would be greatly appreciated.
Bookmarks