Hi guys, I have attached a draft of a tracker I'm building. There is a button in there that adds a new row with the same formatting, but what I want it do, based on cell I5 being selected in this example, is the following:
- preserve merged cells in columns A to G (rows 3 to 5/6) - currently a new row is not merged with the rest;
- preserve conditional formatting in columns D, E, and J;
- not to duplicate the thick outside border, but instead move it down.
Can it be done?
Bookmarks