Re: $$Excel-Macros$$ Need help on Resigned staffs statistic

Dear Priyanka, Thank you for the interest shown. Please find attached the example of what I required. On Fri, Jan 20, 2012 at 1:12 PM, PrIyAnKa wrote: > Dear Sunita > > Kindly give one example of what u want in your sheet as to study the data > and analyse the same and preparing format as per

Re: $$Excel-Macros$$ Save As today date

Try this: Below Code will popup an input box for you to enter the path of the file and name and then it will automatically append the todays name and save it as your given location. - ThisWorkbook.SaveAs InputBox("Enter the Path") & Day(Now) & "-" & Month(N

Re: $$Excel-Macros$$ Hidden file

Dear Neeraj Kindly visit below link http://www.sevenforums.com/tutorials/56005-file-folder-hide-unhide.html On Fri, Jan 20, 2012 at 12:29 PM, Neeraj Chauhan wrote: > Dear sir, > > ** ** > > Kindly see the attached screen shot. The file is hidden. > > I want to unhide the file. >

Re: $$Excel-Macros$$ EXCEL - TIPS

Thanks Noorain for such excel file On Fri, Jan 20, 2012 at 11:20 AM, NOORAIN ANSARI wrote: > Dear Kishore, > > You can study attached Ebook step by step.. > It will help you to learn excel. > > > - > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/*

Re: $$Excel-Macros$$ Need help on Resigned staffs statistic

Dear Sunita Kindly give one example of what u want in your sheet as to study the data and analyse the same and preparing format as per your requirement takes a lot time So kindly provide one output example in output format 2012/1/20 सुनिता पौडेल > Dear all, > > Can you please help me on resign

Re: $$Excel-Macros$$ FW: Hidden file

Dear Neeraj, We are unable to open your attached file. Please resend. On Fri, Jan 20, 2012 at 12:51 PM, Neeraj Chauhan wrote: > Dear all > > File is also attached kindly see. > > ** ** > > ** ** > > [image: Sign] > > ** ** > > *From:* Neeraj Chauhan [mailto:neerajchauhan...@gmail.

RE: $$Excel-Macros$$ for print dialog box in excel vba form

Try this : APplication.Dialogs(xlDialogPrint).show Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Shankar Bheema Sent: Jan/Wed/2012 04:52 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ for print dialog box in excel vba form D

$$Excel-Macros$$ Mr. Neeraj for this window u have to first go to the windows explorer and from that say Tools from menu there exactly u will find this....

Regards, Muneer, CC... From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Neeraj Chauhan Sent: Friday, January 20, 2012 9:59 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Hidden file Dear sir, Kind

Re: $$Excel-Macros$$ Save As today date

Dear Noorain, I have found some method. See if there needs improvement. **Code** Sub savemethod2() Dim todaydate As String, fileSaveName As String, driveloc As String, mth As String mth = Format(Date, "mm") todaydate = VBA.Format(DateSerial(Year(Date), mo

Re: $$Excel-Macros$$ Need looping in VB script

Sam, help me out On 1/20/12, yogananda muthaiah wrote: > Hi, > > i have 2 excels in desktop which needs to be looped. > > As explained below , not working properly. > > > Regards > Yogananda Muthaiah > > On Thu, Jan 19, 2012 at 9:32 PM, dguillett1 wrote: > >> >> Put inside a loop? >> >> for I =

Re: $$Excel-Macros$$ Save As today date

Dear Noorain, I try to use the code pasted here, however, run time error 1004. It may be due to the code highlight in red. What should the code be if I would like to have directory highlighted in red to be chosen by user? 2012/1/20 NOORAIN ANSARI > Dear Darwin, > > Your code is working fine, bu

$$Excel-Macros$$ Need help on Resigned staffs statistic

Dear all, Can you please help me on resigned staffs statistic? I need the information as below: the number of resigned staffs in 2006 and ratio of resigned staffs > male:female > Like wise till 2012 > Your help will be highly effective for my work. Regards, Sunita -- FORUM RULES (986+ mem

Re: $$Excel-Macros$$ Excel - Array Help

and plz explain the sum formula of counting unique records On Fri, Jan 20, 2012 at 6:50 AM, Sourabh Salgotra wrote: > Thank you so much sir, if we want without help. col > > > On Thu, Jan 19, 2012 at 11:35 PM, NOORAIN ANSARI > wrote: > >> Dear Sourabh, >> >> Please see attached sheet. >> >> >> -

Re: $$Excel-Macros$$ Need looping in VB script

Hi, i have 2 excels in desktop which needs to be looped. As explained below , not working properly. Regards Yogananda Muthaiah On Thu, Jan 19, 2012 at 9:32 PM, dguillett1 wrote: > > Put inside a loop? > > for I = 1 to 10 ‘howmany_? > > Set objExcel = CreateObject("Excel.Application")

Re: $$Excel-Macros$$ Save As today date

Dear Darwin, Your code is working fine, but need small correction... Please use below code... Sub savemethod() Dim todaydate As String Dim fileSaveName As String todaydate = VBA.Format(DateSerial(Year(Date), Month(Date), Day(Date)), "dd-mmm-") fileSaveName = Application.GetSaveAsFilename(

Re: $$Excel-Macros$$ Need help

Dear Rajesh Babu, Please attached sheet.. =VLOOKUP("*"&A2&"*",Sheet1!$A$1:$B$20,2,0) =INDEX(Sheet1!$B$1:$B$20,MATCH("*"&Sheet2!A2&"*",Sheet1!$A$1:$A$20,0)) -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blo

$$Excel-Macros$$ Save As today date

Dear group, I have written a macro for auto saving as today date excel file, however, when i save this, it refuses to save. I think that it turns DateSerial(Year(Date), Month(Date), Day(Date)) to be 20/01/2012, however, it treats me to create directory. What functions should I use to auto savin

$$Excel-Macros$$ Need help

Hi Team, Need help in using "vlookup & mid" funtion. Below are the details I have a excel workbook in which data is present in 2 sheets. Sheet1: - Column A is having unique ids which is having combination of text and numeric data and column B is having corresponding numeric values. Sheet2: - C

Re: $$Excel-Macros$$ EXCEL - TIPS

On Thu, Jan 19, 2012 at 3:54 PM, Sweet Kishore wrote: > Dear Friends, > > i got reply from your end thank your very much. > > Please explain how do .because i dont know knowledge in Excel. > > Kindly explain from basic onwards. > > > Regards, > > kishore > > > On Thu, Jan 19, 2012 at 11:0

$$Excel-Macros$$ Excellent Job Opportunity with Pubmatic India Pvt Ltd

Hi All, I would like to discuss an excellent career opportunity at Pubmatic, Pune. Please go through the job and company profile. *Title: Publisher Operations Specialist / Senior Publisher Operations Specialist * You will work as a key member of the Client Services team to provide support in th

Re: $$Excel-Macros$$ Excel - Array Help

Thank you so much sir, if we want without help. col On Thu, Jan 19, 2012 at 11:35 PM, NOORAIN ANSARI wrote: > Dear Sourabh, > > Please see attached sheet. > > > -- > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/* > *http://noorai

Re: $$Excel-Macros$$ Excel - Array Help

Dear Sourabh, Please see attached sheet. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Thu, Jan 19, 2012 at 10:45 PM, Sourabh Salgotra wrote: > * >

Re: $$Excel-Macros$$ Excel - Array Help

* * dear sir plz tell me that how i can these fourmula on multiple match like attachment. On Thu, Jan 19, 2012 at 2:42 PM, NOORAIN ANSARI wrote: > Dear Amar, > > Please use below formula to count total unique name > *=SUM(1/COUNTIF(B2:B6,B2:B6)) > *press ctrl+Shift+Enter > > or use this one to

Re: $$Excel-Macros$$ Re: Help On Print

Please excuse my delayed reply. I just tried running the code that you provided in the attachment above. The code seems to be absolutely fine. The only thing, that may have caused trouble, if you did not enter the dates in the correct format. Please ensure that you enter the date in the same format

Re: $$Excel-Macros$$ EXCEL - TIPS

Dear Friends, i got reply from your end thank your very much. Please explain how do .because i dont know knowledge in Excel. Kindly explain from basic onwards. Regards, kishore On Thu, Jan 19, 2012 at 11:00 AM, NOORAIN ANSARI wrote: > > Dear Kishor, > > Please find attachment as per

Re: $$Excel-Macros$$ Need looping in VB script

Put inside a loop? for I = 1 to 10 ‘howmany_? Set objExcel = CreateObject("Excel.Application") Set objWorkbook = objExcel.Workbooks.Open("C:\Users\Sam\Desktop\DelAllRowsExcelA”& I &”.xls") for each wks in objworkbook.worksheets wks.Range("A2", wks.UsedRange.SpecialCells(11

Re: $$Excel-Macros$$ Need looping in VB script

Dear Sam, Please refer mail below where successful VB script done by you Now new challenge is in desktop as 2 excel Example : C:\Users\Sam\Desktop\DelAllRowsExcelA1.xls C:\Users\Sam\Desktop\DelAllRowsExcelA2.xls how to do loop in vb script ? Set objExcel = CreateObject("E

Re: $$Excel-Macros$$ Re: Help On Print

Dear Rohan very very thanks please let me know where I did mistake Regards Shrinivas On Mon, Jan 16, 2012 at 9:55 PM, Sam Mathai Chacko wrote: > Here's how you do it. > > Regards, > Sam Mathai Chacko > > On Mon, Jan 16, 2012 at 12:26 PM, Shrinivas Shevde < > shrinivas...@gmail.com> wrote: > >> D

Re: $$Excel-Macros$$ Copy data from excelsheet to html file

Hi Noorain seth, Thank you for the reply. I do not have any specific sheet. for example if one sheet with 1000 rows and every row has five cells with data "1. Name, 2. Address, 3. pin code and 4. Mob #". and i need to fill one web based form (like creating email ID) with this data. so can we crea

Re: $$Excel-Macros$$ Excel - Array Help

Hi Noorain, Thank you for the code, I think I'm getting some clue for my code, I'll try and let you know, thanks again. Best regards, Amar On 19/01/2012, NOORAIN ANSARI wrote: > Dear Amar, > > Please try it.. > > Sub Find_Duplicate_Entry() > Dim cel As Variant > Dim myrng As Range > Set myrng =

Re: $$Excel-Macros$$ Excel - Array Help

Dear Amar, Please try it.. Sub Find_Duplicate_Entry() Dim cel As Variant Dim myrng As Range Set myrng = Range("C2:C" & Range("C65536").End(xlUp).Row) myrng.Interior.ColorIndex = xlNone For Each cel In myrng clr = 10 If Application.WorksheetFunction.CountIf(myrng, cel) > 1 Then cel.Interior.ColorI

Re: $$Excel-Macros$$ Excel - Array Help

Hi Noorain, Thank you for these formulaes. but I'm actually using VBA macro's to do a task it'll be really great if you could let me know in VBA. Here is my current code, I don't know I'm not able to highlight the duplicates. Sub Test1() For J1 = 10 To 500 If Cells(J1, 1).Value = "XYZ"

Re: $$Excel-Macros$$ Excel - Array Help

Dear Amar, Please use below formula to count total unique name *=SUM(1/COUNTIF(B2:B6,B2:B6)) *press ctrl+Shift+Enter or use this one to check unique or Duplicate Entry. *=IF(COUNTIF($B$2:B2,B2)>1,"Duplicate","Unique") * see attached sheet.. -- Thanks & regards, Noorain Ansari

$$Excel-Macros$$ Excel - Array Help

Hi Experts, I'm facing a problem in identifying duplicate names in a column. Here is what I'm looking for. If there are duplicates in column A i.e. A1 = Amar A2= Vijay A3 = Suresh A4 = Ravi A5 = Amar Then I would like to interior color A1 and A5 as they are duplicates, I would like to use the