Need Help,VBA Move data from one sheet to multiple sheets customerwise

[rdmqpr]

Hi All,

I need VBA Code for example I attached,

Worksheets name is "Inventory"
Database in "Data" Sheet and require to move data to Multiple sheets shop wise,

Challenges is there is two times of VBA and one sheets, its possible ? How can I get this?,


Thanks in advance,

 

[Marc L]

Hi,

easier with no blank between title and data in shops …

So post your code and explain what's your difficulty.
Remember Macro recorder is the friend of beginner !
​

 

[sgmpatnaik]

@rdmqpr

why not you try the advance filter option, please download the file and check if any problem please inform
i have created a new tab named with Shop Data there i have mention as per your requirement

Thanks

SP

 

[rdmqpr]

thanks for reply, I want that one click then Shop sheets excel making and data comes base on sheets name,
this also workable but some easy way.