Using VBA or excel but mainly vba
I have code that depending on number a entered in will make copies of a chart created in excel.
I have a formula in a cell in sheet 1 that equals a value in sheet 2. Same workbook. sheet 1 is show below
sheet 2 looks like
I am trying to use VBA to keep that formula accurate with the cells needed in sheet 2. The formula changes from =Sheet2E19 to =Sheet2U19 as show below
I need the formula to be =Sheet2I19 instead of =sheet2U19 and so on so forth (ie sheet2M19, sheet2Q19 etc). So what it is doing is adding 16 characters when needing to only add 4 characters. I am doing this in VBA or if there is an excel formula too, any help would be thankful for
I have code that depending on number a entered in will make copies of a chart created in excel.
I have a formula in a cell in sheet 1 that equals a value in sheet 2. Same workbook. sheet 1 is show below
sheet 2 looks like
I am trying to use VBA to keep that formula accurate with the cells needed in sheet 2. The formula changes from =Sheet2E19 to =Sheet2U19 as show below
I need the formula to be =Sheet2I19 instead of =sheet2U19 and so on so forth (ie sheet2M19, sheet2Q19 etc). So what it is doing is adding 16 characters when needing to only add 4 characters. I am doing this in VBA or if there is an excel formula too, any help would be thankful for
