+ Reply to Thread
Results 1 to 10 of 10

Arranging a detailed invoice listing in a database format

  1. #1
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    2,952

    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
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    27,999

    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 Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    2,952

    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
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    27,999

    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 Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    2,952

    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
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,333

    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!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  7. #7
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    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 * Add Reputation below to say thanks.

  8. #8
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    2,952

    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
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    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 Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    2,952

    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)

Similar Threads

  1. access database convert to detailed list
    By SSJAMES18 in forum Access Tables & Databases
    Replies: 1
    Last Post: 02-22-2016, 08:04 PM
  2. Print Invoice by pulling info from database by selecting Invoice Number
    By Swapnil Panchal in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-12-2014, 11:21 AM
  3. [SOLVED] Searching a database and listing inventory on another sheet
    By oneillgirl808 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-05-2013, 04:11 PM
  4. Invoice and Database, please help!
    By kmp0511 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-23-2012, 07:50 PM
  5. Database Table Listing (ODBC)
    By WNErika in forum Excel General
    Replies: 2
    Last Post: 08-30-2012, 01:05 PM
  6. Listing a set of files from a database
    By mcooper1975 in forum Excel General
    Replies: 9
    Last Post: 11-11-2008, 05:35 AM
  7. Need to convert a chart list to a database listing.
    By sampson20 in forum Excel General
    Replies: 2
    Last Post: 07-25-2007, 08:48 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