I'm trying to separate the contents of an excel worksheet into several files for easier processing. What I have is a worksheet with information in several columns. The output files need to have contents of say:
1st file) Columns A + B + C + D
2nd file) Columns A + E + F + G
3rd file) Columns A + H + I + J
Column A information need to be attached to this grouping or output files all the time..Really appreciate all your inputs on this
The attached file will do it while giving flexibility on file names, number of files, and column specifications.
Have fun!
MyXL.xlsm
Acts 4:12
Salvation is found in no one else, for there is no other name under heaven given to mankind by which we must be saved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks