Hi,
I am trying to set up a macro to run some batch operations.
What I have is a workbook with a lot of half hourly data from electricity and gas meters for 17 buildings. Cell C1 of the "1MonthlyProfile" sheet has a data validation list linked to the list of buildings (in a named range of "Buildinglist"). So you change that cell's value and the workbook will select the data for that building, drawing graphs, doing calculations, etc.
What I am looking for is to create a macro which will change the value of C1 to the first item in the "Buildinglist" range, then activate two sheets ("1MonthlyProfile" and "1hrratekwhprfilmth") and save them as a PDF. Then it to move to the second item in the "Buildinglist" range, save as PDF, then the 3rd, 4th, etc. Preferably to the last item, as it might increase from 17.
Is this possible?
Thanks guys
I am trying to set up a macro to run some batch operations.
What I have is a workbook with a lot of half hourly data from electricity and gas meters for 17 buildings. Cell C1 of the "1MonthlyProfile" sheet has a data validation list linked to the list of buildings (in a named range of "Buildinglist"). So you change that cell's value and the workbook will select the data for that building, drawing graphs, doing calculations, etc.
What I am looking for is to create a macro which will change the value of C1 to the first item in the "Buildinglist" range, then activate two sheets ("1MonthlyProfile" and "1hrratekwhprfilmth") and save them as a PDF. Then it to move to the second item in the "Buildinglist" range, save as PDF, then the 3rd, 4th, etc. Preferably to the last item, as it might increase from 17.
Is this possible?
Thanks guys
