+ Reply to Thread
Results 1 to 11 of 11

vlookup with random gaps in rows (hard to explain see attached sheet!)

Hybrid View

gasdesign vlookup with random gaps in... 11-07-2017, 08:54 AM
tim201110 Re: vlookup with random gaps... 11-07-2017, 09:43 AM
gasdesign Re: vlookup with random gaps... 11-07-2017, 09:50 AM
tim201110 Re: vlookup with random gaps... 11-07-2017, 09:56 AM
gasdesign Re: vlookup with random gaps... 11-07-2017, 10:03 AM
modytrane Re: vlookup with random gaps... 11-07-2017, 10:06 AM
modytrane Re: vlookup with random gaps... 11-07-2017, 10:09 AM
tim201110 Re: vlookup with random gaps... 11-07-2017, 10:08 AM
gasdesign Re: vlookup with random gaps... 11-07-2017, 10:56 AM
gasdesign Re: vlookup with random gaps... 11-07-2017, 10:32 AM
modytrane Re: vlookup with random gaps... 11-07-2017, 10:35 AM
  1. 11-07-2017, 10:06 AM #1
    modytrane is offline
    Forum Expert
    Join Date
    11-27-2007
    Location
    New Jersey, USA
    MS-Off Ver
    2013
    Posts
    1,669

    Re: vlookup with random gaps in rows (hard to explain see attached sheet!)

    How about using VBA.
    See attached sample.
    Click on the button and it will move data as you want.
    When you add data it will work as well.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 11-07-2017, 10:09 AM #2
    modytrane is offline
    Forum Expert
    Join Date
    11-27-2007
    Location
    New Jersey, USA
    MS-Off Ver
    2013
    Posts
    1,669

    Re: vlookup with random gaps in rows (hard to explain see attached sheet!)

    Here's the macro.

    HTML Code: 
    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)

Similar Threads

  1. Not sure if this is possible with excel and hard to explain but ....
    By hns2713 in forum Excel General
    Replies: 5
    Last Post: 01-19-2017, 05:46 PM
  2. trying to merge rows that have different column data needed. hard to explain..see pic..
    By SouthernCruizer in forum Excel General
    Replies: 7
    Last Post: 12-08-2014, 09:05 PM
  3. [SOLVED] Hard to explain, please help
    By FooFighter616 in forum Excel General
    Replies: 4
    Last Post: 06-13-2012, 02:20 PM
  4. Hard to explain question
    By odditie in forum Excel General
    Replies: 4
    Last Post: 02-16-2007, 05:09 PM
  5. [SOLVED] Help with spread sheet (Hard to explain)
    By facebuddies in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-08-2006, 11:04 AM
  6. Please help!!! This is hard to explain!
    By Robert Sadler in forum Excel General
    Replies: 4
    Last Post: 02-02-2005, 12:28 AM
  7. Please help!!! This is hard to explain!
    By Robert Sadler in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-01-2005, 05:48 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1