VBA Copy + Paste Values down a column

[geoffffffff]

Hi,

I'm a super novice with this stuff, but looking to get a macro with basic copy+paste functionality.

In the attached sheet I want to start in cell A1 and then as it works down the column:

- If a cell is not blank, copy that cell and paste it in all below blank cells until the next non-blank cell
- Repeat
- End if say the number of blank cells below the last copied cell is > 50

Thank you so much in advance!!

[NeedForExcel]

End if say the number of blank cells below the last copied cell is > 50

I doubt if that condition will ever be true..

Coz the code will always check the last entry, and copy the value, and hence will never be a gap of 50 blanks

This can be done using Basic Excel, do you not want that? Do you strictly want a VBA solution?

Try this -

Select A2:A30

F5 > Alt+S > K > Enter

= > up Arrow

Ctrl+Enter

[geoffffffff]

I guess a better way to say what I meant for that last bullet is: End if the copies of the same value repeat for more than 50 cells (50 is an arbitrary figure I have come up with which is suitable)

However, I was not aware of the non-VBA steps you have suggested and I think I'll just do that! - thanks!!

[zbor]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)