Results 1 to 6 of 6

Separate Screens for each specialist, with add value buttons

Threaded View

  1. #1
    Registered User
    Join Date
    02-19-2015
    Location
    Nykøbing F., Denmark
    MS-Off Ver
    2013
    Posts
    2

    Question Separate Screens for each specialist, with add value buttons

    Hi Guys

    I'm very new to all this with functions in excel but i'm hoping there is a wizard out there who can help me.

    First off, I work in a company that sells products over the phone and right now we have an excel file where we push a button and a counter goes +1 up...
    But we also have different prices on the products, and this file is old and the guy who made it is long gone...

    But i'll try to explain what i would like and hopefully someone can help.

    We have 50 names of the salesmen, 100 clients with seperate prices.
    We have a counter for every sale and also a chart with the earnings of each salesman.

    so the ideal would be that you go to this computer and press one button with your name on it and after that get a different screen that shows your clients and then you push your clients button.
    The spreadsheet should now count +1 sale in one box and count that price, from that client, on the diagram for that salesperson...

    Am i making any sense???

    Can any of you perhaps create this for me?
    Or tell me how to create buttons without the use of VBA???

    With kind regards, someone whos in over their head...

    - Edit:
    Thank you for telling me how i should do things, greatly appreciate it.
    I can give the screens we have now, don't think you can use it to much.
    In the Team Screen 15a.xls there is a new pane called THIS IS HOW I WOULD LIKE IT - I hope that it makes any sense,
    like i said i have no clue about what the old employee have done...

    - Thanks.
    Grundtal.xlsTeam Screen 15a.zip
    Last edited by m.danielsen; 02-20-2015 at 03:46 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. League Table Based on Head to Head results
    By darkblueblood in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-16-2023, 07:10 AM
  2. How to account for head to head matchup in Excel with other tie breakers
    By Biogeek1 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-26-2013, 05:18 PM
  3. Head to Head (Tiebreakers) in Champions League
    By jovisb1993 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-26-2013, 06:50 PM
  4. Calculate average of last two outcomes of last two head-to-head clashes
    By wishkey in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-07-2013, 08:17 AM
  5. Ranking a league table by head to head results
    By pajc72 in forum Excel General
    Replies: 1
    Last Post: 09-02-2011, 07:02 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