$$Excel-Macros$$ Re: Urgent....Excel 2007 file recovery

2009-09-03 Thread vivek agrawal
oh k Thanks a lot Sathish once Again... This was again a great learning... :) Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Fri, Sep 4, 2009 at 10:53 AM, Sathish Jalendran wrote: > Hi, > > > > I just tried opening the file

$$Excel-Macros$$ Re: Urgent....Excel 2007 file recovery

2009-09-03 Thread vivek agrawal
Really?... thats great this means some temp files might be creating some problem... neways now m happy... thanks a lot... :) Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Fri, Sep 4, 2009 at 12:16 AM, Daniel wro

$$Excel-Macros$$ Re: Urgent....Excel 2007 file recovery

2009-09-03 Thread vivek agrawal
hey Satish Thank You So much Thanks a lot. i m just unable to express my gratitude. my work is done and m tension free now... thanks once again IF you can then pls tell how did u you do this.. which software did you use please detail the precedure Thanks and Rega

$$Excel-Macros$$ Re:

2009-09-03 Thread Dilip Pandey
Hi Umesh, Just answerd this one in my previous reply. Thanks -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 9/2/09, Umesh Gupta wrote: > > This is a sample file where use many vba code for insert row if

$$Excel-Macros$$ Re:

2009-09-03 Thread Dilip Pandey
Hi Umesh, Try the following quick code.:- Sub insertt() dim i ,a as Integer Selection.Activate i = InputBox("Give no. of rows to insert", "Input Rows Required") For a = 1 To i Selection.Offset(1, 0).EntireRow.Select Selection.Insert Next End Sub Note:- you have to carefully include this in your ex

$$Excel-Macros$$ Re: Vlookup Value

2009-09-03 Thread Dilip Pandey
Hi Ashwin, Sorry for delay. Please find the solved attachment, I have got the results using database function. Thanks -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 9/2/09, Ashwin wrote: > > > Hi Dilip,

$$Excel-Macros$$ Re: Count if i appreciate if do this ASAP

2009-09-03 Thread Dilip Pandey
Hi Amresh, Thanks for highlighting my name. Required solution is attached with this email. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 9/3/09, amresh kumar wrote: > > Hi My All Friends, > > P

$$Excel-Macros$$ Re:Site formulation inclusing Multiple freq.

2009-09-03 Thread jonell
On Sep 3, 9:35 pm, Umakant Hale wrote: > Friends pls find attached sheet, > & help to solve this issue > Br > umakant > > test.xls > 18KViewDownload Hi Umrakant, The conditional formatting formula is in the attached file, however if the number of your sectors for each site will vary, the for

$$Excel-Macros$$ Re: need array formula

2009-09-03 Thread santosh bahuguna
wht you want to know how to use array function ..??? On Thu, Sep 3, 2009 at 10:54 AM, gyanesh jain wrote: > Hi, > How to use > > {=TABLE(,K11)} > > this type of function. > > -- > Thanks, > Gyanesh Jain, BE, MBA (Finance) > +91 98868 68488 > Please Save a tree...please don't print this e-mai

$$Excel-Macros$$ Re: NEED HELP on multiple vlookup

2009-09-03 Thread santosh bahuguna
if you want to create a macro for it then it can be done easly but if you want to perform this with excel then i will be little tricky (1) first copy unique keys records to another sheet * (this you can do with the help of advance filler or countif) then goto old data sheet* ** (2)

$$Excel-Macros$$ Re: NEED HELP on multiple vlookup

2009-09-03 Thread madhur baharani
Dear Paul, I am really thankful for the solution. It is exactly the same as I need. Well thank you once again & to the group. On Thu, Sep 3, 2009 at 6:10 PM, Paul Schreiner wrote: > I created a macro called Gen_IDs() > > run it and it generates your summary on sheet: Summary. > >

$$Excel-Macros$$ Re: NEED HELP on multiple vlookup

2009-09-03 Thread Paul Schreiner
What type of solution are you looking for? I KNOW I can write a macro to do it, but I MIGHT be able to come up with a way to do it with standard Excel functions. Paul From: madhur baharani To: excel-macros@googlegroups.com Sent: Thursday, September 3, 2009 7:

$$Excel-Macros$$ How much formulas can be applied in a cell

2009-09-03 Thread Raj Kumar
Hi Friend, My Self Raj kumar & i would like to ask a questin, that how much formulas can be applied a cell in Excel. Thanks a lot Raj Kumar --~--~-~--~~~---~--~~ -- Some important link

$$Excel-Macros$$ Site formulation inclusing Multiple freq.

2009-09-03 Thread Umakant Hale
Friends pls find attached sheet, & help to solve this issue Br umakant --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add

$$Excel-Macros$$ Re: Count if i appreciate if do this ASAP

2009-09-03 Thread anil panchal
Hi Amresh, Please find the attached file, Thanks Anil Kumar On Thu, Sep 3, 2009 at 2:30 PM, amresh kumar wrote: > Hi My All Friends, > > Please find the attached file i want count working days absent date and > half day of employee > > Please let me know if any doubts. > > Special request to Di

$$Excel-Macros$$ Re: Count if i appreciate if do this ASAP

2009-09-03 Thread suresh k
Hi Amresh, You can use CONCATENATE function for your query. Attached is the solution. On Thu, Sep 3, 2009 at 2:30 PM, amresh kumar wrote: > Hi My All Friends, > > Please find the attached file i want count working days absent date and > half day of employee > > Please let me know if any doubts.

$$Excel-Macros$$ Re: Count if i appreciate if do this ASAP

2009-09-03 Thread amresh kumar
thanks a lot dear you are really brilliant On Thu, Sep 3, 2009 at 2:38 PM, Sathish Jalendran wrote: > Hi, > > > > Please check if the attached solution suits you > > > > Regards > > Sathish Jalendran > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-mac...@googlegroups.com] *On Beha

$$Excel-Macros$$ Re: Count if i appreciate if do this ASAP

2009-09-03 Thread Sathish Jalendran
Hi, Please check if the attached solution suits you Regards Sathish Jalendran From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of amresh kumar Sent: 03 September 2009 PM 02:30 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Count if i app

$$Excel-Macros$$ Count if i appreciate if do this ASAP

2009-09-03 Thread amresh kumar
Hi My All Friends, Please find the attached file i want count working days absent date and half day of employee Please let me know if any doubts. Special request to Dilip Regard Amresh --~--~-~--~~~---~--~~ ---

$$Excel-Macros$$ Macro for copying all data

2009-09-03 Thread suresh k
Hi, Is there any macro for copying all the data from 20 different excel file to a single master file. Plz let me know. Thanks & Regards, Suresh --~--~-~--~~~---~--~~ -- Some important

$$Excel-Macros$$ Re: NEED HELP on multiple vlookup

2009-09-03 Thread rahul rahul
Hi Madhur, What you may wanna do is to run a pivot on the data sheet to see how many ID's does a Key actually have an there by extract the data from the same. Regards, Rahul --- On Thu, 3/9/09, madhur baharani wrote: > From: madhur baharani > Subject: $$Excel-Macros$$ NEED HELP on multip