Results 1 to 7 of 7

Macro to Find a Value and Copy a certain Range

Threaded View

  1. #1
    Registered User
    Join Date
    02-02-2011
    Location
    Ft Lewis, WA
    MS-Off Ver
    Excel 2003
    Posts
    25

    Macro to Find a Value and Copy a certain Range

    Trying to build a macro that will search in Sheet 11 range AA1 to AZ 1, for the first occurance of the value of Sheet 13 A1. Once that row is found, next search for in Column AA for WDR and where the matched column and row are found copy the data along that row and paste into sheet 14. I need the same thing done for WSP, CIG, and OBV. Attached is a Sample. Thank You.
    Attached Files Attached Files

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1