I have a detailed calculation going on in a worksheet that spans 36 months (columns). The calculation is done for one out of 64 locations based on whichever location is selected from a drop down list (data validation). That is, as I choose a different location, the worksheet automatically updates from various source worksheets and gets me the final answer I need. I have a separate worksheet that lists all 64 locations down the rows (in a single column) and the months going across the columns (in a single row). I want to populate this summary worksheet with the answer on the calculation worksheet w/o having to select each location from the drop down list and copy and paste the results one at a time. I went through the Macro recorder and tried to get it, but the macro didn't recognize the step where I changed locations in the drop down list. Any help would be greatly appreciated. I've attached a very simplified example.
Thanks y'all!
Mike
Bookmarks