?B?QWhzYW4gWW91c2Fm?= wrote

Thanks for reply
But I want to make changes in multiples Excel Files Containg most of
similar Fields. I have 100 Excel Files having 7 sheets. I want to
update two or more field and want to make that change apply to 100
files. Is there any concept to making a master document in which you
make some changes and those changes apply to other Files.
Or some thing else because now I have to open every file and updating
that information
"Infinity" wrote:


Select the First worksheet.

Go to the last worksheet but dont click it. (you can do this by using
the "|" at the bottom left of Excel.

Now hold the "SHIFT" key and click on the last worksheet.

walla..... all worksheet selected but becareful when you change a
cell cause the changes will be applicable to all worksheets.


--
Infinity
----------------------------------------------------------------------
-- Infinity's Profile:
http://www.excelforum.com/member.php...o&userid=32725 View
this thread: http://www.excelforum.com/showthread...hreadid=527469




Yes there is a concept to do that. It involves pasting links from your
master document into those other files. Select desired range from master,
open target file, select target range, Edit-PasteSpecial-Paste Link

--
David