Auto fill cells
You could do this without the use of VBA
Select the column with the blanks.
F5SpecialBlanksOK
Type an = sign in active blank cell.
Point or arrow to cell above.
Hit CTRL + ENTER.
Gord Dibben MS Excel MVP
On Tue, 17 Mar 2009 12:19:04 -0700, Cheffred
wrote:
I am dumping a file from another program. In one of the columns, the account
#, only the first cell in each group is filled in. Is there a way to
automatically go through and fill the other cells in each group with the
account number? I could manualy copy and paste each group, but the report is
12,000 lines. I don't have that much time and my interns have left for the
day.
I appreciate the help
|