$$Excel-Macros$$ Re: Pls Help Me on this

2012-10-19 Thread NOORAIN ANSARI
Brother send a sample sheet. On Fri, Oct 19, 2012 at 3:30 PM, अनिल नारायण गवली wrote: > suppose there is one two excel file > one is A > second is B > in A file there is 2 fields like (Shiptocode) and (Productcode). > in B file there is 5 fields like (Shiptocode) and (Productcode)and(Type) > Typ

Re: $$Excel-Macros$$ Re: Pls help me on this.

2012-10-18 Thread अनिल नारायण गवली
ly took me longer to write this "rant" than it did to throw > together the code. > > hope this helps get you started. > > > *Paul* > > --------------------- > *“Do all the good you can, > By all the means you can, > In all the ways you ca

$$Excel-Macros$$ Re: Pls help me on this.

2012-10-16 Thread अनिल नारायण गवली
Pls somebody help me on this On Monday, October 15, 2012 5:37:44 PM UTC+5:30, अनिल नारायण गवली wrote: > > Dear Groups and Noorian, > > I want a macro that import other worksheets in a excel workbook by using > filedailogbox . > > 1) when filedailogbox opens i have to select the required file a

$$Excel-Macros$$ Re: Pls help me..

2008-11-05 Thread Ajit Navre
Please find attached the file.. there are 2 ways it can be done and both the formulas are in the file.. Ajit From: excel-macros@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of ram bhagath Sent: Tuesday, November 04, 2008 6:27 PM To: excel-macros@googlegroups.com Subject: $$Excel-Mac

$$Excel-Macros$$ Re: Pls help me..

2008-11-05 Thread Taurus Beejay
Dear Ram Use Pivot Table, it is simpler then vlookup Regards On Tue, Nov 4, 2008 at 11:57 PM, ram bhagath <[EMAIL PROTECTED]> wrote: > Hi all,, > > I have attached the file, and explained the proble there only. I wanted to > pick amount from another table by formula. I tried with vlookup i di

$$Excel-Macros$$ Re: Pls help me..

2008-11-05 Thread Akhilesh Karna
Hi, Probably you cannot find any proper formula for your problem. Following function may help you. [tools->Macro->visual basic editor] will get you to macro editor [insert-> module] and copy paste the following function. You need to see how the function is used as formula in the attached file. '--

$$Excel-Macros$$ Re: Pls help me..

2008-11-05 Thread Dave Bonallack
Hi, Check the attached XL to see if it does what you need. Regards - Dave. Date: Tue, 4 Nov 2008 18:27:22 +0530From: [EMAIL PROTECTED]: [EMAIL PROTECTED]: $$Excel-Macros$$ Pls help me.. Hi all,, I have attached the file, and explained the proble there only. I wanted to pick amount from ano

$$Excel-Macros$$ Re: Pls help me..

2008-11-05 Thread Hitesh Dilipbhai Dhare
Hi Ram, Solution is attached herewith in EXCEL. Use of Pivot table may give you this solution. Regards, Hitesh Dhare +919824004308 New * Email ID: [EMAIL PROTECTED] From: excel-macros@googlegroups.com [mailto:[EMAIL PROTEC

$$Excel-Macros$$ Re: Pls help me..

2008-11-05 Thread H Upadhyay
Chk attached file Regards Harish Upadhyay On 11/4/08, ram bhagath <[EMAIL PROTECTED]> wrote: > > Hi all,, > > I have attached the file, and explained the proble there only. I wanted to > pick amount from another table by formula. I tried with vlookup i didnt get > answer. Pls help me. > > Reg