copy whats in a cell

[jimmisavage]

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!!

[Bryan Hessey]

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!!

Hi,

just use =Sheet1!A1
etc

---

[VBA Noob]

Hi,

Your post is a bit confusing. Do you want to return the cell value from sheet 1 or count and sum the info ??

If you want to display the data go to sheet 2 and select B1 then enter = and select sheet 1 and cell B1 which should return

=Sheet1!B1

Drag across as required

VBA Noob

[jimmisavage]

thats it guys. you got it!

i new it would be easy!! thanks alot.

i'll be back later with a few more questions i'm sure.

cheers for now.