First post, long time excel user, becoming a power user in light of this project.
The situation:
I have a pricing spreadsheet that has all the pricing components listed in a row, which involve calculations, formula's, and text data. The sheet is 1000 rows of different products and prices...