#1
|
|||
|
|||
Show result of formula as a value in another cell
Hi I have a formula that returns a value (number) in cell G5. I would like that value to appear as just the value in another cell (D8), so it can be used by another (index match) formula. If I just put =G5 in cell D8, I don't think the second formula will work, as it will be looking to match "=G5" rather than the number itself. Is there a solution? Thanks |
#2
|
|||
|
|||
It's OK. I will just make a little macro to copy the result of the formula and paste special (value) into the required cell.
|
#3
|
||||
|
||||
Quote:
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#4
|
|||
|
|||
OK, I will try that too.
Many thanks Steve |
#5
|
|||
|
|||
If you still want to copy as originally asked in your question just write a lil macro
E.G. Sub CopyValue() Range("G5").Select Selection.Copy Range("D8").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False End Sub |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel formula from looking the base date and convert into desire result | PRADEEPB270 | Excel | 1 | 02-17-2013 03:11 AM |
Convert Formula Result to Static Text | MYGS | Excel | 16 | 01-21-2013 08:18 AM |
If formula result is negative then display text | oxicottin | Excel | 3 | 12-03-2012 02:12 AM |
IF formula returns wrong result | mashley | Excel | 3 | 09-07-2012 07:03 AM |
Can I create a formula that will show result in the same cell and let me copy it down | CranstC | Excel | 1 | 02-11-2012 01:29 AM |