I apologize for not making my Title more clear and descriptive, sometimes I am not the best with words..............
But, this is what I am trying to accomplish: I have created a Time Sheet Template. There is a different worksheet for each week, as well as a SUMMARY worksheet. Within the SUMMARY worksheet I have a column for 'Subtotals'. I want the cells in this column to equal the Subtotal for their respective week.
E.g. SUMMARY worksheet Row 1: Week 1
SUMMARY worksheet Row 2: Week 2
etc.
My issue arises from the fact that the Subtotal cell is not located in the same position (i.e Row, Column) on each separate worksheet. I was thinking of recording a macro where I use keyboard shortcuts to flip between the different worksheets and then search for 'Subtotal', move the cursor one cell to the right, etc. but I still do not know how to alter the macro so that it would go to the subsequent sheet.
Again, I apologize if this does not make much sense. But, if you think you do understand what I am asking, please HELP!!!. I have spent way too much time on this already.
Thanks.
Bookmarks