cancel
Showing results for 
Search instead for 
Did you mean: 

Splitting Work Sheet

challaviswanath
Level 4
Hi, Can anyone tell me how to split the Excel Sheets? Suppose i have 50 records in Sheet1 i have to slpit it into 2 sheets as 25 records in Sheet2 and 25 records in Sheet3 like this. thank you
1 REPLY 1

Anonymous
Not applicable
Hi, the 'Copy and Paste Worksheet Range' action in Excel VBO should do. Thanks.