Forum Discussion

Copper Contributor

Oct 12, 2021

Solved

Linking Entire Sheet to another Worksheet

Hello, I am trying to externally link an entire spreadsheet to another spreadsheet. Example: I want all of the data on Sheet1 to be on Sheet2. I also want Sheet2 to auto-update when Sheet1 does. ...

excel

Yea_So
Oct 15, 2021
ToddListon

You stated: I get the #NAME? error.
check this place:
check the name manager, maybe the range for the formula that worked is defined there, while the other is not.

ToddListon

Copper Contributor

Oct 14, 2021

JKPieterse

Thank you for responding.

Yes, I know it depends on a range name. Do you know the US CF 21 range name would not have worked when the other did work? All of the characters are correct in the stated names. There is nothing missing or added.

I don't want to use a table for two reasons. First, the information is not simply a data set, it is the final presentation of data that is being pulled from data sets. Second, the document is for aesthetics and not manipulation. It will be used by the Executives of the company to view for information only. I have played with different table styles and they don't do the job I want. If I have to turn to a query, I may, it just isn't doing what I want it to. Unlike the successful formula I mentioned above.

JKPieterse

Silver Contributor

Oct 15, 2021

Separate the logic I would say: presentation is a different process than getting in the data. So get the data in using a query (into a table or directly feeding a pivottable or whatever you need), then use other techniques within the file to create a nice presentation sheet.

ToddListon
Copper Contributor
Oct 15, 2021
Okay, thank you for the recommendation.