I have a spreadsheet report I have been maintaining and I think there is probably a better way to do it than how I have been doing it.
Here is a very quick explanation of what I need done and what I have been doing:
I am working with textbooks and with creating a sourcing and orders report. I have a bunch of different data sets that I bring into different tabs (prices, quotas, orders, on hand inventory, etc.). I create one tab where I bring all of that data over using vlookups so that I can start to create the report. It is tedious but I have gotten fast at it.
About every week, I need to update the report with new information (price changes, orders, newly requested books by professors). For now, I have just been creating a new report every time and recreating all of the formulas but I am thinking I should be able to just add the new information to the different data tables I have in the tabs and have that somehow update the reports tab with all the new information.
How can I do this and what would be the best thing to use to do it?
I have attached a sample spreadsheet to show how I am currently doing it (first time posting and not sure how to attach a file. Here is the dropbox link: https://www.dropbox.com/s/epniz00wp6ua28j/Wantlist SP17 11.2.16 no grade calc.xls?dl=0.
The first tab titled "WL 10.31.16" is my report tab that I use to bring in all the information. The other tabs contain the data. (The vlookup formulas have been pasted out as values because they tend to get all messed up when I start sorting and moving columns around).
Thanks,
Jonny
Here is a very quick explanation of what I need done and what I have been doing:
I am working with textbooks and with creating a sourcing and orders report. I have a bunch of different data sets that I bring into different tabs (prices, quotas, orders, on hand inventory, etc.). I create one tab where I bring all of that data over using vlookups so that I can start to create the report. It is tedious but I have gotten fast at it.
About every week, I need to update the report with new information (price changes, orders, newly requested books by professors). For now, I have just been creating a new report every time and recreating all of the formulas but I am thinking I should be able to just add the new information to the different data tables I have in the tabs and have that somehow update the reports tab with all the new information.
How can I do this and what would be the best thing to use to do it?
I have attached a sample spreadsheet to show how I am currently doing it (first time posting and not sure how to attach a file. Here is the dropbox link: https://www.dropbox.com/s/epniz00wp6ua28j/Wantlist SP17 11.2.16 no grade calc.xls?dl=0.
The first tab titled "WL 10.31.16" is my report tab that I use to bring in all the information. The other tabs contain the data. (The vlookup formulas have been pasted out as values because they tend to get all messed up when I start sorting and moving columns around).
Thanks,
Jonny
