• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 190
  • Last Modified:

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?


0
daiwhyte
Asked:
daiwhyte
  • 4
  • 2
  • 2
  • +1
1 Solution
 
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
 
jppintoCommented:
Agree with Roy, why invent the wheel when it's already been invented! :)
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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:
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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 4
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now