View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Harry's GMail World Harry's GMail World is offline
external usenet poster
 
Posts: 12
Default 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.