I would like to create a macro the copies data from a
list of named ranges and then do a past values into a
worksheet for trends. That, by itself, is no problem.
However, each month the paste values will be in a new
column (one for each month). Is there a way to pause the
macro so I can click the first cell in the receiving
range differently each month?

Thanks,
Jim