D Dave Aug 11, 2009 #1 How do you copy a formula from one cell in row "a" to row "c", but only increase the row reference to "b" automatically?
How do you copy a formula from one cell in row "a" to row "c", but only increase the row reference to "b" automatically?
B Bernie Deitrick Aug 11, 2009 #2 Dave, Copy it to row 'b' then drag the copy from 'b' to 'c' HTH, Bernie MS Excel MVP
G Gord Dibben Aug 11, 2009 #3 Rows are numbers, columns are letters. Hence..............no such thing as "row a" and "row b" Do you mean column a and b and c or row 1 and 2 and 3 Give an example of what you have in A1 and what you want in A3 Or A1 and C1 if that's the direction you're going. Gord Dibben MS Excel MVP
Rows are numbers, columns are letters. Hence..............no such thing as "row a" and "row b" Do you mean column a and b and c or row 1 and 2 and 3 Give an example of what you have in A1 and what you want in A3 Or A1 and C1 if that's the direction you're going. Gord Dibben MS Excel MVP
