Thread: Finding a value and copying the formula from an adjacent cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
akronpow[_3_] akronpow[_3_] is offline
external usenet poster
  
Posts: 1
Default Finding a value and copying the formula from an adjacent cell

I am trying to write a macro that takes a value in Sheet 1 and finds i
in Sheet 2. Then once the value is found in sheet 2, the hyperlin
formula in the adjacent right cell is copied over to a specific cell i
Sheet 1. I couldn't use the VLOOKUP function because that just carrie
over the value, but I need to formula to copy over

--
akronpo
-----------------------------------------------------------------------
akronpow's Profile: http://www.excelforum.com/member.php...fo&userid=2910
View this thread: http://www.excelforum.com/showthread.php?threadid=48823

Reply With QuoteReply With Quote