Results 1 to 4 of 4

How do I pull information from a list of cars sold to a different page for each salesman

Threaded View

  1. #1
    Registered User
    Join Date
    04-28-2021
    Location
    Aldie, Virginia
    MS-Off Ver
    Newest Version of Excel (Office 365)
    Posts
    11

    How do I pull information from a list of cars sold to a different page for each salesman

    I am making a pay plan spreadsheet for a car dealership. Each salesperson has their own page, and there is a master page that lists all cars sold. I need to make the sheet so that when someone enters a car sale and who sold it on the main page, the information is copied into the page of the salesperson responsible for the sale. I have attached a rudimentary copy of the sheet itself. In the images I am trying to get the information in the blue box copied to the green box, based on the recorded name of the salesperson (I know there are a bunch of issues like not having enough columns, right now I am just trying to figure out how to move the information automatically). Thanks in advance for the help.
    Attached Images Attached Images
    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. Pull X information from another page
    By ChrisMS28 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-29-2021, 12:09 PM
  2. [SOLVED] List cars on the road
    By makinmomb in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-16-2018, 07:10 AM
  3. Get existing cars from a list
    By Immortal2014 in forum Excel General
    Replies: 6
    Last Post: 04-29-2016, 04:27 PM
  4. [SOLVED] Formula to pull specific information from a list in the correct order
    By Sleepyshy in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-05-2012, 11:36 AM
  5. Pull information from web page.
    By azland00123 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-05-2012, 09:13 AM
  6. a forumula to look up a worksheet and pull information to a summary page
    By cubeworker in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-04-2010, 08:43 AM
  7. Pull information from a Web page to Excel file
    By Union70 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-07-2005, 06:05 PM

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