Re: $$Excel-Macros$$ Working in multiple workbooks

we need to open linked file in some cases like if we used sumif ,Countif.. Rajan. On 12/5/11, Veer wrote: > Dear B Sharma, > > if you dont want to open both files, u can merge all the worksheets of > both workbooks in one workbook. > > or u can attach your files as example to make practical solu

Re: $$Excel-Macros$$ Working in multiple workbooks

Hi Bajrang, what error you getting if you dont open second file... Rajan. On 12/3/11, B Sharma wrote: > Dear Excel Experts... > > I have created two separate work book. > 1st one is the database and 2nd one is the report / summary file > > now my query is that while checking the reports I dont

Re: $$Excel-Macros$$ Working in multiple workbooks

Dear B Sharma, if you dont want to open both files, u can merge all the worksheets of both workbooks in one workbook. or u can attach your files as example to make practical solution. THanks Veer On Dec 4, 4:14 am, B Sharma wrote: > Dear friends > thanks for replyinng > > But I havrent got m

Re: $$Excel-Macros$$ Working in multiple workbooks

Dear friends thanks for replyinng But I havrent got my solution On Dec 3, 11:19 pm, NOORAIN ANSARI wrote: > Dear B. Sharma, > > Read this article or use VBA Macro mentioned > thereby:-http://www.excelitems.com/2010/11/shrink-reduce-excel-file-size.html > > Thanks & regards, > Noorain Ansari

Re: $$Excel-Macros$$ Working in multiple workbooks

Dear B. Sharma, Read this article or use VBA Macro mentioned thereby:- http://www.excelitems.com/2010/11/shrink-reduce-excel-file-size.html Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/*

$$Excel-Macros$$ Working in multiple workbooks

Dear Excel Experts... I have created two separate work book. 1st one is the database and 2nd one is the report / summary file now my query is that while checking the reports I dont want to open the database file ,, currently I have to open both file for working. Is there any easy way. 2ndly pl