Hi Friends,
I need VBA code for copy existing sheet(s) in to a new workbook.
i.e. I needs to copy two sheets (Active sheet and previous to the active sheet)from a workbook and the same two sheet needs to same as a new work book In a specified location with specified name(example like "Statement as on 31stAugust 2011(current date)"
Note:Sheet name may varies.I need to copy active and previous to the active sheet
Plz any one can help me to get the same.
Regards,
Prabhu
Bookmarks