Hello coding experts,
Hopefully a relatively straightforward problem. I have a list of products and descriptions setup in an excel table. I reference the product elsewhere in the workbook, and pull the description beneath it using two carriage returns, as such:
=C4&""&INDEX(MY_TABLE_DESCRIPTION,MATCH(C4,MY_TABLE_PRODUCT,0))
Can someone point me in the right direction for creating a loop that will format the description (text found after the carriage returns) as size 8 font? Please note that this will (hopefully) be applied to other multiple sheets.
Bookmarks