I cannot easily reproduce in Excel. In order to improve the Excel performance I manually copied 20 cell attributes that I used, borders, font, size, bold, etc. Rather than doing an Excel Copy and Paste methods.
What I have done is show you some same output and my input spreadsheet. In practice the 2 sheets are in different files. The formatting tab is one of many table that control look and feel. In this specific instance I would do a find on the Formatting tab, looking for "std-prod-detail' and I would find cell "A6". I would then want to copy cell style and borders from "B6" to my SampleOutput tab cell "A18", and I would copy it to "A19" also, changing the cell value as I output data.
I know I'm position at SampleOutput "A18" and I have found style I want at Formatting tab cell "B7" but I'm I only know this because I have a reference to "A7" and I know I want whatever style/borders are in the cell next to it.
I am already doing copy and paste of everything on the page, except the product min-max ranges and the rates, just can't get the style and borders piece.