|
|||||||
 |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
08-09-2011, 05:41 AM
|
#1 |
|
Moderator
Staff
Premium Member
Join Date: Nov 2008
Location: Detroit, MI
Posts: 3,805
|
EXCEL formula
I am having trouble trying to do something in excel and I can not remember how to do this. I am to busy to read up and was wondering if someone can help me or refresh my memory since I do not use the program any more. It's for the my church.
I am trying to link a cell into the other sheets. For example. Each member has an individual sheet for recording their tithes and offerings. There is also a service report sheet that records the tithes and offerings collected on the days of church service. The accountant enters the totals in cells on the service report but wants the number to jump into the individuals sheet at the same time or automatically. thanks in advance |
|
|
|
08-09-2011, 06:08 AM
|
#2 |
|
Ride 'em Cowboy
Join Date: Dec 1999
Location: Dallas, Tx
Posts: 9,109
|
Simple example: Sheet two has a total for a member.
On sheet one - where you want the total to appear you hit the + (plus) key -> then you drill down to the total on sheet two and hit the enter key... On sheet one you'll end up with a formula that looks like: =+Sheet2!A6
__________________
Stand Up 2 Cancer - SU2C |
|
|
|
|
08-09-2011, 07:01 AM
|
#3 |
|
Member (10 bit)
Join Date: Jan 2010
Location: N. Calif.
Posts: 529
|
Or if you just want the same number to appear, leave off the '+', as in =Sheet2!A6
__________________
Been using, building, repairing and programming computers for nearly 30 years now. |
|
|
|
|
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Linear Mode
