Hello,
I'm trying to write a macro, which would take the address from cell1, the address is created from formula:
then take the value from selected cell(I launch the macro from that cell), and add it to the value of the cell, from that address.(from the formula)
The cell with the found address is in another sheet.(In the same workbook.)
Thanks for help,
Simon
I'm trying to write a macro, which would take the address from cell1, the address is created from formula:
=cell("address";INDEX('2021'!$A$1:$AF$187;MATCH($B8;'2021'!$B$1:$B$187;0);MATCH($H$5;'2021'!$A$1:$AF$1;0))) |
then take the value from selected cell(I launch the macro from that cell), and add it to the value of the cell, from that address.(from the formula)
The cell with the found address is in another sheet.(In the same workbook.)
Thanks for help,
Simon