Filling blank fields

[TCollin6]

I have a list in excell that has a name, then below it a random number of blank fields then another name. Anyone know if I could build a macro to fill in those blanks with the first name?

Looks like this:

John Doe





Jane Doe

Need to look like:

John Doe
John Doe
John Doe
John Doe
John Doe
John Doe
Jane Doe


Any shortcut would be appreciated as this is a 10,000+ line spreadsheet!

Thanks!

 

[PA HS Teacher]

Does this do what you need?

=IF(ISBLANK(A2),B1,A2)

Copy and Paste Down

Book1
	A	B	C	D
1
2	AdamDoe	AdamDoe
3		AdamDoe
4		AdamDoe
5	BobDoe	BobDoe
6		BobDoe
7	CyndiDoe	CyndiDoe
8		CyndiDoe
9		CyndiDoe
10		CyndiDoe
11	DaveDoe	DaveDoe
12		DaveDoe
13		DaveDoe
Sheet1

 

[KenWright]

Select the column with your data in it, do edit / Go to / Special / Blanks, type = and hit the up arrow once and then use CTRL+ENTER to enter the data.

If you want you can now copy and paste special as values to get rid of the formulas.