View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
uberathlete[_9_] uberathlete[_9_] is offline
external usenet poster
 
Posts: 1
Default Conditional Autofill


Hi all! I've got this problem and it's really bugging me!!

Say, I've got Sheet 1 (attached) and there's some formula (assume it'
some VLOOKUP formula) on D3. I basically need some macro that woul
autofill the formula in D3 down to all the other cells in column D
EXCEPT for those cells with no corresponding value in the B column an
those with "Total".

Any help would be greatly appreciated. Thanks

+-------------------------------------------------------------------
|Filename: Sheet 1.JPG
|Download: http://www.excelforum.com/attachment.php?postid=4018
+-------------------------------------------------------------------

--
uberathlet
-----------------------------------------------------------------------
uberathlete's Profile: http://www.excelforum.com/member.php...fo&userid=2838
View this thread: http://www.excelforum.com/showthread.php?threadid=48351