So, instead of separate workbooks based on Sales#,
you'd like separate workbooks based on SalesID?
with all Sales#'s for that SalesID?
I'll see what I can do.
I'll get back with you in the next few minutes.
Paul
-
“Do all the good you can,
By all the
Yes sir. I apologize for not being clear. I purchased the 2007 Excel
Bible last night. Hopefully I'll be able to help people such as you do.
Thank you so much! On Tuesday, October 9, 2012 7:22:44 AM UTC-4, Paul
Schreiner wrote:
So, instead of separate workbooks based on Sales#,
you'd
This is amazing! Thanks again! I think I need to tweak a few things but I
can't thank you enough. This really going to help. Works very well. I
get a Path not found error but I believe that's because I ran it on my
machine. Notice you created a destination folder seemingly unique to your
Yeah, that's the part where I said:
You'll notice in the macro that the
Destination folder, and Sheet names
will need to be set.
'- --
ShtData = Source Data Format
ShtID = Sales IDs
DestFolder = C:\temp\VBA\testing\
I need a macro that will copy specific rows based on the first value in my
example:
A1 B1, C1, D1, E1, Etc... thru AA1
0041
0042
0043
0041
0041
0043
Etc...
A1 is the reference value. B1 through AA1 indicate the Data range I need
copied to a new worksheet but a workbook would be
Are you saying that you want each row of data copied to a NEW workbook?
or are you say that you have multiple rows
that you want copied to separate workbooks based on the value in column A for
each row?
either way is easily done.
Paul
-
“Do all the good
Option b please. Multiple rows based on value in column A. So everytime
4011 is found in column A, I would want the the corresponding row data
pasted into a separate workbook and tha sme for 4010, 4012, etc...I
appreciate the help. I know it's not hard, I'm just limited in terms of my
VBA
How do you want the files named?
Do you want them in a specific folder?
Do you want them left open at the completion of the macro? or close them all?
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places
Named and left open as I need to send them to their respective owners. I
attached a file for your reference to help better understand. You'll
notice how Bob has many numbers and others have 2 and others have one Sales
ID number. I also attached the Header format and the exact number of