[SOLVED} deleting rows and moving data

**abuchan** · 07-26-2009, 04:15 PM

I have created a spreadsheet with 4820 rows of data (4821 for computational purposes, the last row being blank) with 5 columns. I need help in doing three things.

1. every third row is blank and it needs to be removed (3, 6, 9,...4818, 4821). Once this is accomplished,

2. I need to move the data that is now found in the even rows, column E moved to the above, current odd row, column F. (ie. E2 to F1, E4 to F3, E6 to F5,...E4808 to F4807...,E4820 to F4819 (however it won't go this high). then

3. I need to delete all the current even rows, as the data I need will be in the odd rows.

I am hoping this is not as difficult to do as it is to explain. I am attaching a sample before and a sample after of what I am hoping to achieve.

Many thanks in advance.

**stanleydgromjr** · 07-26-2009, 07:15 PM

abuchan,

See the attached workbook "Move data Sheet1 to Sheet2 Step 3 - abuchan - SDG09.xlsm" with macro "MoveData".

Detach and open the workbook and run the "MoveData" macro.

The macro will move your data to Sheet2.

**abuchan** · 07-26-2009, 07:29 PM

Thank you. I will give it a try tonight and let you know how it works.

I appreciate your efforts,

Alec.

**abuchan** · 07-27-2009, 02:12 AM

Thank you! It work wonderfully.

Please correct me if I am incorrect, but in trying to figure out the code, it looks to me that it should work with any amount of rows, as long as they have the same format.

I will have a very similar challenge later this week, however a couple of the columns will be slightly different. I was trying to go through your code to see if I could make the minor changes to make it work. Is that something you recommend, or should I post the variation and go from there?

Thank you again. Your work is very effective.

**stanleydgromjr** · 07-27-2009, 08:52 AM

abuchan,

I will have a very similar challenge later this week, however a couple of the columns will be slightly different. I was trying to go through your code to see if I could make the minor changes to make it work. Is that something you recommend, or should I post the variation and go from there?

If you are not familiar with VBA, you should create a new post.

Then you can then send me a "Private Message" with a link to your new post, and I will check it out.