getting values from other worksheet
Hello All, I would like to get values from other worksheet. How to do that? Basically I want to do a countif on one particular cell based on the values of another column in another worksheet in the same excel document. Can anyone help me out. Sandy -- sandyjack ------------------------------------------------------------------------ sandyjack's Profile: http://www.excelforum.com/member.php...o&userid=26101 View this thread: http://www.excelforum.com/showthread...hreadid=394315 |
You can just type "=" in the cell you want the data to end up in, click over
to the other sheet, and click on the cell you want to reference. -- David Billigmeier "sandyjack" wrote: Hello All, I would like to get values from other worksheet. How to do that? Basically I want to do a countif on one particular cell based on the values of another column in another worksheet in the same excel document. Can anyone help me out. Sandy -- sandyjack ------------------------------------------------------------------------ sandyjack's Profile: http://www.excelforum.com/member.php...o&userid=26101 View this thread: http://www.excelforum.com/showthread...hreadid=394315 |
All times are GMT +1. The time now is 12:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com