Re: $$Excel-Macros$$ Help for Pick data from access to Excel

2010-08-11 Thread Umesh Matkar
t;Access etc I hope this will help you > > Regards > Ramkesh > 9990260398 > > On Sat, Aug 7, 2010 at 8:46 PM, Umesh Matkar wrote: > >> **Dear All, >> >> I need your help >> >> I have some Mobile nos in 'a' colmn ..and that mobil

Re: $$Excel-Macros$$ Help for Pick data from access to Excel

2010-08-09 Thread Umesh Matkar
Dear Friends, Need your help..could you please help me.. -Umesh On Sat, Aug 7, 2010 at 8:46 PM, Umesh Matkar wrote: > **Dear All, > > I need your help > > I have some Mobile nos in 'a' colmn ..and that mobile no related other > information is availble in MS-Acces

$$Excel-Macros$$ Help for Pick data from access to Excel

2010-08-07 Thread Umesh Matkar
**Dear All, I need your help I have some Mobile nos in 'a' colmn ..and that mobile no related other information is availble in MS-Access table (data volume is 6lac) Mobile No Name Add1 Add2 Add3 Alternate no 123456 325641 267789 325641 Please suggest me any macro

RE: $$Excel-Macros$$ Re: month between two different month..formula

2010-03-02 Thread Umesh Matkar
Yes its working ..thanx..i learn more things from this group From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Dilip Pandey Sent: Tuesday, March 02, 2010 8:43 PM To: Umesh Matkar Cc: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: month between

$$Excel-Macros$$ month between two different month..formula

2010-03-01 Thread Umesh Matkar
Pls suggest formula ..for below conditions >From To Codes Jul-09Sep-09 JS0909 Apr-09 Jun-09 AJ0909 Oct-08 Mar-09 OM0809 Apr-08 Sep-08 AS0808 Oct-07 Mar-08 OM0708 Oct-06 Sep-07 OS0607 Sep-06 TS06 (sep-06 and greater than that ..means jan04

$$Excel-Macros$$ books for learning excel vba

2010-02-13 Thread Umesh Matkar
Dear Excel Guru's /Masters can u please suggest me some books for learning excel vba / macro ..from starting to end (means like beginner) means like wht is dim, wht is string ..how its work etc etc. Please. Umesh M

RE: $$Excel-Macros$$ pls help - Vertical to Horizontal

2010-02-12 Thread Umesh Matkar
Hi Ayush..yes its working .thanx One more thing is ..can u suggest me some books for learning excel vba / macro ..from starting to end (means like beginner) means like wht is dim, wht is string ..how its work etc etc. Please. Umesh Matkar From: ayush jain [mailto:jainayus

RE: $$Excel-Macros$$ Please help - consolidate all shets in main shet

2010-02-07 Thread Umesh Matkar
Thanx Ashish.its work..thanx again - Umesh Matkar From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of ashish koul Sent: Saturday, February 06, 2010 7:57 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Please help - consolidate

RE: $$Excel-Macros$$ Please help - consolidate all shets in main shet

2010-02-06 Thread Umesh Matkar
s("main ").Range("C" & i & ":" & "R" & i).Value = c.Range("A43:P43").Value End If i = i + 1 Next End Sub Let us know if any further help is required. Best regards, Ayush Jain On Sat, Feb 6, 2010 at 7:18 PM, Umesh Matkar wro

$$Excel-Macros$$ when workbook open ask passward

2009-11-28 Thread Umesh Matkar
Sanjay" etc.) If we put passward raju.excel shows only sheet 1 and sheet 2 When put passward sanjay.excel shows only sheet3 and sheet4 Like this Thanx Umesh matkar -- -- Some important links for exce

$$Excel-Macros$$ Excel macro-Help

2009-10-06 Thread Umesh Matkar
Dear Friends, I have one query regarding macro. i want to record a macro for goal seek. Attached reference sheet says following Column A - my goal starts from 2009 for 16 years till 2024. B - Accumulated amount equal to one row up for column E C - goal seek result i.e investment amount, please ref

$$Excel-Macros$$ Re: Need Urgent help in finding formula.

2009-08-22 Thread Umesh Matkar
Hi vinod Use rank formula e.g =rank() On Fri, Aug 21, 2009 at 2:16 PM, vinod rao wrote: > Hi Team, > > Not in this way. :( > > First i do not want to sort. > Second the ranking should be based on Glass and should not consider the > city or district. > > Example > Glass- Based on bigest value it

$$Excel-Macros$$ Re: pls help for maintain MIS

2009-08-16 Thread Umesh Matkar
who would also be intersted to help you > out. > > Group Mail Id:- excel-macros@googlegroups.com > > Thanks, > Dilip Kumar Pandey > > On 8/16/09, Umesh Matkar wrote: > > hi > > Dilip..can you help me for maintain daytoday mis.. we face many problem > to > &

$$Excel-Macros$$ maintain daytoday mis

2009-08-16 Thread Umesh Matkar
hi Friends...can you help me for maintain daytoday mis.. we face many problem to maintain thousand of data in excel.. we discuss on that.. -- -- Warm Regards, You mesh --~--~-~--~~~---~--~~ ---