+ Reply to Thread
Results 1 to 5 of 5

Copy & Paste Macro (with funky lookup?)

  1. #1
    Registered User
    Join Date
    06-17-2014
    Location
    US
    MS-Off Ver
    2013
    Posts
    29

    Copy & Paste Macro (with funky lookup?)

    Hello,

    Looking for a little help with this. Excel file attached explains situation (colors and pictures included free of charge!). I think it could also be solved with a combo of OFFSET, VLOOKUP, MATCH, & INDEX maybe?

    Thanks in advance!!
    Justin
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Copy & Paste Macro (with funky lookup?)

    would this work?
    its basically an IF formula and some basic filtering which can be done quite easily in macro
    Attached Files Attached Files
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,605

    Re: Copy & Paste Macro (with funky lookup?)

    Pl see attached file with macro.
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Copy & Paste Macro (with funky lookup?)

    Maybe:

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    06-17-2014
    Location
    US
    MS-Off Ver
    2013
    Posts
    29

    Re: Copy & Paste Macro (with funky lookup?)

    Exactly what I needed, thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro V Lookup copy and paste from different worksheets
    By Fredbugatti in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-17-2014, 02:49 AM
  2. [SOLVED] Another funky lookup
    By russc2541 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-31-2014, 09:27 AM
  3. Macro or function to lookup and copy and paste the information
    By tjwm202 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-02-2009, 10:05 PM
  4. Macro to copy and paste or maybe lookup fx?
    By go4cdt in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-02-2009, 01:55 PM
  5. macro to lookup data and copy and paste
    By adamski in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-24-2008, 06:31 PM

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