VBA code required for paste special and delete rows in multiple sheets

[exceluser9]

Hi Team,

I have 5 sheets in a excel file and it will be saved in desktop with name Available_Book_Wk

5 sheet names are
Berry and Detail
All prod Sum
All sum Grey
Data Summary
Online Avail

Below are the features i require in 5 sheets

Berry and Detail - Do a paste special of all data
All prod Sum - Replace all #DIV/0! and #VALUE! with blanks
All sum Grey - Filter L17 which is = 0 and delete entire rows
Data Summary - Do a paste special of all data
Online Avail - Filter L17 which is = 0 and delete entire rows

I require a VBA code which has to open this excel file from desktop and perform the activity and save the file.
Basically my macro has to be a separate file which will perform activity in the file Available_Book_Wk

Thanks in advance