Hello,
I am trying to create a spread sheet that will allow me to trend and proof the invoice data from one of our Colo sites we use. I am able to download monthly usage data from their web portal. Based on a drop down selection in cell A1, I would like to have the main sheet populated with that corresponding months data (on a separate sheet) but utilized the lookups and formulas from that main sheet. So, if I select FEB 2016 from the drop down, I would like the data from sheet 02-2016 input into the main sheet that would have all of the formulas and lookups which would correspond to the selected sheet. Image below and spread sheet attached. Please let me know if you have further questions.
Colo Excel.jpg
Thanks in advanced for any help on this!
Bryce
Bookmarks