| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Marco to change formula according to what is written in the cell
Hi
Please help me; I need help with a Marco. I want to be able to change a certain word in the formula according to what is written in the cell. For example: If a formula in Cell A3 is as follow: ='Brisbane Metro'!G12 However if I wrote Gold Coast in Cell A1 it will change the above formula in Cell A3 from ='Brisbane Metro'!G12 To ='Gold Coast!G12 Thank you very much for your help!!! Please let me know if you need more information Best regards, Harn |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Marco to change formula according to what is written in the cell
You dont need a macro instead you can use INDIRECT()
Cell A3 =INDIRECT(A1&"!G12") If this post helps click Yes --------------- Jacob Skaria "Harn88" wrote: Hi Please help me; I need help with a Marco. I want to be able to change a certain word in the formula according to what is written in the cell. For example: If a formula in Cell A3 is as follow: ='Brisbane Metro'!G12 However if I wrote Gold Coast in Cell A1 it will change the above formula in Cell A3 from ='Brisbane Metro'!G12 To ='Gold Coast!G12 Thank you very much for your help!!! Please let me know if you need more information Best regards, Harn |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Marco to change formula according to what is written in the cell
Why not use Indirect?
from ='Brisbane Metro'!G12 to =INDIRECT("'" & A1 & "'!G12") "Harn88" wrote: Hi Please help me; I need help with a Marco. I want to be able to change a certain word in the formula according to what is written in the cell. For example: If a formula in Cell A3 is as follow: ='Brisbane Metro'!G12 However if I wrote Gold Coast in Cell A1 it will change the above formula in Cell A3 from ='Brisbane Metro'!G12 To ='Gold Coast!G12 Thank you very much for your help!!! Please let me know if you need more information Best regards, Harn |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change dollar amt to written form | Excel Discussion (Misc queries) | |||
| Identify if Cell is Formula or written number | Excel Worksheet Functions | |||
| Worksheet selection change (running marco when cell selected) | Excel Programming | |||
| using the name of a worksheet written in a cell, inside a formula | Excel Worksheet Functions | |||
| Is there a formula to change number value to the written value? | Excel Discussion (Misc queries) | |||
Hybrid Mode
