I have a specific formatting design in range G17:T21 which currently gets populated with information if there is data in cell B6:E6. As users add more products (such as B7:E7), each product they add displays information in a different area (for B7:E7, range G22:T26 gets populated with data).
I would like to automatically copy and paste the formatting(design) for a particular range if another cell contains data.
For example:
If cell B7 contains any information, I would like G22:T26 to add the same formatting as G17:T21. I already have formulas in these ranges, so this area would also simultaneously populate with the data that is calculated when info is input into the B7 table
Bookmarks