Hi,

I receive data from my clients on a daily basis. I have to break the data according to respective areas. I am have developed a seperate sheet inorder to break the data according to requirements. but the problem persisting is that the format of the extracted report according to areas differs from the format of source data.
can someone suggest me how to get the same format as source data to the extracted report. can you give me the VBA code for that.

Thanks a lot in advance...