Need VBA Macro to Copy and paste column data in blank rows and repeat through spreadsheet

Hi All,

Im a bit of a n00b with these Macros and have been trying to modify some VBA code I used for a different but similar task without success. What I want to do is ensure that there are no blank cells in the the first 2 columns of my spreadsheet.

The data is stored like this

AA : 12 : 34 : 45
: : : 46
: : : 47
BB : 23 : 34 : 48
: : : 49
CC : 45 : 34 : 50
DD: 67 : 34 : 51
: : : 52
: : :53
EE: 91 : 34 :54

And id like the Macro to run through the sheet a copy columns 1 and 2 and paste them into proceeding rows until they hit the next set of data, then copy those cells and paste until they hit the next and so on, so the sheet looks like this

AA : 12 : 34 : 45
AA : 12 : : 46
AA : 12 : : 47
BB : 23 : 34 : 48
BB : 23 : : 49
CC : 45 : 34: 50
DD: 67 : 34 : 51
DD: 67 : : 52
DD: 67: :53
EE: 91 : :54

Sorry for the shitty drawing but let me know if you have any ideas. This is what I tried to no avail

Please Login or Register  to view this content.

http://www.contextures.com/xlDataEntry02.html

This has exactly what you need.

You dont need VBA to do this btw.

Hi slk1186

Welcome to the Forum!!

Please fix your Code Tags...you're missing the leading forward slash in the closing [/CODE].

Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

Include in the attachment any code you're currently using (whether it works or not) and an "After" worksheet that demonstrates what you wish the output to be.

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the "Add Files"... button to locate your file for uploading.
6. This will open a new window File Upload...Click "Select Files"
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the "Upload Files" button and wait until the file has uploaded.
10. Click the "Done" Button.

Why are you using VBA instead of find Blanks =cellabove? then copy paste values?

I would read this.
http://www.cpearson.com/excel/DebuggingVBA.aspx

It will help you walk through the code.