Hi Folks,
In have success at work and the code worked... It was as said... needed to be launched from a single instance...
Now it's time for a modification.
As you can see the Macro is calling the range from the following code:
Is it possible that this code be modified to look at the computer's Calendar and as the month changes, the range specified in the code can then be modified or automatically adjusted to place the Range being copied and placed in the appropriate column - For Example:
Worksheets("Goals").Range("F17") is for the month of April..... Worksheets("Goals").Range("G17") is for the month of May..... and so on - so when the user selects copy - the code see's the month and copies the range to the correct column - any thoughts on this?
John
Bookmarks