Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Count the number of rows on a worksheet, divide the count by 15

  Asked By: Jamil    Date: Oct 10    Category: MS Office    Views: 880
  

I am completely new to scripting,
i want a script that
1. count the no. of rows in a sheet
2. Divide the count by 15
( For ex. if the count is 45, divide it by 15, which is 3)
3. Copy the first 3 rows of data into a new worksheet and save
it as .csv file. ( so in this case i need 15 new .csv files with 3 rows
of data in each worksheet)

Share: 

 

No Answers Found. Be the First, To Post Answer.

 




Tagged: