Results 1 to 19 of 19

Auto Populate Lists in Excel with Service, Gross, Net and Profit

Threaded View

  1. #12
    Registered User
    Join Date
    10-16-2015
    Location
    Wantagh, NY, USA
    MS-Off Ver
    2010
    Posts
    11

    Re: Auto Populate Lists in Excel with Service, Gross, Net and Profit

    Hi I hope you had a wonderful weekend, so using the 2016 excel sample attached I was wondering if I could get help with what was previously discussed in the forums threads before. So I wanted on the billing form when the service is chosen it populates the gross, net and profit the only variable that should be changeable is the hours. Want the same services and gross on the invoice. just a question, could you explain a little bit about how you are doing this (functions and/or formulas) so I can look up lessons on how to learn more about this and also for the bill form can I also have the ability to do a drop down with names and how would I add or remove people from that list without ruining the function? Thanks again so much, you are such a lifesaver!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Gross Profit in Pivot Table
    By andresndor in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-27-2013, 01:18 PM
  2. Gross Profit- Power Pivot
    By jboyd in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-09-2013, 01:53 PM
  3. Have Gross/Net weights auto populate
    By rhale27 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-06-2013, 01:17 PM
  4. formula for gross profit inc VAT
    By Martin@Stag in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-08-2013, 06:09 PM
  5. Gross Profit Percentage
    By beaudroix in forum Excel General
    Replies: 2
    Last Post: 03-16-2012, 01:18 PM
  6. [SOLVED] how to work out gross profit on items
    By klansman7 in forum Excel General
    Replies: 1
    Last Post: 07-24-2006, 02:55 PM
  7. [SOLVED] I need an Excel template that will calculate Retail Gross Profit
    By Anthony in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-25-2006, 10:11 AM
  8. [SOLVED] gross profit margin formula
    By julmcgrath in forum Excel General
    Replies: 2
    Last Post: 03-11-2005, 11: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