Hi. I am working with Excel 2010.
I have data in worksheet 1 and want to perform calculations with that data BUT the answer must appear in a cell in worksheet 4.
For example, sum cells H5:H28 in worksheet 1, result to appear in cell B4 in worksheet 4.
Have consulted the Excel Bible 2007 but found nothing helpful. Would appreciate help!
Hennie
In worksheet 4, put this formula in B4 =SUM(Sheet1!H5:H28)
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Thanks Arlette. Your are a STAR!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks