Sorry for the long winded title - don't know how else to describe it.
What I need is a formula that can copy the data in cells Q7:Q25 on the "Day Points" sheet to the "Cumulative Points" sheet in "Wk 1" cells B7:B27 and then reset the "Selection" sheet to the next week and then repeat upto week 52
Any help would be greatly appreciated!
Malawimick
Last edited by malawimick; 01-10-2012 at 04:46 AM.
If someone could just give me an idea of what formulas to use - I will try and solve this problem I am having.
Have been working for over 6 weeks on this workbook and would like to finish it
Thanks in advance
Malawimick
If you want to copy the data from sheet - Day Points to Cumulative Points, this can be achieved with a vlookup (incase the order of the names change) or even direct referencing (if the order of the names do not change). You can have a small macro that will go to each week copy the data and then reset the data and copy for the next wk.
However, how do we reset the Selections sheet to the next week? There is no dropdown or explanation of how to do it.
Cheers,
Arlette
If I helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks