+ Reply to Thread
Results 1 to 2 of 2

VBA Loop and offset

  1. #1
    Registered User
    Join Date
    10-28-2015
    Location
    BFE, USA
    MS-Off Ver
    2010
    Posts
    30

    VBA Loop and offset

    I have 2 columns of data and need help with a VBA loop to look for a specific word in column 1, then use the row above that word and move to previous found word. Copy the data to next available column to the right. I've attached a sample since this is as clear as mud. I'm sure this is simple for you gurus but my offset abilities are backwards.
    thank you
    CC
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,696

    Re: VBA Loop and offset

    Maybe :
    Please Login or Register  to view this content.

+ 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. [SOLVED] SUM offset ranges in a loop
    By alteredbeast in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-10-2018, 06:43 AM
  2. Using Offset in a loop
    By anthony1312002 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-01-2017, 02:01 PM
  3. Loop to offset down a worksheet
    By rlh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-19-2017, 08:55 PM
  4. Using offset to loop?
    By MeggieDoodles in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-22-2015, 03:29 PM
  5. [SOLVED] For..Next, offset, nested loop
    By Gingin8639 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-05-2012, 10:23 AM
  6. Using offset with in a loop
    By hoffey in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-30-2009, 05:49 PM
  7. VBA help for DO LOOP and Offset
    By NKeller in forum Excel General
    Replies: 1
    Last Post: 07-04-2005, 08:05 PM

Tags for this Thread

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