copying data down columns

J

juliejg1

I have a spreadsheet that is a data dump from a main frame. I would like to
put everything into an Access database but have to clean up the data. I have
a Name is cell A1 and then another name in cell A20 and another in cell A26.
I would like to be able to quickly fill in cells A2-A19 with the name in cell
A1 while at the same time filling cells A21-A25 with the cell contents of
A20. I know I saw a solution on a website once but cannot recall what the
site was or what the solution is.
 
G

Gareth_80

How about trying a simple =($A$1) in cell A2 and copy down to A19 and
=($A$20) in cell A21:A25. Maybe pop it on a macro and link it to a button to
run the two formulas?
Not sure if that'll fit your needs.

Kind regards

Gareth
 
G

Gord Dibben

Select column A and F5>Special>Blanks>OK

In the active blank cell type an = sign then point or arrow up to the cell
above then hit CTRL + ENTER.

Copy column A and Paste Special(in place)>Values>OK>Esc


Gord Dibben MS Excel MVP
 
J

juliejg1

Exactly what I was looking for.....Thank You!!!

Gord Dibben said:
Select column A and F5>Special>Blanks>OK

In the active blank cell type an = sign then point or arrow up to the cell
above then hit CTRL + ENTER.

Copy column A and Paste Special(in place)>Values>OK>Esc


Gord Dibben MS Excel MVP
Click to expand...
 
Top