i have little problem with excel macro, I have workbook name "master" in which i have 52 sheets, if i select all sheets & then do some process (which is happen with all sheets) .the one sheet which mi working process is perfect but in rest sheets data is not properly processed which i desire. Just look in to steps which i want do with data all sheet data.
Step 1 Copy cell A2 & B2 & fill down till data in column C
Step 2 Move Or Copy - Create a copy - new book
Step 3 save new book in name of sheet (excel version 97 - 2003) & same for whole 52 sheet (save differently i.e. individual workbook) like sheet4.xls , sheet5.xls , sheet6.xls & so on
i am attaching "Master" workbook & result workbook
in sheet you will see what i want it.
so there is any macro to minimize this lengthy process.
pls help me out