+ Reply to Thread
Results 1 to 2 of 2

Is a Macro going to be the best way to copy Column range if value cell D87 is found

  1. 12-21-2011, 11:10 AM #1
    extremecorvette
    extremecorvette is offline
    Registered User
    Join Date
    02-14-2011
    Location
    Muscatine, Iowa
    MS-Off Ver
    Excel 2010
    Posts
    30

    Is a Macro going to be the best way to copy Column range if value cell D87 is found

    I'm trying to find a Macro or Formula to copy Column range if value in cell D87 is found in Row D84:R84. This value will change from day to day. So if value today is 6.75 is in D87 it will look at the Row D84:R84 and find 6.75 and copy the data in cells that correspond to the column the number is found in, say it was found in F. So it would copy F3:F77 then paste it in C264:C339.
    Last edited by extremecorvette; 12-21-2011 at 12:01 PM.
    Reply With QuoteRegister To Reply
  2. 12-21-2011, 12:00 PM #2
    extremecorvette
    extremecorvette is offline
    Registered User
    Join Date
    02-14-2011
    Location
    Muscatine, Iowa
    MS-Off Ver
    Excel 2010
    Posts
    30

    Re: Is a Macro going to be the best way to copy Column range if value cell D87 is fou

    =iferror(index($d$3:$r$77,rows($c$264:$c264),match($d$87,$d$84:$r$84,0)),"")
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1