Hello

I am not understanding why text wrap wont work for a series of linked cells on my spreadsheet. I have two tabs, "Req Request" (or “RR”) and "Support Rec" (or SR); I have linked SR to RR using the formula “=ReqRequest!C10” and so on for all the desired cells on the SR tab.

The owner of the sheet populates their purchase requests on the RR tab, which then auto-populates the SR tab. The SR tab then has additional columns for entering pricing and purchase order numbers by another user.

Both tabs are set up the same, SR tab just has extra columns. None of the cells are merged or manually formatted.
The issue I am experiencing is, the RR tab will auto-fit row height and text wrap for large descriptions, but the SR tab will not. It’s forcing me to manually text wrap every time.
Is this because the cells on the SR tab are linked to the RR tab? Is my only option to create some kind of macro that forces SR tab to also text-wrap like the linked RR tab?

I have zero clue about macro’s, so hopping to avoid doing that, but I’m obviously missing a step and not sure how to make the SR tab text-wrap automatically like the RR tab does.

Any advice would be greatly appreciated!

thanks, Katie