+ Reply to Thread
Results 1 to 4 of 4

Help with with a table

  1. #1
    Registered User
    Join Date
    10-11-2013
    Location
    Victoria, Australia
    MS-Off Ver
    Excel 2010
    Posts
    48

    Help with with a table

    Hi looking for some help to create a table to input work receipts. See attached example. My issue is that when it comes to inputting a receipt that has multiple items on it I don't really want to put them down as individual items on individual rows with the date and the store written out 20 times for the one receipt, looking like they are individual purchases. I want items that are on the one receipt grouped together, so when I want to recall a receipt I want to be able to recall all the purchases on that receipt. EG: rows 6 to 9 on my sample table.
    Last year I went through all my receipts, sorted them in date order then gave them a code number. This was very time consuming . I want to just pick up a receipt, input it into my table, then put them in date order when I'm finished.
    I'm not really good at using the full benefits of excel. Any help or redirection to some help would be appreciated
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    10-11-2013
    Location
    Victoria, Australia
    MS-Off Ver
    Excel 2010
    Posts
    48

    Re: Help with with a table

    Opps Update. EG rows 6 to 8 not 6 to 9

  3. #3
    Valued Forum Contributor Sadath31's Avatar
    Join Date
    03-02-2011
    Location
    Dammam, Saudi Arabia
    MS-Off Ver
    Office 365
    Posts
    452

    Re: Help with with a table

    Hi

    try using Subtotal (shown in the attachment)
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    10-11-2013
    Location
    Victoria, Australia
    MS-Off Ver
    Excel 2010
    Posts
    48

    Re: Help with with a table

    Thanks Sadath,
    That'll work just fine. Thanks for the guide in the attachment too. Much appreciated.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Summary table updated from source table. Source table held in a different workbook
    By dma1976 in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 11-22-2013, 11:36 AM
  2. Replies: 0
    Last Post: 07-02-2013, 11:30 AM
  3. Replies: 0
    Last Post: 12-05-2012, 03:48 PM
  4. [SOLVED] Need a formula to sort a table into table (for a Table Plan) and name in column 2
    By jbpianoman in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-07-2012, 09:21 AM
  5. [SOLVED] PIVOT TABLE - Summary Table into a Databasae Table.
    By sansk_23 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-09-2005, 03:06 AM

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