•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Referencing values on another sheet
Our take
If you're new to Excel and looking to reference values from another sheet, you're in the right place. It’s a powerful feature that can simplify your workflow and enhance your data management. To display a total from Sheet 1 on Sheet 2, you can use a simple formula. By referencing the specific cell on Sheet 1, you can dynamically update your data without manual input. This approach not only saves time but also ensures accuracy in your calculations.
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?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- How Do I Get Excel To Display A Reference # based on the number of entries?Figured out how to do it: Couldn't get a rounding function and row function to work in the same cel, so I created a hidden column to generate the row separately and then a function using roundup and division to create the page number in the column I want it to appear in. I have a report that I am working with that prints out with 39 entries per page and I want to have a page reference in Excel so I can find something quickly in the printed report. How do I get Excel to generate a number so that fields 1-39 in column A, read as page 1 in column B, fields 40-78 read as page 3 etc... Further information: These reports can be anywhere from one page to 200+. What I'm trying to do to improve work flow is to get a sheet that can figure the page reference automatically when I enter the data into it. submitted by /u/Fickle-Aardvark6907 [link] [comments]
- Best way to tally in 1 sheet to anotherI am new to excel and i want to make tallying more easy and efficient. Is there any formula or tips for me to do this type of tallying : Example: I have sheet 1. And column A is about different words said by random people (this column is an ongoing survey for a year) In sheet 2, there is a table where i need to know how many times that specific word appeared in column A. And i want it to automatically be tallied already from sheet 1 Is there a way for me to make a formula out of it? Thank you!!! submitted by /u/ArrivalRight194 [link] [comments]
Tagged with
#Excel compatibility#Excel alternatives for data analysis#Excel alternatives#rows.com#Excel#another sheet#reference values#countifs#sums#Sheet 1#Sheet 2#cell reference#total#display number#formula#value#cell#data#automate#function