how to access a cell value in a different workbook. HELP!
here is how my function looks like. Also i am using this in formula
like =check("A1") function check(cell) { if cell50 get the new valuue from a differnt workbook } can someone PLZ tell me how will i get the value from a different workbook. I have to use this value in my function, can this be done in a macro. I can open the second workbook if need be . please help |
how to access a cell value in a different workbook. HELP!
You can reference the other workbook in the formula, =[Book1.xls]Sheet1!$A$1
-- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 wrote in message oups.com... here is how my function looks like. Also i am using this in formula like =check("A1") function check(cell) { if cell50 get the new valuue from a differnt workbook } can someone PLZ tell me how will i get the value from a different workbook. I have to use this value in my function, can this be done in a macro. I can open the second workbook if need be . please help |
how to access a cell value in a different workbook. HELP!
is there anyway i can use it in my function rather than directly
putting in a formula bar. Its because the value to get is dynamically fetched and my function is already taking care of other conidtions. Paul B wrote: You can reference the other workbook in the formula, =[Book1.xls]Sheet1!$A$1 -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 wrote in message oups.com... here is how my function looks like. Also i am using this in formula like =check("A1") function check(cell) { if cell50 get the new valuue from a differnt workbook } can someone PLZ tell me how will i get the value from a different workbook. I have to use this value in my function, can this be done in a macro. I can open the second workbook if need be . please help |
All times are GMT +1. The time now is 06:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com