Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I do this...and if so...HOW!?
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! |