Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Excel 2010 - Accessing data based on conditions from other sheets


15 Dec 2010   #1

Windows 7 Professional x64
 
 
Excel 2010 - Accessing data based on conditions from other sheets

I've tried goggling this a bit and can't seem to find exactly what I'm looking for.

I'm trying to setup a sheet that can run calculations based upon what someone else enters (ex: if they select 'option1', preferably from a drop down list, then two values will be set to the corresponding values, ex: '5' and '6' or whatever they may be). This would preferably actually be within a formula, so say if they have selected an option, it will perform the calculation with the appropriate data, without having to display it on the current sheet.

I was also trying to keep all the data on another sheet so the one I was actually using looked a bit more organized. I've never had to do anything like this in excel before and was looking for some help or a push in the right direction.


My System SpecsSystem Spec
.

16 Dec 2010   #2

Windows 7 Home Premium 64bit
 
 

I have found the 'CHOOSE' function very useful.
Very difficult to explain, but here is Microsoft Office attempt... CHOOSE function - Excel - Microsoft Office

My scenario was to have a cell in which you would select Quarter 1, 2, 3 or 4. The values in the Profit & Loss Account would change accordingly. Here are examples of my scenario (the cells highlighted in the spreadsheet on the right refer to another sheet - CY Actual - in the workbook).

I hope this helps.


Attached Thumbnails
Excel 2010 - Accessing data based on conditions from other sheets-choose-2.jpg  
Attached Images
 
My System SpecsSystem Spec
16 Dec 2010   #3

 

Quote   Quote: Originally Posted by DarkSnake View Post
I've tried goggling this a bit and can't seem to find exactly what I'm looking for.

I'm trying to setup a sheet that can run calculations based upon what someone else enters (ex: if they select 'option1', preferably from a drop down list, then two values will be set to the corresponding values, ex: '5' and '6' or whatever they may be). This would preferably actually be within a formula, so say if they have selected an option, it will perform the calculation with the appropriate data, without having to display it on the current sheet.

I was also trying to keep all the data on another sheet so the one I was actually using looked a bit more organized. I've never had to do anything like this in excel before and was looking for some help or a push in the right direction.
Depending on the level of experience creating a pivot table for data selection would be an easy option.
My System SpecsSystem Spec
.


Reply

 Excel 2010 - Accessing data based on conditions from other sheets




Thread Tools



Similar help and support threads for2: Excel 2010 - Accessing data based on conditions from other sheets
Thread Forum
what are the options to recover deleted sheets within an excel file? n Microsoft Office
How to open two Excel sheets in their own window Microsoft Office
Excel 2010 Script error popup when getting data from Web Microsoft Office
Solved Excel Sheets Disapeared on one specific file. Microsoft Office
Data Visualization Features in Excel 2010 Microsoft Office

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 10:10 PM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33