Hey guys..does anyone know of a macro that can split one worksheet into 2,3, or even 4 workbooks? I am having trouble send such a large amount of data through email. Thanks alot for any help!
Jeff
Hey guys..does anyone know of a macro that can split one worksheet into 2,3, or even 4 workbooks? I am having trouble send such a large amount of data through email. Thanks alot for any help!
Jeff
What about zipping the file?
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
I'm just a newbie at VBA (but have been watching these guys for a while) but how about this macro? It lets the user define how many lines to transfer to each new workbook and creates however many workbooks is necessary. You're left with the original workbook and x subdivisions.Does this work for you?![]()
Please Login or Register to view this content.
Last edited by ChemistB; 03-25-2010 at 04:03 PM. Reason: Corrected Code
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks