G
Guest
Need help with coding that would look at cells within columns that are
colored (shaded) and automatically copy/paste to the next column over and chg
the links to the next row # in the link
For example:
Column Z;Row 4 is a shaded cell, that has the link formula referencing
another files, "Sheet1!$D$60".
The coding I want would look at that link formula and copy/paste to Column
AA; Row 4 but now show the link reference as "Sheet1!$D$61"
I know this sounds and looks crazy, but it's really what I need. For the
code to look for the shaded cell, and increase the row by 1 after it
copies/paste the formula in the next column.
ANY and all guidance is greatly appreciated! )
colored (shaded) and automatically copy/paste to the next column over and chg
the links to the next row # in the link
For example:
Column Z;Row 4 is a shaded cell, that has the link formula referencing
another files, "Sheet1!$D$60".
The coding I want would look at that link formula and copy/paste to Column
AA; Row 4 but now show the link reference as "Sheet1!$D$61"
I know this sounds and looks crazy, but it's really what I need. For the
code to look for the shaded cell, and increase the row by 1 after it
copies/paste the formula in the next column.
ANY and all guidance is greatly appreciated! )