Re: Need to split excel file with header into smaller files with same headers in excel
The macro provided by KERRY2277has done exactly what my request was including the heders. Thank you for the assistance KERRY2277 you have made my day.
I now realised that I want the NEWto be created without any headers and must be in csv format. is this osmething easily done or do I need to log another request?
Thanks for you generous help on this topic.
Last edited by mnamaz; 05-20-2013 at 06:58 AM. Reason: Clarity
Hey no you only have to save and put in csv instead of save using same name and under save as type CSV (*CSV) as the drop down options
I am not sure I follow what to do. can you simplify it please
i did the following:
1.I removed the header from the original file and save it as a .csv file
2. I then saved the makro is Visual Basic from the Developer tab
3. I run the macro, it creates multiple files but it then uses the first row as the header for each file.
Last edited by mnamaz; 05-20-2013 at 12:10 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks