Hello. I have created a Macro that creates a new worksheet based on a range of cells. So in row 5 I have all the weeks e.g. 01.04.21 and this has automatically set up a new worksheet called 01.04.21.
Is there a way I can use the cells in row 5 in a formula so each column pulls information from the worksheet named in row 5 of that column.
each of these dates above have created a worksheet named the same. Is there a formula or VBA code that I can put in that says look at A5 (the date), find the worksheet with the same name and tell me what is in K20 on that worksheet?
Thanks in advance
Is there a way I can use the cells in row 5 in a formula so each column pulls information from the worksheet named in row 5 of that column.
each of these dates above have created a worksheet named the same. Is there a formula or VBA code that I can put in that says look at A5 (the date), find the worksheet with the same name and tell me what is in K20 on that worksheet?
Thanks in advance