Macro to copy formula from one cell to another

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Macro to copy formula from one cell to another

04-25-2014, 08:27 PM

macropod

Windows 7 32bit Macro to copy formula from one cell to another

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,467

From what you've described, you don't need a macro, just a formula:
=IF(B1="R",A1,"")

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula in cell b1 using cell a1 if a1 is over certain number	pumkinbug87	Excel	5	12-03-2013 12:34 PM
Change formula cell range based on cell value	Scoth	Excel	4	10-25-2012 07:51 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
Use formula to copy cell formats also	mike_abc	Excel	10	12-10-2011 01:55 AM
copy cell from sheet 2 to sheet 3 macro	slipperyjim	Excel Programming	1	02-18-2010 01:31 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:04 AM.