About Us

Yep!

Biff

"Jerrod Mason" wrote in message
...
Hey Biff,

Thanks for taking the time to respond. I didn't explain my system
thoroughly enough. I have two separate workbooks, one with monthly
"Transaction List" worksheets, and one with monthly "Monthly Summary"
worksheets. That way the transactions link only to their respective
monthly
summary and I can montor individual monthly summaries over an extended
period
of time. Did that explain your question?

Jerrod

"Biff" wrote:

Hi!

Here's something that you may not have thought about. You said you have 2
sheets, a Summary and one for transactions. If you're paying electric
bills
wisdom tells me you're getting a bill and making a payment every month.
So,
there will be more than 1 entry in the transaction list for electric
bills.
Which one do you want?

Biff

"Anne Troy" wrote in message
...
Hi, Jerrod. You'll need INDEX and MATCH. If you move your Code column
to
be
column A instead, then you can use VLOOKUP, which is (IMHO) much
easier.
http://www.officearticles.com/excel/...soft_excel.htm

And here's a "tutorial" on vlookup:
http://www.officearticles.com/tutori...soft_excel.htm
*******************
~Anne Troy

www.OfficeArticles.com

"Jerrod Mason" <Jerrod wrote in
message
...
I'm working on a budget system using Excel 2003. I have one page set
up
as a
monthly summary, and another set up as a transaction list. I want to
view
the date I paid a particular bill on the Monthly Summary worksheet,
taking
that data from the Transaction List. I'm using a 2 digit numerical
system
to
classify different bill categories. Example:

Date Code Desc. Price
14-Jun-04 10 Electricity 300.00

I tried an IF function to bring the date across where the first part
was
"B:B=10", the second part was "A:A" and the third part was left blank.
I
couldn't get it to work....am I approaching this incorrectly? Here's
what
I'm looking for: when I enter a payment for a specific bill in my
Transaction List worksheet, is there a way to bring the date of that
transaction across to a column in my Monthly Summary worksheet to
indicate
(1) that I paid the bill and (2) when I sent the check? Thanks in
advance.
As I'm sure you can tell, I've next to no experience with spreadsheets
in
general and Excel in particular, and this has been quite and
adventure.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I display the 'Date Modified' in an Excel worksheet header	DC Solah	Excel Discussion (Misc queries)	3	July 10th 06 06:03 PM
Copying Numerical Totals of separate worksheets to a single Summary Worksheet	buster1831	Excel Discussion (Misc queries)	2	February 16th 05 11:28 PM
Copying Totals of separate worksheets to a single Summary Worksheet	buster1831	Excel Discussion (Misc queries)	0	February 16th 05 10:25 PM
Date updates from worksheet to chart & changes date to a date series! Help!!	Jayjg	Charts and Charting in Excel	2	January 22nd 05 03:00 PM
How do I show the last saved date in an Excel worksheet?	mgriffie	Excel Worksheet Functions	1	January 5th 05 08:46 AM

Menu

About Us