How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Richard Your Own Question

Richard
Richard, Software Specialist
Category: Microsoft Office
Satisfied Customers: 31326
Experience:  Over 15 year experience resolving Microsoft Office Issues
32989067
Type Your Microsoft Office Question Here...
Richard is online now
A new question is answered every 9 seconds

Macro:Is it possible to change a word on one page and then

This answer was rated:

Macro:
Is it possible to change a word on one page and then let that same word that appears more than once in a paragraph on 2 other pages be changed as well ?
Can you tell me what program you are using?
Customer: replied 3 years ago.

Excel 2007

Hello,

To confirm, you have for example the word Apple, you change it to Orange, and you want any occurrence of Apple to be changed to Orange?

Customer: replied 3 years ago.


Correct

Thanks

Do you want me to make an example in Excel? Or do it to one of your files?

If one of your files,

- Click the following link: http://www.wikisend.com
- Upload the file to that website
- Once it is uploaded, the resulting page will display a "File ID" number.
- Please, give me that "File ID Number"

Thank you

Customer: replied 3 years ago.

Pse send sample in Excel and I will try to do it on my Workbook


 


Thank you

I have done the example which you download here

http://wikisend.com/download/345510/JA.xlsm

The Macro is simple but it shows you the function that need to use.

If you have any difficulties at all, please do not hesitate to let me know so I can assist you further

Thank you
Customer: replied 3 years ago.

Unfortunately I couldn't get the macro to work. I have uploaded my workbook: File ID 355590. Pse put the macro on as follows:


When the word "member" on page "Info" cell B17 changes then the same word must change on sheets: "AccOff: line22", MemResp: line8,line13,line19"; "MemRep: line8,line31,line36,line42,line55,line58"


 


Thank you


 

This is done for you and you can download it as File ID: 307764

Let me know if you have any difficulties please

Customer: replied 3 years ago.

Formula is working 100%. What can I add to "&Info!B17 &" so that words are in lower case?


 

You can use

&lower(Info!B17)

This will force it to Lower Case.

If you would like any additional information or assistance, please do not hesitate to let me know.

And if you can take a second to rate my service, that would be greatly appreciated.

Thank you
Richard, Software Specialist
Category: Microsoft Office
Satisfied Customers: 31326
Experience: Over 15 year experience resolving Microsoft Office Issues
Richard and 4 other Microsoft Office Specialists are ready to help you
Customer: replied 3 years ago.


When I pull through a date (28 February 2012) it shows it as a figure?


 


Anything I need to change to pull through a $ value ?

You would need to change the format of the cell to Date to show this.

But it would then need to be in a cell of itself.