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.