Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
An issue regarding the formula
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
An issue regarding the formula
Can anyone help on this? 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
An issue regarding the formula
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
self-updating formula | Excel Discussion (Misc queries) | |||
Editing an existing formula | Excel Worksheet Functions | |||
imported impromtu report date issue - fix by format or formula | Excel Discussion (Misc queries) | |||
formula SUMIF or whichever one will work for my issue | Excel Worksheet Functions | |||
Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) |