Cell Linking & Reference Table Too Large
We are trying to pull in specific data from a large tracking sheet we have for all vendors to share with just one vendor. We do not need all the columns from the source sheet to be in this vendor specific sheet, but the order of the columns must be maintained in the source sheet. The difficulty we are facing is that when referencing all the consecutive columns, the reference exceeds the 100,000 cell limit and all columns referenced must be next to each other.
How can we work around this or devise another solution? Reports will not work because we do not want the vendor seeing internal comments. Thank you in advance.