Generic reference in a Macro
Would like to have a macro to transfer data from one sheet to the new
one.
I have a Feb sheet with data and want to transfer data to the NEW Mar
sheet.
Problem is that to do a MACRO for Mar from Feb-which works- would not
work in Apr to take data from Mar because the macro only sees for the
Mar from Feb named worksheets/macro.
Need to change the reference (previous month) to a generic
recognizable by the MACRO for all months.
|