Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Get Values from another Worksheet
Hello,
I have an existing spreadsheet that contains account information such as account number, name, rating loan balance, net balance, etc... This information is contained in a worksheet named Data. I need to create another report from some of the info on the Data tab. I have created a new tab named "Watch". I need to get all account numbers, name, rating, and balances where the rating of the account = 5. I need help with a formula that will enable me to get the information I need contained on the Data tab onto the Watch tab. Also, when this report gets updated I would like the info on the Watch tab to also get updated. Any help with this will be greatly appreciated. If you need more details just reply to this post and I will be sure to provide what is needed. Thank You. Dave Y |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Values more than one worksheet | Excel Discussion (Misc queries) | |||
Deleting a worksheet but retaining values from the worksheet. | Excel Discussion (Misc queries) | |||
Deleting a worksheet but retaining values from the worksheet. | Excel Discussion (Misc queries) | |||
Search one worksheet for values in another worksheet? | Excel Discussion (Misc queries) | |||
getting values from other worksheet | Excel Worksheet Functions |