C
celia
I am seeking other people opinion in presenting the data in a more
efficient way.
The way I arrange need a lot of time to update the values.
I think this is because under the title column, each cells is refering
to a different sheet,so the sheets in open and close for many times
from the first cell to the last cell
Please refer to the file attached. I cannot show in here because there
are formulas in the cell and would better refer to the file.
By not changing the layout. Can anyone have a different way to do the
searching?
Any suggestions?
Thanks.
celia
+----------------------------------------------------------------+
| Attachment filename: book2.xls |
|Download attachment: http://www.excelforum.com/attachment.php?postid=373333|
+----------------------------------------------------------------+
efficient way.
The way I arrange need a lot of time to update the values.
I think this is because under the title column, each cells is refering
to a different sheet,so the sheets in open and close for many times
from the first cell to the last cell
Please refer to the file attached. I cannot show in here because there
are formulas in the cell and would better refer to the file.
By not changing the layout. Can anyone have a different way to do the
searching?
Any suggestions?
Thanks.
celia
+----------------------------------------------------------------+
| Attachment filename: book2.xls |
|Download attachment: http://www.excelforum.com/attachment.php?postid=373333|
+----------------------------------------------------------------+