MrExcel Publishing
Your One Stop for Excel Tips & Solutions

IF statements


Posted by jason on January 09, 2002 9:02 AM

I am composing a general journal that is composed of several smaller accounts. What I ideally would like to do is to be able to make an entry into the general journal, designate a particular job to it, and thereupon, it be dispersed to the correct account. Therefore, having record of it in the general journal account and then into a second account. (this is basically to eliminate a double entry system) To do this, I need a column to type in a job name so it will know where to send the information to. I'm having a terrible time figuring out IF statments for this task. (they didn't stress them too much in college) If someone can help I'd greatly appreciate it. Another problem I think I may run into is simply where to send the information once it goes to a job's worksheet, how do I fashion it to go into the next available line of text. I know this is alot, but I promise to buy someone dinner if they're ever in Myrtle Beach SC thanks


Posted by Dan on January 09, 2002 9:44 AM

I'm sorry, but this all seems a little vague. I'm not sure what you mean by "designate a particular job," etc. Can you maybe describe an example of what you want to happen? Something like "I want to type a number in cell A1 and if the number = x then...."

Posted by Jason on January 09, 2002 9:55 AM

My apologies for being vague Dan-Here's the situation, I work for a construction company that has several different jobsites going at one time. We have a large general journal account that all checks, regardless of jobsite, are drawn from. However, each jobsite is treated as an individual account, with amount invested or drawn from investors per jobsite. What I would like to do is to create a general journal account that basically resembles a check book. However, in the checkbook, have a column designated for a job name. Depending on the entry into that column, ie (123 elm street), the information in that line of the "check book" (a range of cells) gets copied either to another worksheet that is specific only for that job, or copied to a Pivot Table which I was just reading about. Basically, what we need to be able to do, is to eliminate a manual double entry system, and be able to pull up investment and cost figures in a seperate report from the large general journal account. Pivot tables would appear to work and do the job for me, but likewise, I only need information to go into a pivot table if it applies to that jobsite (I envision a table replacing a seperate job worksheet if a table will tally and do the same things that a worksheet will) Anyway, I appreciate your help, thoughts, and suggestions on this matter.

Posted by Dan on January 09, 2002 11:37 AM

So if you enter something on the general journal, do you want all of the information entered on the other worksheet, or do you just want summations on the other worksheet. For instance, lets say for 123 Elm St you have 5 entries of $100.00. In your other worksheet do you want details of the 5 entries listed or just the total of $500.00?

Posted by jason on January 10, 2002 8:17 AM

I want the details of the five entries Dan, sorry about the delay on getting back to this, I had something come up yesterday

Posted by Dan on January 11, 2002 6:31 AM

Instead of putting the information on a different sheet, how about using an autofilter to display the only the job that you are interested in on the main journal?

Let's say you have a column titled Job Name. You would highlight the column, and click on the Tools menu, then Filter, then check mark Auto Filter. A drop down menu will appear on your column and you can select the job that you want to display. Would that do what you want?