vba to split data to multiple sheet

[Dalia]

HI,

I have read the artice http://chandoo.org/wp/2012/05/14/vba-move-data-from-one-sheet-to-multiple-sheets/. In that article the sheets 1 ,2 and 3 are already added,so, incase the sheets are not there and we need to add the sheets how we will add it in that code so that the sheets as well as the data get generated

 

[Marc L]

Hi !

Via Worksheets.Add (to see in VBA inner help)
as you can try yourself activating Macro recorder and create one …
​

 

[Dalia]

Hi,
Can you please show it in the code because it ll come we cannot rename a worksheet as it involves looping. If it is a huge data with employee code 1 to 25 how I will generate this 25 sheets by looping.

 

[Marc L]

As a worksheet can be renamed within a loop …
Just use statement where you need to create a worksheet even inside a loop.

Other way as you must yet read in Worksheets.Add VBA inner help :
create all worksheets at once using its Count parameter before looping …
​