Cross-sheet referencing made simple for your data workflows

If you're new to Excel and looking to reference values from another sheet, you're in the right place.

3 min readMicrosoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

A Reddit user asked a simple, honest question: how do you get a number from one sheet to appear on another without retyping it? That question, buried in a forum for Excel beginners, actually points to something bigger than a formula fix. It reveals a fundamental friction in how we work with data today, one that too many tools have simply accepted as normal.

For anyone who has ever maintained a spreadsheet with multiple tabs, this scenario is painfully familiar. You build careful calculations on Sheet 1, then need those results on Sheet 2. The official solution, writing `=Sheet1!A1` or navigating to the cell while typing, works, but it introduces fragility. Move a row. Delete a column. Add a sheet. Suddenly your cross-sheet references break, and you are hunting through formulas trying to diagnose the problem. The user who asked this question is not alone. They are experiencing a design limitation that has been baked into spreadsheets for decades: data that lives in separate places must be manually wired together, and those connections are brittle.

Our view is that this should not be the user's burden. When a tool requires you to learn arcane syntax just to share a single number between sheets, the tool has failed to meet you where you are. The real innovation is not in teaching people to write better references. It is in building a system where data flows naturally across sheets, without manual linking or fragile formulas. An AI-native spreadsheet can understand your intent: when you have totals on one sheet, it should recognize that you want those values available elsewhere, and simply make them so. No cell references. No syntax. No breakage when you reorganize.

This matters because the question reflects a deeper truth about productivity. Every minute spent troubleshooting a cross-sheet reference is a minute not spent analyzing the data itself. The user who posted this is not asking for a more powerful function. They are asking for a tool that respects their time and their focus. A progressive approach to data management recognizes that spreadsheets should adapt to how people think, not the other way around. The next generation of tools will not ask you to learn referencing conventions. They will ask you what you need, then deliver it. That is the transformation worth exploring.

From Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Hi, Im quite new to excel and can't figure out how to reference values on another sheet.

I have some sums and countifs on Sheet 1 and they all total up to lets say 500. How do I get a cell on sheet 2 to display this number without just typing it myself?

Read the original at Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community