[FONT="]We get a lot of quotes from vendors in our company from all over the country. We want to track the quotes we are getting so we can start getting a better picture as to pricing trends.[/FONT]
[FONT="]Every rep has an excel file called QT (Name). Sheet 1 is where they are inputting the quotes they are getting. There are other sheets in the workbook but I'm only interested in the data in Sheet1. I have a QT Master which is the sheet I want to have all the data sent to. All of the Excel files are setup exactly the same. A-H are used with the 1st row being the categories. I want the data to continuously update the master workbook as the reps are receiving more quotes. I don't want the data to overwrite but rather to just keep entering
I am sorry if the question is confusing. I am a complete noob to this.
[/FONT]
[FONT="]I have purchased 3 kindle books. Watched dozens of youtube videos. I just can't seem to get it. Please help me[/FONT]
[FONT="]Every rep has an excel file called QT (Name). Sheet 1 is where they are inputting the quotes they are getting. There are other sheets in the workbook but I'm only interested in the data in Sheet1. I have a QT Master which is the sheet I want to have all the data sent to. All of the Excel files are setup exactly the same. A-H are used with the 1st row being the categories. I want the data to continuously update the master workbook as the reps are receiving more quotes. I don't want the data to overwrite but rather to just keep entering
I am sorry if the question is confusing. I am a complete noob to this.
[/FONT]
[FONT="]I have purchased 3 kindle books. Watched dozens of youtube videos. I just can't seem to get it. Please help me[/FONT]