Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accouting & Database
Hi Frank They are in different workbook. Your Method doesn't work for me in thi case this case. :( I have a few project running at a time. And Expenses is Key i according to the dates of cheque issued and cheque recieved. Projec Expenses is a Profit and loss workbook and key in according to th same project. Mindy On -- Minde ----------------------------------------------------------------------- Mindee's Profile: http://www.excelforum.com/member.php...nfo&userid=679 View this thread: http://www.excelforum.com/showthread.php?threadid=26841 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accouting & Database
hi Mindee,
we can still use formulas. =('H:\CodeStuff\[ConnectPaths.xls]Sheet1'!D4) here is a fomula i just tested. It will get data out of the other workbook where the workbook is open or not. you will have to adjust the file paths in your formulas no doubt. =COUNTA('S:\PUBLIC\Ae-pc\Work Order Monitor\FY03\[Work Order Monitoring Jan.xls]MPX'!$A$4:$A$500) here is another one that works. it is all one line. but i thing you will be interested in the first one. reqards Frank -----Original Message----- Hi Frank They are in different workbook. Your Method doesn't work for me in this case this case. :( I have a few project running at a time. And Expenses is Key in according to the dates of cheque issued and cheque recieved. Project Expenses is a Profit and loss workbook and key in according to the same project. Mindy Ong -- Mindee ---------------------------------------------------------- -------------- Mindee's Profile: http://www.excelforum.com/member.php? action=getinfo&userid=6799 View this thread: http://www.excelforum.com/showthread...hreadid=268410 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update Excel Database via Access Main Database with a script | New Users to Excel | |||
database query not showing foxpro database How I import data | New Users to Excel | |||
How to make reference to database and if true copy from database? | Excel Discussion (Misc queries) | |||
Moved database, how do I change link to the database in excel | Excel Discussion (Misc queries) | |||
Accouting & Database | Excel Programming |