The attached file is the original file in which i have to implement this macro, thks jsmath n bjorns for ur help but still having problem with it. I want the first 13 rows to be same in all sheet and from O to T column i have the formula which should not be change & in ab & ac column i have the state & zone. all. the rows of data available in this file will not remain same every month it will keep on changing (either increase or decrease ). maximum rows will be 30000.

Attached Files

sample (new).zip (1.57 MB, 16 views)