Sorry if this isn’t accepted, but i’d like to take the below thread and try to modify it to work for the functionality I’m working to accomplish…
I'm trying to create a macro to automate calculation outputs for different variables. Very new to macro so looking for guidance.
In Sheet1, I have 2 dropdown (data validation) lists (one for name in cell A1, one for date in cell A2). I have a pre-built calculation with 2 different outputs in cell B1 and B2. I want to calculate for each name across all the available dates and copy the outputs in cell B1 and B2 to Sheet1 column C and D that match name in column A and date in column B.…
This thread takes the two data validations and cycles through all the potential options and then copies and pastes the values for each iteration on the Output sheet. What I’m trying to accomplish is to take data validation 1 (A-D in this example) and create a new workbook and with data validation 2 (1/1/2021 - 1/10/2021) create the 10 sheets titled 1/1/2021 - 1/10/2021 and copy the sheet (ie in this case Input sheet) and paste on to the respective sheets within each of the four workbooks that are created. So in this case it would be 4 workbooks with 10 sheets.
My data is 7 departments (A-G) that would be data validation 1 and data validation 2 containing the months of the year. So my output would be 7 workbooks with 12 sheets each titled January - December. Ideally I’d love it to take the values of cells A1:I10 and paste values and A11:I60 and paste formulas.
Hope this makes sense!