+ Reply to Thread
Results 1 to 7 of 7

Excel based automatic invoicing

  1. #1
    Registered User
    Join Date
    04-30-2016
    Location
    Riyadh, KSA
    MS-Off Ver
    2013
    Posts
    4

    Red face Excel based automatic invoicing

    Hi,

    I read many articles regarding automatic invoicing but i couldn't find something easy to meet my demand. I would be very thankful to anyone who can assist me.

    My invoice has 5 columns (Serial) (description) (unit) (unit price) and (total price)

    i just want the description column to auto fill (not any other column as price of stuff changes very often in my business) itself by acquiring data from another spreadsheet. To make it simple, while i am typing for example "bulb", during typing bulb all other bulb related options such as bulb 5w, bulb 10w etc. appear in drop down and i select the one i want.

    thanks in advance,

  2. #2
    Registered User
    Join Date
    03-17-2016
    Location
    India
    MS-Off Ver
    2010
    Posts
    83

    Re: Excel based automatic invoicing

    Hi

    It will be more clear if you attach your workbook with dummy data to get rightful solution.

    Regarding description column, You can use Data Validation - List to populate list of description in drop down arrow
    Thank You.....

  3. #3
    Registered User
    Join Date
    04-30-2016
    Location
    Riyadh, KSA
    MS-Off Ver
    2013
    Posts
    4

    Re: Excel based automatic invoicing

    Data validation does populate but does not perform a search... like while browsing internet one types "go" and suggestions like google.com come up and one selects without typing using navigation keys... i need this kind of arrangement.. hope u understood... thanks

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    Re: Excel based automatic invoicing

    Here is a link to a video that describes a way to get something that is close to what you seem to want. Basically it works by putting you list of items directly above the cell to which the data validation is applied.
    https://www.youtube.com/watch?v=_qLPPWUqAFI

    Let me know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  5. #5
    Registered User
    Join Date
    04-30-2016
    Location
    Riyadh, KSA
    MS-Off Ver
    2013
    Posts
    4

    Re: Excel based automatic invoicing

    Yep this is the thing i want... auto fill takeover but this list hiding wont work because i deal in hundreds of items... basically what i want is a complete database of my products on sheet 2 and on sheet 1 i have invoice... the auto fill data validation should acquire its data from sheet 2 which has a huge list of products... thanx

  6. #6
    Registered User
    Join Date
    04-30-2016
    Location
    Riyadh, KSA
    MS-Off Ver
    2013
    Posts
    4

    Cool Re: Excel based automatic invoicing


  7. #7
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    Re: Excel based automatic invoicing

    Take a look at the solution offered at this website: http://www.ozgrid.com/Excel/autocomplete-validation.htm
    The part of the solution under the heading List is Dynamic and/or Resides on Another Worksheet seems to be what you would want. I have never used the method so I can not vouch for its effectiveness.

+ 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. Invoicing based on product and order number
    By MOONDRIFT47 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-01-2014, 10:36 AM
  2. VBA/Excel automated invoicing
    By here4help in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-30-2014, 02:35 PM
  3. Monthly Invoicing Excel : Partially built-need further help.
    By Tyrion16 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-17-2013, 10:31 AM
  4. Excel Invoicing
    By pauldaddyadams in forum Excel General
    Replies: 13
    Last Post: 08-18-2013, 06:57 AM
  5. Replies: 0
    Last Post: 02-20-2013, 10:48 AM
  6. Automatic email from excel based on due date
    By AmishJPatel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-06-2012, 04:58 PM
  7. [SOLVED] Can I merge Excel spreadsheets with Quickbooks invoicing?
    By Ukcats_26 in forum Excel General
    Replies: 1
    Last Post: 01-11-2005, 11:06 AM

Tags for this Thread

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