[VBA - Help] Offset/Move Value - Details Inside...

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.


Thanks!

Example - Ugly:
\1

Example - Good:
\1

EDIT: Replaced bottom link, because it was duplicate.
EDIT: Links to cross posted are below
http://www.mrexcel.com/forum/excel-q...ove-value.html
http://www.ozgrid.com/forum/showthread.php?t=199607

You linked the same image twice--Ugly and Good are the same image.

Cross posted at 2 other sites, that I know of.

Originally Posted by 6StringJazzer

Can you provide the macro?

Originally Posted by skywriter

Cross posted at 2 other sites, that I know of.

At least 2 others...

Using the all resources that I can.

The first one I posted to was to busy. Then I posted here, and it got lost as well. The third one requested I post where I cross posted, and it hasn't gotten buried to deep yet.

Edit: Original post now contains links to other forum threads.

Thanks.

By the way.

I tried using this:

Please Login or Register  to view this content.

And while it did move the values from the adjascent columns over to the left and down a row...it also deleted all of the data above its intended destination. How can I modify it so I dont lose that data?

Thanks for this, that worked perfect for the data set at hand!

But, I forgot to include a data set that had more than 2 values I needed to move. Let's say I needed to move 6 additional (adjacent) values....How would that work? Because now J & K are empty, but the columns to right right are not and also H & I also contain values.

Thanks again!

Okay will do, thank you. I had fixed it at about the same time you had posted. There is one more issue after looking at the data before I can finish it...how can I make it so it inserts a new row below before it sets the cells equal to each other?

Thanks again!

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.