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.

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

"juliejg1" wrote:

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.

Select column A and F5SpecialBlanksOK

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)ValuesOKEsc


Gord Dibben MS Excel MVP

On Fri, 17 Aug 2007 14:53:51 -0700, juliejg1
wrote:

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.

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

"Gord Dibben" wrote:

Select column A and F5SpecialBlanksOK

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)ValuesOKEsc


Gord Dibben MS Excel MVP

On Fri, 17 Aug 2007 14:53:51 -0700, juliejg1
wrote:

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.

You're welcom.

Thanks for the feedback.



On Mon, 20 Aug 2007 05:56:02 -0700, juliejg1
wrote:

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

"Gord Dibben" wrote:

Select column A and F5SpecialBlanksOK

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)ValuesOKEsc


Gord Dibben MS Excel MVP

On Fri, 17 Aug 2007 14:53:51 -0700, juliejg1
wrote:

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.