Select same cell on different sheets

[tsunami100]

Hi,

I want to make a chart that always refers to the same cell on different worksheets.
I tried it already but it doesn't seem to work

Thanks

I choose my username Tsunami because i hope it keeps everybody remembering this terrible disaster.

 

[GlennUK]

Hi Tsunami100,

Why don't you have a new sheet in the workbook, that collects the data from the required sheets?

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[tsunami100]

Hi Glenn,

Thanks for your reply.
Yes i thought about that but i was thinking that there may be another better solution than that.
Is it not possible to give up the data from the different sheets as a datarange ?


I choose my username Tsunami because i hope it keeps everybody remembering this terrible disaster.

 

[xlbo]

Not easily - no

Rgds, Geoff

A file that big? It might be very useful. But now it is gone

Please read FAQ222-2244 before you ask a question