N
NANGO
I have a quote spreadsheet that uses a macro on 2 tabs:
tab one is to enter your part number and VLOOKUP the part to get cost and
then set you margin
tab two shows data from tab one however excludes all cost & margin information
My problem is that even though on though the product description field on
both tabs is formatted (Format > Cells > Alignment tab > Wrap text), my row
cannot autofit the height on either tab to fill in all the information.
Is there a way I can do this so that my font doesn't "shrink to fit" making
it impossible to read the description? My product descriptions can vary from
5 to 30 words and are pulled from a vendor price list.
tab one is to enter your part number and VLOOKUP the part to get cost and
then set you margin
tab two shows data from tab one however excludes all cost & margin information
My problem is that even though on though the product description field on
both tabs is formatted (Format > Cells > Alignment tab > Wrap text), my row
cannot autofit the height on either tab to fill in all the information.
Is there a way I can do this so that my font doesn't "shrink to fit" making
it impossible to read the description? My product descriptions can vary from
5 to 30 words and are pulled from a vendor price list.