Cam i place formulas on 1 sheet and have the outout of the forumal appear on another sheet?
eg sum cells a1:a10 on sheet 1 and have the forumula on sheet 2 but result appear on sheet 1
Cam i place formulas on 1 sheet and have the outout of the forumal appear on another sheet?
eg sum cells a1:a10 on sheet 1 and have the forumula on sheet 2 but result appear on sheet 1
No
Formulas can only display result in the cell they are entered into.
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assisted or failed to assist you I welcome your Feedback.
In sheet 2 try
=SUM(Sheet1!A1:A10)
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
Ok I got it like above post . I have the forumla result in sheet 2 and in sheet 1 I display the cell from sheet 2 eg in sheet 1 .....sheet2!a10 etc
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks