Inventory workbook macro

[rdmqpr]

Hi all,
I has uploaded excel file , I need your help for making VBA,
the "Data" Sheets in "Inventory" workbooks have all data which is Sales and Purchase both in one sheet for all sales Shops and requirement is One click to separated Sheet base on Shopwise Sales and Purchase register and Balance stock automatically ,

How can I do VBA, Please send help me for that,

Thanks in advance,

 

[sgmpatnaik]

Cross Posting

http://chandoo.org/forum/threads/ne...-sheet-to-multiple-sheets-customerwise.18016/

Ninja's please lock one

Thanks

SP