Copy value in sheet 1

[fatalcore]

I have excel files with approx 80-220 sheets each.

I have used a "count" formula at the L200 on every sheets.

I want to display the count value at the first sheet against all the sheets.Like if sheet 1 have value 10 in cell l200 then the sheet one column C2 will show 10 , If sheet 2 /cell l200 has 15 value then sheet 1 cell C3 will show 15 ....and it will continue automatically.


Please help Its urgent.
Thanks in advance,
Fatalcore.

[Domski]

Something like this:

Please Login or Register  to view this content.

Dom

[fatalcore]

Thanks Domski . That was like a charm. can you kindly modify the code a little and add the line specifically in Cell I200 .

At presently I am inserting the code countif in every sheet at cell I200, and its taking too much time.

It will also be a great help it it automatically update the summary tab if there has been any change in the other sheets.

=COUNTIF(I:I,"RC*")

Thanks in advance,

[Domski]

Like this?

Please Login or Register  to view this content.

Dom

[fatalcore]

Hi Dom thanks for all your help.
But I want something different I am attaching a sheet for your reference.

But I am unable to upload the file over here.
I am available in gtalk and gmail.
Can you please send me your email address Then I can send you the file and you can take a look at it.
My ID is : [email protected]

It will be a great help if you please help me.
Thanks in advance.

[Domski]

Afraid I'd rather not give my email address out.

If you can try and describe why the code provided didn't do what you want I'll try and revise it.

Alternatively are you able to use Box.net to upload a file to?

Dom

[fatalcore]

Sure sure ...I am signing up in box.net
No issue at all.

[fatalcore]

http://www.box.net/signup/collablink.../7fdc13634262d

This link contains the file.

Now, What I am trying to do is that ,
I have already created the index page with links to all the pages and vice versa.This Index sheet is automatically updated when I add a sheet or delete a sheet,

Now i have added a second column in sheet 1 and named it No. of Re Cal.
Now in different sheets i have different RC 1 Rc 2 .......
I want column C to display no the number of RC present on that sheet and RC 1 Rc 2 on the right hand side of the cell automatically is something added or deleted.

Thats all, It will be great if these RC1 could also will be automatically linked to RC1 of that corresponding sheets.

Thanks and regards,

[Domski]

Quite a bit more involved than your original question. I haven't got time at the moment but will look later if I get a chance.

Dom

[fatalcore]

It will be a great help if you take a look at it.
Thanks in advance,
Will wait eagerly for your response.