Amanda

Posts: n/a

Copying result of formula into another worksheet???

I am having problems copying a formula result into another wksht if the
formula is not used...hard to explain...

D10=Sum(A1:A5)

I want to transfer D10 to wksht Data E12, however if there is no data in
A1:A5, I want E12 to remain blank.

It looks like it is reading the formula, so it places a "0" or a "-"....

Any ideas?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Trouble copying and pasting a formula	Julie P.	Excel Discussion (Misc queries)	6	March 4th 05 04:11 AM
Trouble copying and pasting a formula	Julie P.	Excel Worksheet Functions	4	March 3rd 05 03:16 AM
Conversion	SVC	Excel Worksheet Functions	9	February 28th 05 02:29 PM
Spellnumber	Norman Jones	Excel Worksheet Functions	6	December 13th 04 07:21 AM
Excel 2003 - Formula result shows as 0:00	Serena	Excel Worksheet Functions	4	November 11th 04 10:18 PM

All times are GMT +1. The time now is 06:16 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us