You have other replies at your other thread.

But a couple of questions...

Are both workbooks open in the same instance of excel (do you see both names
under the Window option on the worksheet menu bar?)

If you don't, then close one, and open it using File|open in that first
instance.

Are you copying from a filtered list?



HuaMin wrote:

Hi,
It's OK to copy the formula from one cell to another one within the
same sheet. How about that to copy the formula from one Excel file to
another one? It seems only the value of that cell will be copied to
that file but not the formula inside it. I even have tried to copy the
corr. formula within that again but just the copied formula will not
work successfully in there.

Thks & Rgds,
HuaMin

--
HuaMin
------------------------------------------------------------------------
HuaMin's Profile: http://www.excelforum.com/member.php...o&userid=29423
View this thread: http://www.excelforum.com/showthread...hreadid=491346

--

Dave Peterson