+ Reply to Thread
Results 1 to 6 of 6

Inputed Transactions Get Assigned to Category

  1. #1
    Registered User
    Join Date
    01-14-2013
    Location
    Vancouver, WA
    MS-Off Ver
    Microsoft Office Professional Plus 2010
    Posts
    24

    Inputed Transactions Get Assigned to Category

    I am trying to do the following and really need some help with the formula to create.

    I am trying to:
    On the Transactions sheet enter the date 02/10/13 and select AP Cash Withdrawals.
    Then, on the Checking sheet I want the $200 to automatically show up in AP Cash Withdrawals cell.

    I attached the spreadsheet. Thank you so much! -Jessie

  2. #2
    Valued Forum Contributor
    Join Date
    04-03-2012
    Location
    East Sussex, UK
    MS-Off Ver
    Excel 2003:2010
    Posts
    893

    Re: Inputed Transactions Get Assigned to Category

    Jessie there's no workbook attached.

    S.
    If I've been of help, please hit the star

  3. #3
    Registered User
    Join Date
    01-14-2013
    Location
    Vancouver, WA
    MS-Off Ver
    Microsoft Office Professional Plus 2010
    Posts
    24

    Re: Inputed Transactions Get Assigned to Category

    I uploaded the file this time, I am so sorry. -Jessie

  4. #4
    Valued Forum Contributor
    Join Date
    04-03-2012
    Location
    East Sussex, UK
    MS-Off Ver
    Excel 2003:2010
    Posts
    893

    Re: Inputed Transactions Get Assigned to Category

    Have a look at the attached. I've put formulas in all the cells that are now yellow that hopefully do what you need.

    Let me know if not...



    Financial Accounting-Columbia CU-Practice b.xlsx

  5. #5
    Registered User
    Join Date
    01-14-2013
    Location
    Vancouver, WA
    MS-Off Ver
    Microsoft Office Professional Plus 2010
    Posts
    24

    Re: Inputed Transactions Get Assigned to Category

    Thank you so very much. I am headed to my office shortly and am going to try it out. Thank you. -Jessie

  6. #6
    Valued Forum Contributor
    Join Date
    04-03-2012
    Location
    East Sussex, UK
    MS-Off Ver
    Excel 2003:2010
    Posts
    893

    Re: Inputed Transactions Get Assigned to Category

    Not a problem. Happy to help.

    Feel free to come back here if there are any problems with it and I'll see what I can do to help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1