You are mixing columns and rows I believe.
Column A would be A1, A2, A3 etc.
Row 1 would be A1, B1, C1 etc.
Select the column or row.
Hit F5SpecialBlanks.
With these selected, enter an = sign in active cell then point to cell above
or to left and hit CRTL + ENTER.
Copy the column or row and in place EditPaste SpecialValuesOKEsc.
Gord Dibben Excel MVP
On Mon, 15 Aug 2005 15:27:01 -0700, GSingh
wrote:
How can I copy values from one cell in a column down to the next cell IF the
2nd cell is blank, For example:
A1 = 20
B1 =
I want the value of A1 to be copied to B1 if B1 is blank/contains a value of
Null, I have about 11,000 records like this, whe If the next cell in the
column is blank, then I need to copy the previous cells data into that cell.
|