+ Reply to Thread
Results 1 to 10 of 10

Arranging a detailed invoice listing in a database format

  1. #1
    Forum Contributor
    Join Date
    01-05-2013
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2010
    Posts
    129

    Arranging a detailed invoice listing in a database format

    Dear All

    Need help to arrange a detailed invoice listing in a database format - please see desired results highlighted in yellow.

    Clinical Billing.png

    Appreciate any help and thank you in advance.

    Joseph
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    13,751

    Re: Arranging a detailed invoice listing in a database format

    Please Login or Register  to view this content.
    Click RUN to execute macro
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    01-05-2013
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2010
    Posts
    129

    Re: Arranging a detailed invoice listing in a database format

    Thank you John! Works like magic!!!

    One more thing, if the results should start at I5 in Sheet2 instead of cell I5 in Sheet1, how do I modify the macro?

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    13,751

    Re: Arranging a detailed invoice listing in a database format

    Amended code:

    Please Login or Register  to view this content.
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    01-05-2013
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2010
    Posts
    129

    Re: Arranging a detailed invoice listing in a database format

    Superb! Thanks John! Here is some Rep for you!

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 2016 365 Subscription (Win 10 - Home)
    Posts
    11,955

    Re: Arranging a detailed invoice listing in a database format

    Don't forget to mark the thread as solved.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on their reputation star bottom left.

  7. #7
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Seattle, WA, USA
    MS-Off Ver
    MS Office 365 Excel 2016
    Posts
    13,016

    Re: Arranging a detailed invoice listing in a database format

    Hi Joseph,

    If you had the Power Query tool (called Get & Transform in 2016) you could do this problem using these steps. NO VBA needed.
    Please Login or Register  to view this content.
    See it in the attached (if you have Power Query)

    PQ Invoice to Clinical Billing Table.xlsx

    Note - I didn't need to type any of the code lines above. They were build for me by using the simple mouse click and typing using PQ.
    One test is worth a thousand opinions.
    Click the * below to say thanks.

  8. #8
    Forum Contributor
    Join Date
    01-05-2013
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2010
    Posts
    129

    Re: Arranging a detailed invoice listing in a database format

    Thank you MarvinP... it would be really nice to have the Power Query Tool... but I am using Excel 2010.

  9. #9
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Seattle, WA, USA
    MS-Off Ver
    MS Office 365 Excel 2016
    Posts
    13,016

    Re: Arranging a detailed invoice listing in a database format

    Power Query is an Add-In for Excel 2010, but it may be for only USA versions. I don't know if it is available for all languages now that it is built into 2016.

    Find the link below and see if you can install it.

    https://www.microsoft.com/en-us/down...2-078ece46bccf

  10. #10
    Forum Contributor
    Join Date
    01-05-2013
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2010
    Posts
    129

    Re: Arranging a detailed invoice listing in a database format

    Thanks again, MarvinP!

    Unfortunately, it needs a minimum Microsoft Office 2010 Professional Plus with Software Assurance.

    Mine is Microsoft Office Home & Business version.

+ 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