Thanks for the reply.
Glad I could help.
$A$1
The first $ (before the A) holds the colums in A.
The second $ (before the 1) holds the row in 1.
$A$1 and copy to the right gives the result $A$1 and $A$1 (it won't change the column and won't change the rows)
A$1 and copy to the right gives the result B$1 and C$1
A$1 and copy below gives the result A$1 and A$1 (it won't change the row)
a1 and copy below gives the result a2 and a3 (it will change the row)
Hope I explainde well enough.
Bookmarks