R
ryguy7272
I’m trying to come up with a way of saving files that end in a
specific number to a specific folder. So, I’d use =right(A2,1) and if
the right most number is a 6, save to a folder named 6, if the right-
most number is 2, save to a folder named 2, if the right most number
is 5, save to a folder named 5, etc. My numbers would be in ColumnY.
The Ron de Bruin code below is super-slick:
http://www.rondebruin.nl/copy5_3.htm
How can I modify that code to copy unique values to a sheet, save the
sheet as the name of the value, and save each sheet to a SPECIFIC
folder?
Thanks for your time and consideration with this!!
specific number to a specific folder. So, I’d use =right(A2,1) and if
the right most number is a 6, save to a folder named 6, if the right-
most number is 2, save to a folder named 2, if the right most number
is 5, save to a folder named 5, etc. My numbers would be in ColumnY.
The Ron de Bruin code below is super-slick:
http://www.rondebruin.nl/copy5_3.htm
How can I modify that code to copy unique values to a sheet, save the
sheet as the name of the value, and save each sheet to a SPECIFIC
folder?
Thanks for your time and consideration with this!!