-
File Organizer
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!
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules