agnesz
09-26-2007, 06:44 AM
:banghead:
I have an Excel spreadsheet which needs to have 4 columns copied and pasted each week from the previous week into the next. I would like to create a macro which first asks the user which week they want to copy formulas from, i.e. week 2, then the macro would go to the 4 columns designated for week 2 (in this case range k6:n100), copy formulas into week 3 columns (range o7:r100), AND THEN go back and paste values into k6:n100, to maintain the history. Any help would be greatly, immensely appreciated!
Additionally, there is a Last Week Average Retail $ column which also would need to get updated after user inputs their value. So again, if user enters week 2 as the value, that means the Last Week Average Retail $ will now need to reflect a formula calculating week 3's retail, in this case the formula would change from - n6/k6 to r6/o6, and then need to be copied down throughout the entire range of f6:f100.
Hope this makes sense... Again thank you for all your help in advance.
:mkay I'm saddened by my lack of skills in this department.
</IMG></IMG>
I have an Excel spreadsheet which needs to have 4 columns copied and pasted each week from the previous week into the next. I would like to create a macro which first asks the user which week they want to copy formulas from, i.e. week 2, then the macro would go to the 4 columns designated for week 2 (in this case range k6:n100), copy formulas into week 3 columns (range o7:r100), AND THEN go back and paste values into k6:n100, to maintain the history. Any help would be greatly, immensely appreciated!
Additionally, there is a Last Week Average Retail $ column which also would need to get updated after user inputs their value. So again, if user enters week 2 as the value, that means the Last Week Average Retail $ will now need to reflect a formula calculating week 3's retail, in this case the formula would change from - n6/k6 to r6/o6, and then need to be copied down throughout the entire range of f6:f100.
Hope this makes sense... Again thank you for all your help in advance.
:mkay I'm saddened by my lack of skills in this department.
</IMG></IMG>