I have created an Form and Input sheet to be able to input Pricing informtion for 1st and 2nd Mortgages. However, I have recently come accross that there are about 13 states that have different pricing for 1st and 2nd Mortgages because of state guidelines. I takes me about 15 minutes to input the information from an the Pricing sheet into my Form. They have sent me an excel file with about 28 different Tabs for the different Pricing for each state and 1st/2nd Mortgages.
My idea on how to handle this instead of manually inputting all of the Pricing sheets and taking at least 3-4 hours of my time inputting each month, is creating a Main Excel file that has all of the Pricing and in the Format I want it. Then taking that excel file and linking it to Access and running a update query for the new months Pricing. And each month I would just need to copy and paste the pricing to the First sheet and the links would carry over the new pricing to the Main Excel sheet and then I would run my update query every month.
I still think there would be a better way of doing this. Any ideas?
My idea on how to handle this instead of manually inputting all of the Pricing sheets and taking at least 3-4 hours of my time inputting each month, is creating a Main Excel file that has all of the Pricing and in the Format I want it. Then taking that excel file and linking it to Access and running a update query for the new months Pricing. And each month I would just need to copy and paste the pricing to the First sheet and the links would carry over the new pricing to the Main Excel sheet and then I would run my update query every month.
I still think there would be a better way of doing this. Any ideas?