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.
Bookmarks