Hi again,

what if your data would be like below:

Column: A B C D E
Gas Groceries Ent Medical Misc
50.00 250.00
35.00


Sheet 2:

Column: A B C
Date Amount For?
8/10/07 55.00 [Misc]
8/11/07 25.00 [Ent]
8/12/07 35.00 [Gas]
8/15/07 80.00 [Gas]
9/12/07 100.00 [Gas]

so for example for Gas you want to pull those 3 row data regarding Gas
separately or you want sum of them or you want sum of them monthly?

Thanks,
--
Farhad Hodjat


"LeahT" wrote:

Hmmm...that's a tough one...let me see if I can show it as best as
possible...I tried to explain it but it is hard to explain without
showing...so I'll give it a try:

Sheet 1:

Column: A B C D E
Gas Groceries Ent Medical Misc
50.00 250.00
35.00


Sheet 2:

Column: A B C
Date Amount For?
8/10/07 55.00 [Misc]
8/11/07 25.00 [Ent]
8/12/07 35.00 [Gas]

Okay...so the information in Column C on Sheet 2 is from drop down
lists...what I want is for the individual columns on Sheet 1 to look in
Column C on Sheet 2 and see if it sees itself....if it does...I want it to
pull the value from Column B on Sheet 2 and place it in the next available
cell in its respective column on Sheet 1!?

Does that make it any clearer? Sorry...I am having trouble explaining it
well enough...I may not be able to get this to work just for lack of ability
to explain it! HA!!

Thanks in advance for any help!

"Farhad" wrote:

Hi.

if you put an example in your posting it would be more underestandable.

Thanks,
--
Farhad Hodjat


"LeahT" wrote:

I posted this somewhere else (can't find it now) and didn't get a response
and it might be due to the fact that I didn't explain it well...so I will try
again (my apologies if you have seen this once before somewhere else).

I have two worksheets (1 & 2)...I want worksheet 1, column A to go and look
at worksheet 2, column B to find a text value (ie: groceries)...if it finds
the word groceries in column B, I want it to grab the $$ amount from column A
and place it in the next available cell on worksheet 1, column A.

In other words, Worksheet 2 is a general journal...I am inputting daily
transactions into that worksheet...I would like for that information to
translate over to worksheet 1 which is the monthly spreadsheet that shows all
of the general ledger information seperated out by transaction. That
information eventually translates into my general ledger report (which I
already am able to do). Unfortunately, currently I am manually taking
information from worksheet 2 and placing it into its respective columns on
worksheet 1...I was hoping to take out that step and just be able to input
info into worksheet 2 and have it automatically translate over. I can get it
to work for one cell...but not all of them...and when I tried to create a
drop-down list on worksheet 2 that would be a list of the GL accounts...then
the value on the other worksheet disappeared completely...even though in the
function box it shows the correct value...it doesn't show up in the cell!

I am really frustrated...any thoughts would be helpful...and I will be happy
to try to explain better if this isn't making sense!