Macro Required

Hi

I would like to create a macro button on my users Excel 2003 to check a column P for entries and change it the cell to something else.

Example for what the macro data needs to be checked/changed to.

Full Time Employment needs to be changed to Employed FT
Part Time Employment needs to be changed to Employed PT.

Possibly done by a formula?


daiwhyteAsked:
Who is Participating?
 
mohanupadhyayConnect With a Mentor Commented:
0
 
Rory ArchibaldCommented:
You could just use Find/Replace for that?
0
 
daiwhyteAuthor Commented:
Yes, but I want to automate it so my users only have to hit the macro button and viola - its done.
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
jppintoCommented:
Agree with Roy, why invent the wheel when it's already been invented! :)
0
 
jppintoCommented:
You would need to define ALL the text that you want to change and for what you want to change it! If this is not a fixed list, then it's the same as making Ctrl+H to open the Find and Replace dialog box and entering the information to search and the replacement text...
0
 
daiwhyteAuthor Commented:
This is the beginning of a macro which I would like to transform quite a few fields, once I got the macro doing the Employed bit, I will add the next macro function to it.

I hear what your saying thou guys - if it was just for the one column - the users would be able to use the find/replace without any hitches.
0
 
Rory ArchibaldCommented:
It's basically just:
Range("P:P").Replace "Full Time Employment", "Employed FT"

Open in new window

and so on.
0
 
mohanupadhyayCommented:
Above attached a macro file
Test it , use it
0
 
daiwhyteAuthor Commented:
mohanupadhyay, thats it - thank you.

Im going to award the points and will be opening up a new thread for the 2nd part of the process/macro.
0
 
daiwhyteAuthor Commented:
Thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.