Autofill a column

[paulland]

Hi,
I'm new to VB code and can't figure out where to start with this macro, which should be simple:
Data in column A consists of a number, followed by a series of blanks in row A (there is data in columns B:G that corresponds to the entry in column A), then a new entry in column A. Like this:

A	B
value	data
	data
	data
	data
value 2	data
	data
	data
value 3	data
value 4	data
	data
	data
	data
...
value	data

<tbody>
</tbody>

The number of rows between values in column A is dynamic.
I just want to copy down the column A value until the data in column A changes, then repeat with the new value, like this.

A	B
value	data
value	data
value	data
value	data
value 2	data
value 2	data
value 2	data
value 3	data
value 4	data
value 4	data
value 4	data
value 4	data
...
value n	data

<tbody>
</tbody>

This should be easy but I don't know where to start. Any suggestions? I can use Autofill to get to the bottom of the column, but am clearly not smart enough to figure out how to make it dynamic.

 

[Andrew Poulsom]

Welcome to MrExcel.

Select column A and choose Edit|Go To|Special|Blanks|OK. Go to the Formula Bar, type =, point to the cell above the active cell and press Ctrl+Enter. The macro recorder should give you some code.

 

[Jonmo1]

You can do this without VBA.
But if you insist on VBA method, then use the Macro Recorder to record yourself doing the following Steps.

Select Column A
Press CTRL + G
Click Special
Select "Blanks"
Click OK
Press =
Press UP Arrow
Press CTRL + ENTER
Highlight Column A Again
Right click - copy
Right click - Paste Special
Select Values
Click OK


Hope that helps.

 

[paulland]

BrillianT! I knew there was an easier way. Thanks.

You can do this without VBA.
But if you insist on VBA method, then use the Macro Recorder to record yourself doing the following Steps.

Select Column A
Press CTRL + G
Click Special
Select "Blanks"
Click OK
Press =
Press UP Arrow
Press CTRL + ENTER
Highlight Column A Again
Right click - copy
Right click - Paste Special
Select Values
Click OK


Hope that helps.