PDA

View Full Version : File Organizer



bsquared06
10-20-2011, 01:00 PM
I am trying to organize a list of fies that are used by my design program. the extensions are .prt , .CATpart, and .dwg. I want to create a macro that will go through a list of the filenames and print an x in the appropriate cell for what type it is. it should look something like this:

.prt .CATpart .dwg
1234567.prt x x x
1234567.CATpart
1234567.dwg

I'm new to macros but I have lots of C language training so any help would be great! :)

mikerickson
10-20-2011, 02:52 PM
Actualy, you don't need a macro
Assuming that ".prt" is in cell B1, you could put the formula

=IF(RIGHT($A2,LEN(B$1))=B$1,"x","")

in B2 and drag down and to the right.

You could then use Copy/PasteSpecial values to convert these formula to the values that they return.