View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JayL JayL is offline
external usenet poster
 
Posts: 20
Default Split a worksheet?

All,
Looking for a way to take a worksheet that is 65000+ rows and split it into
20000 row worksheets. Adding a new worksheet and moving the rows over ??
Ideally, I would like to go to row 20k and back up to the 1st cell in Col B
that is 1, cut form that row down to a new sheet?

Is this possible?

-Jay