hi there guys and gals,

i want to know if there is a formula which will copy the contents of a cell, even if that changes.

i can do it for counta and sum, but i want to copy the name which is entred into that cell. does that make sense?

ok. on sheet1 i have

a b c d
1 jim bla £12 £9
2 jon bla £9 £7
3 jan bla £8 £7

and i want to copy these values so on sheet2 i have

a b c d
1 =counta(b1) =sum(c1) =sum(d1)
2 =counta(b2) =sum(c2) =sum(d2)
3 =counta(b3) =sum(c3) =sum(d3)

with these formulas they will change to what is in the cell on sheet1, but how do i get the names on sheet2 (so they change on sheet2 if i change sheet1)

Please tell me this can be done. it will make my life so much easier!!