Franz,
Thanks! It worked exactly like I'd hoped. I have macro puzzler... I want to paste copied text into a cell and have the macro copy and paste the value of the cell directly to the left of the cell I just pasted into. in other words, I am pasting copied text into cell C9. I have cell B9 formated for NOW() and I want the macro to copy cell B9 and paste the value back into B9 when I paste into cell C9. Any ideas on how make this happen?
Keyrookie
Quote:
Originally Posted by Franz Verga
Hi Keyrookie,
try this way:
=IF(I7="p",G7,"")
--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)
Hope I helped you.
Thanks in advance for your feedback.
Ciao
Franz Verga from Italy
"Keyrookie" ha scritto nel messaggio
...
Help please,
This formula returns the value I'm looking for =IF(I7="p",G7) in cell
J7 only when I7 has a "p" input. When there is not a p in I7, FALSE
displays in cell J7. How do I get this to work w/o the "FALSE"
showing? I want cell J7 to be blank unless I type p in cell I7.
Confused,
Keyrookie
--
Keyrookie
|