I'm relatively new to coding, and my boss has asked me to setup a spreadsheet to summarize our sales. Basically, Sheet1 is a Master Sheet, and Sheets 2-9 are for each salesperson's deals. Everytime we enter in a deal on the respective saleman's sheet, he wants it to automatically update on the next available row of the Master Sheet (Sheet1). The first row data for each salesman's sheet is A1:R12. This is also the first available row on the Master Sheet. Any help would be very much appreciated.
Thanks!
Bookmarks