help please! i need to create a Excel macro to auto archive and store data in my H drive

[rohimabegum2]

Hi all,

im new to macros and was hoping someone can helpme. I need the macro to archive a sheet and store it in my H drive, can anyone help me?

 

[ranman256]

Record a macro to your Personal Workbook.
copy the worksheet to that drive,
stop the macro,
edit the macro,
alter the specific worksheet names to ACTIVESHEET. (Or activeworkbook)