Generate Report Code Wise..

Hello..

If any one can tryout this help..

Attached sample file and
1. Require to generate above report in separate sheet as Monthly Sales when input data is Code No. entered in D3
2. Require to generate Code-wise file (only Monthly Sales Report Sheet) for entered value at D3 / picked up code nos. from separate list
3. Instead of entering data at D3, can it be possible to have a entire list of Code No. in different sheet and pickup Code no. automatically, and generate data as required at sr. 1 and 2 above

Whether it is possible??

Regards,

Kundanlal

Thanks for suggestion..

This was sample data.. I am using Month-wise data of sales and generating report for each code separately. The report consist of other details as well which is not mentioned in the sample file.

My problem is that codes are running in hundreds. It is easy to generate a report file for
few codes.

I wanted a solution to generate report for each code separately. Any trick to generate this for list of codes.

Regards,
Kundanlal