Splitting out Excel data to multiple files based on one column values
Hi all, I need help with this Sheet1 to Many Workbooks macro that I found in an old thread linked below.
http://www.excelforum.com/excel-prog...ns-values.html
My question is which part of the code do I need to remove so that it does not save the new files with the current date in the file names.
Thank you!
You'd remove this section:
Please Login or Register to view this content.
Want to show appreciation for the help you received from a member? Give them reps by clicking the bottom left of their post!
with respect to JB..
change this line
to this..Please Login or Register to view this content.
Please Login or Register to view this content.
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
Thanks everyone. I ran into a weird issue when I ran this macro. My data is in columns A-AL, so I set the title row range from A1 to AL1. However, when I ran the macro, it seemed to create a bunch of extra blank columns from AM to EE. I say it appears to be an issue because when I scroll all the way to the right, it goes to column EE as opposed to the last column with data in it (AL), but again, those columns are empty.
Any ideas what would cause this to happen?
Can you post the code so we don't have to go get it and then speculate as to how you changed it?
Click the * Add Reputation button in the lower left hand corner of this post to say thanks.
Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.
Yes, sorry. Here is the code. Looks like there are several references to "EE" in the default code so I'm assuming it is related to those.
Please Login or Register to view this content.
So when you say scroll what do you mean? Are you holding down control and using right arrow and you expect it to stop at AM and instead it's going to EE?
The code is taking a column that you specify and copying it to column EE probably because that's far enough to the right that there's little chance you will have existing data there. The code clears that data, when it's done with it but if you using control + right arrow and it's going to that column then there's something in Excel that's causing it to do that. Might be because usedrange incorporated that column. There shouldn't be any data in that column. If there is not data in that column why is this an issue to you?
Last edited by skywriter; 11-04-2015 at 04:57 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks