Is it possible to write macro which will replace text in cells.
For example: In cell A1 is this kind of text (link): =+'[Gal Birch 1200 1400 1500 P1 R4_1.xlsx]1500 Birch Gal'!$H$19
With macro I would like change cell A2 this kind of link: =+'[Gal Birch P1 R4_1.xlsx]1400 Birch Gal'!$H$19
In A2 link will have same cell but the file address will be changed.
This macro I would like to use in range A1:A30 and in each A1 up to A30 cell is the same file address but different cell
How can I write macro?
Thank you
For example: In cell A1 is this kind of text (link): =+'[Gal Birch 1200 1400 1500 P1 R4_1.xlsx]1500 Birch Gal'!$H$19
With macro I would like change cell A2 this kind of link: =+'[Gal Birch P1 R4_1.xlsx]1400 Birch Gal'!$H$19
In A2 link will have same cell but the file address will be changed.
This macro I would like to use in range A1:A30 and in each A1 up to A30 cell is the same file address but different cell
How can I write macro?
Thank you
