Help with EXCEL Formula

Jacki Woodring · 09-07-2006, 08:18 PM

I need help. I want a formula that will do the following.

Example: Flunction=The selected cell will show the data in A11 if A12=0.

The speadsheet has several tabs. I want to link the dollar information that is noted beside each month. For example worksheet#2 is named Local Mission. The cells would look like this A1 has 06-Jan in it and A2 has $500.00 B1 has 06-Feb in it and B2 has $400.00, etc through Dec I want worksheet #1 to be a summary page. On the summary worksheet cell A1 would have Local Missions written in it. A2 would be the most recent entry from worksheet #2. Everytime I enter new information on the Local Mission tab by the current month, I want it reflected on the summary sheet without rewriting or relinking the information. Does this make since?

**Glaswegian** · 09-08-2006, 06:25 AM

Hi and welcome to TSF.

If I've understood correctly, go to your summary sheet. In the cell where you want the data to appear, press the equals sign (=). Now go back to your first sheet and click on the relevant cell - press Enter. You can repeat this or possibly copy down on your summary sheet.

It would be better if you could post a sample sheet showing exactly what you require. Would that be possible?

09-07-2006, 08:18 PM	#1 (permalink)
Jacki Woodring Registered User Join Date: Sep 2006 Posts: 1 OS: XP	Help with EXCEL Formula I need help. I want a formula that will do the following. Example: Flunction=The selected cell will show the data in A11 if A12=0. The speadsheet has several tabs. I want to link the dollar information that is noted beside each month. For example worksheet#2 is named Local Mission. The cells would look like this A1 has 06-Jan in it and A2 has $500.00 B1 has 06-Feb in it and B2 has $400.00, etc through Dec I want worksheet #1 to be a summary page. On the summary worksheet cell A1 would have Local Missions written in it. A2 would be the most recent entry from worksheet #2. Everytime I enter new information on the Local Mission tab by the current month, I want it reflected on the summary sheet without rewriting or relinking the information. Does this make since?

09-08-2006, 06:25 AM	#2 (permalink)
Glaswegian Moderator/ Rangemaster TSF Academy; Analyst, Security Team; Oor Wullie; TSF Surgeon and Resident Comic Join Date: Sep 2005 Location: Glasgow Posts: 25,566 OS: Win XP Pro SP3 / Win 7 Pro My System Blog Entries: 10	Hi and welcome to TSF. If I've understood correctly, go to your summary sheet. In the cell where you want the data to appear, press the equals sign (=). Now go back to your first sheet and click on the relevant cell - press Enter. You can repeat this or possibly copy down on your summary sheet. It would be better if you could post a sample sheet showing exactly what you require. Would that be possible? __________________ Iain - Defender of the Haggis and all things Scottish. I don't help by PM - post in the Forums. PC Safety & Security::PC running a bit slow?::Donate::Photographers Corner