Re: $$Excel-Macros$$ Online tutorials for macros

2010-07-10 Thread manan joshi
try google vedio and on you tube there are lot many then you want sure it will help On Sat, Jul 10, 2010 at 9:20 PM, krishnan moorthy wrote: > Dear All, > > I am a beginner in creating excel macros. Is there a website that has > online tutorials on excel macros? > > Any kind of information would

Re: $$Excel-Macros$$ Excel - Macros training in Excel 2003

2010-07-10 Thread Nikhil Shah
Dear Friend Yes.Yes.. Frist visit the web site..here they have number option..Excel 2003 or excel 2007 Regards Nikhil On Sun, Jul 11, 2010 at 7:13 AM, krishnan moorthy wrote: > Thank you Nikhil... have a quick question.. will this work in office 2007 > as well?? > > > On Sat, Jul 10, 2010 at 1

Re: $$Excel-Macros$$ Excel - Macros training in Excel 2003

2010-07-10 Thread krishnan moorthy
Thank you Nikhil... have a quick question.. will this work in office 2007 as well?? On Sat, Jul 10, 2010 at 10:32 PM, Nikhil Shah wrote: > Dear Friends > > Here i am sending One URL For Excel - Macro Training in excel 2003. > > http://www.familycomputerclub.com/excel/excel2003_macros.html ( With

$$Excel-Macros$$ Data Manipulation and report automation

2010-07-10 Thread Aligahk06
Dear All, Can anybody through a deep light on Data Manipulation and report automation with sample file or examples or pdf. Rgds, Aligahk06 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips

Re: $$Excel-Macros$$ Interview questions

2010-07-10 Thread Vinod N
I agree with Saggi... The questions will be around Data Analysis, manipulation, dashboards/scorecard etc. On Sat, Jul 10, 2010 at 11:03 AM, saggi wrote: > > In 4.5 yr experience i don't think anyone going to judge ur excel > skill by vlookup n pivot... > they will check ur technique abt Data Man

Re: $$Excel-Macros$$ Query - Date Formula

2010-07-10 Thread Vinod N
Hi, Please use Data Validation Select the Date option from Allow dropdown and mention the start and end date in that. If you are not satisfied with the above please send a sample data and the group members will reply.. Thanks Vinod N On Sat, Jul 10, 2010 at 2:59 PM, Nikhil Shah wrote:

$$Excel-Macros$$ Re: Excel - Macros training in Excel 2003

2010-07-10 Thread Rahul Gandhi.
Thanks a Ton.. Nikhil That's a great Help.. On Jul 10, 10:02 pm, Nikhil Shah wrote: > Dear Friends > > Here i am sending One URL For Excel - Macro Training in excel 2003. > > http://www.familycomputerclub.com/excel/excel2003_macros.html( With Video ) > In English &  Hindi also

$$Excel-Macros$$ Excel - Macros training in Excel 2003

2010-07-10 Thread Nikhil Shah
Dear Friends Here i am sending One URL For Excel - Macro Training in excel 2003. http://www.familycomputerclub.com/excel/excel2003_macros.html ( With Video ) In English & Hindi also I think , it gives some knowledge about how to write macro.. Regards Nikhil Shah -- --

$$Excel-Macros$$ Online tutorials for macros

2010-07-10 Thread krishnan moorthy
Dear All, I am a beginner in creating excel macros. Is there a website that has online tutorials on excel macros? Any kind of information would be of great help. Thanks in advance!! :) Krishnan -- -- Some importan

RE: $$Excel-Macros$$ Problem facing attchment

2010-07-10 Thread SAJID MEMON
Hi, dear Mahesh parab it's working and i want this query. Again many many thanks. Actually I am making a customize software for myself use. it's your best compliment. I always remember you when i used this event. your friendsajid memon. Date: Wed, 7 Jul 2010 22:21:16 +0530 Subject: Re: $$E

Re: $$Excel-Macros$$ Re: Query - Date Formula

2010-07-10 Thread Nikhil Shah
Dear Friend Thanks For Help.I have Found Data Validation Function. My Excel Sheet is now working find.. against Thanks Regards Nikhil Shah On Sat, Jul 10, 2010 at 4:51 PM, saggi wrote: > > Dear Nikhil, > > Use Data Validation for reflect the error > > -- > >

Re: $$Excel-Macros$$ Please check the attachment.

2010-07-10 Thread Jai
Thank a lot sir On Sat, Jul 10, 2010 at 4:27 PM, Born to Win wrote: > Dear Jai, > > Please check attached sheet. > > Thanks, > Chandrabhan Singh > > > > On Sat, Jul 10, 2010 at 1:03 AM, Jai wrote: >> >> -- >> Thanks For Mail. >> >> -- >> >> ---

$$Excel-Macros$$ Re: Please check the attachment.

2010-07-10 Thread saggi
I am not sure i m understanding you correct n fully.on given XL issue possible solution is Suppose Name in Column A Values in cloumn B & C... Filter on complete Column then select black cells..after tht = c2 or C3 Paste it till bottom On Jul 10, 1:03 pm, Jai wrote: > -- > Thanks For Mail.

$$Excel-Macros$$ Re: Query - Date Formula

2010-07-10 Thread saggi
Dear Nikhil, Use Data Validation for reflect the error -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @

Re: $$Excel-Macros$$ Please check the attachment.

2010-07-10 Thread Born to Win
Dear Jai, Please check attached sheet. Thanks, Chandrabhan Singh On Sat, Jul 10, 2010 at 1:03 AM, Jai wrote: > -- > Thanks For Mail. > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER

$$Excel-Macros$$ Query - Date Formula

2010-07-10 Thread Nikhil Shah
Dear All, Pl help out my query.. *Starting Dt.01/04/1998 ( Format dd/mm/ ) Ending Dt. 31/03/2003 ( Format dd/mm/ )* Loan Dt ( Format should dd/mm/ ) *[ 1 ]* Loan Dt should be between Starting Dt. And Ending Dt...What is formula ? *[ 2 ]..*... If Loan Dt is below St

$$Excel-Macros$$ Please check the attachment.

2010-07-10 Thread Jai
-- Thanks For Mail. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=18

Re: $$Excel-Macros$$ Problem facing attchment

2010-07-10 Thread SUMIT VYAS
On Wed, Jul 7, 2010 at 10:21 PM, Mahesh parab wrote: > Hi Sajid > > Click on sheet1 tab > right click & select view code > copy below mention code > > enter value in c8 & press enter cursor will move to G14 > > Private Sub Worksheet_Change(ByVal Target As Range) > If Target.Address = "$C$8" Then

Re: $$Excel-Macros$$ how can I control IE8 tabs from VBA?

2010-07-10 Thread Vikas Chouhan
Hi, Ctrl+T for new tab and change tab ctrl+1(for first tab),ctrl+2(second tab)ctrl+3..and Ctrl+W for closed current TAb... On Fri, Jul 9, 2010 at 5:42 PM, bruce wrote: > I have the need to work with IE8 and TABs. I have found out how to > open a new tab, but how can I control wh