+ Reply to Thread
Results 1 to 2 of 2

Breakup phone bill

  1. #1
    Registered User
    Join Date
    06-25-2012
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    2

    Breakup phone bill

    Basically I recieve a group phone bill that contains a whole heap of data and I need to invoice each of the units individually. Creating the invoice is easy and I can do that, it's just the individual calls being populated in a different sheet on the basis of call type that I need help with.

    I would like the data to come up in these sheets from typing a unit number into a separate sheet, and then everything else will populate from this input sheet.

    I know I haven't explained the situation very well, so I have attached an example of what im talking about where I have simply copy and paste the data across to the appropriate sheet.

    Thanks a lot for your help.

    Cheers, Cameron.
    Example.xlsx
    Last edited by cameron21593; 06-26-2012 at 12:41 AM. Reason: Attachment link

  2. #2
    Forum Contributor
    Join Date
    01-24-2011
    Location
    Sheppey
    MS-Off Ver
    Excel 2010
    Posts
    239

    Re: Breakup phone bill

    How about using a Pivot Table in the attached example?
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    06-25-2012
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Breakup phone bill

    Thanks a lot for your response. With a bit of adjustment it worked really well

    Cheers.

+ 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