Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 02-27-2013, 10:38 PM
macropod's Avatar
macropod macropod is offline Replacing texts Windows 7 64bit Replacing texts Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,366
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by aslamyahya View Post
The problem is this,

I have this calculation script that i have to use for around 100 times
...

I have values AAAAA, BBBBB, CCCCC, TRANSMTR1, TRANSMTR2, TRANSMTR3 and FINALXMTR in another sheet.

Can anyone help me with some macro that would enable me to do this
Without knowing where:
• your script is kept (eg a text file or a worksheet); or
• the values you want replaced can be found on the other sheet,
responding to your request requires some guesswork.

The attached Excel workbook assumes your script is kept on Sheet1 and the values are kept on Sheet2. Once you've input the data on Sheet 2, simply enter the number of a required script in cell A1 of Sheet1 and the script below will be updated. You can then copy/paste or export the script to wherever else you require it.

PS: When posting code, please use the code tags. They're on the 'Go Advanced' tab.
Attached Files
File Type: xls Script Generator.xls (60.0 KB, 9 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Clickable Links Converted to hyperlink texts automatically when I open a word doc Kingsly Word 2 09-13-2012 10:42 AM
Replacing texts change color of critical activity texts ketanco Project 3 01-05-2012 06:36 PM
Replacing texts Replacing default fonts mark98101 Word 1 01-31-2011 02:31 PM
word changes settings while copiing texts marja Word 2 11-29-2010 01:17 PM
Replacing / editting text LisaC Word 0 02-25-2010 03:40 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:45 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft