Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Here is what I want to do. Sheet one on a workbook is a "master list of all. Sheets 2 thru 5 are location breakdowns of the master list, with column B being the location. I want to be able to change the location on Sheet one and have it populate/depopulate the proper location sheet 2 thru 5

share|improve this question
add comment

3 Answers

Try using the INDIRECT function. See here for a tutorial.

share|improve this answer
add comment

You can reference a cell on another worksheet using the following format Sheetname!Cell identifier. For example:

=Sheet1!A1

You can directly enter this on cells on the other sheets. Or type = and then select the other sheet and then select the cell you want and then hit the Enter key the referenced cell will be inserted for you.

share|improve this answer
add comment

Consider to use so called 3D-formula: assuming you need to "populate" cell A1 from sheets 2-5 use this formula: =SUM(Sheet2:Sheet5!A1)

Read more: 3d formulas in Excel 2010

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.