[VBA] Offset/Move Values

  • I am having an issue manipulating a flat file. The macro I have right now does everything I need, except for one thing.

    I sometimes have values in extended columns, rather than below onto the next row. How can I shift/offset these values to the rows below.

    I have 2 grids below, one with an example as it is now and another of what I would like to occur. The values that change will be in RED. The values in RED are sporadic, in terms of which flat file they show up in. I made them red to make it easier to find, they are only red for this example and it is not indicative of any other file set.

    Also, I have attached an example excel document with sample data.


    Example - Ugly:

    Example - Good:

    Links to other forums:
    Contains link to download data in xlsx: http://www.excelforum.com/exce…value-details-inside.html
    Has data in forum table: http://www.mrexcel.com/forum/e…set-shift-move-value.html

    Thanks for the help!

  • Re: [VBA] Offset/Move Values

    Well, thanks for getting me on the right track everyone, especially 6StringJazzer @ EF. Here is the final product:

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!