I have a workbook with 3 tabs, one is the list for the Index match (months), one is a list to total based on Data Val cells E2 & E3.
Is there a way to select, from Sheet 1, September and Week 1, grab the totals from E6 to E9, and paste them to the Blend tab cells B4 to B7, and then go back to Sheet 1 tab, choose week 2 and do the same, copy E6 to E9 on month and paste to C4 to C7 on Blend tab and still retain the '1' values?
Is there a way to select, from Sheet 1, September and Week 1, grab the totals from E6 to E9, and paste them to the Blend tab cells B4 to B7, and then go back to Sheet 1 tab, choose week 2 and do the same, copy E6 to E9 on month and paste to C4 to C7 on Blend tab and still retain the '1' values?