Thread: Excel 2007 to Excel 2003 (Split data to sheets)
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
  
Posts: 4,393
Default Excel 2007 to Excel 2003 (Split data to sheets)
It is only 10 cut and pastes
Working out and testing a VBA solution would take longer
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"BCLivell" wrote in message
...
Hi all-

I have a file in excel 2007 format that has 2214 colums and I need to put
into a format that can work with excel 2003. But my biggest barrier is
excel
2003's colum limit.

Essentailly, I need a simple way to cut and past every 250 columns into a
seperate sheet.

Thank you!




Reply With QuoteReply With Quote