Anyone have a trick for combining information from different spreadsheets with individual layouts from separate departments while maintaining data integrity? I worry that consolidating by using 3-d formulas will become unreliable if the source sheet has a line deleted.
Ryan.