View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
JR573PUTT
 
Posts: n/a
Default Copy Formula That References Another Sheet


Dave Peterson Wrote:
If you're new to macros, you may want to read David McRitchie's intro
at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

JR573PUTT wrote:

How do I use this code? Not familiar with code..............

--
JR573PUTT

------------------------------------------------------------------------
JR573PUTT's Profile:

http://www.excelforum.com/member.php...o&userid=31587
View this thread:

http://www.excelforum.com/showthread...hreadid=513310

--

Dave Peterson


I figured out a better way:

Highlight source worksheet column,
click copy
go to recipient worksheet and paste
Go to Edit Links, change source worksheet to recipient worksheet,
click ok.

Works great...............thanks again for your help


--
JR573PUTT
------------------------------------------------------------------------
JR573PUTT's Profile: http://www.excelforum.com/member.php...o&userid=31587
View this thread: http://www.excelforum.com/showthread...hreadid=513310