#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default formula output

I am triing to add cells (a1:c1) on sheet1 and have the formula on sheet2 but
have it output it to e1 on sheet1.
I am tiing to have the formulas on a different pageso that the person using
the sheet cant see them and or mess with them
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10,593
Default formula output

Not possible. You would need a formula in E1 which points to sheet2.

Other than that, it is VBA.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"durebel1" wrote in message
...
I am triing to add cells (a1:c1) on sheet1 and have the formula on sheet2
but
have it output it to e1 on sheet1.
I am tiing to have the formulas on a different pageso that the person
using
the sheet cant see them and or mess with them



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
how do I output result of formula to another cell? Francois Excel Discussion (Misc queries) 3 November 24th 06 03:02 PM
How do I use a referenced cell's formula instead of formula output? Farrelltw Excel Worksheet Functions 0 February 10th 06 05:00 PM
add text to end of formula output mgdarkman Excel Discussion (Misc queries) 2 December 9th 05 03:51 AM
formula for custom output TUNGANA KURMA RAJU Excel Discussion (Misc queries) 0 November 15th 05 04:36 AM
Copying data from formula output robin m Excel Discussion (Misc queries) 2 August 30th 05 06:04 PM


All times are GMT +1. The time now is 10:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"