RE: $$Excel-Macros$$ Help Required

Thanks sir!! From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Saleem Ansari Sent: Thursday, January 14, 2016 4:05 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help Required PFA On Thu, Jan 14, 2016 at 3:56 PM, Neeraj Chauhan

$$Excel-Macros$$ Re: Student attendance

Check this out I have extended your date to 1 to 15 as instructed Regards, Mandeep baluja Sub Fill_Absents() Dim workrngNE As Range Dim workrngPE As Range Dim workrngSS As Range Dim Datasheet As Worksheet Dim Nrows As Long Application.ScreenUpdating = False Set ws = Sheets("Consolidated at

Re: $$Excel-Macros$$ Re: Help Required

> > Your Date is not date but to convert a date to number you can simply > multiply it with one this scenario works most of the cases but not for all. > For Example your date is in A1 put formula in b1 = A1*1 Regards, Mandeep baluja ticket closed -- Are you =EXP(E:RT) or =NOT(EXP(E:RT))

Re: $$Excel-Macros$$ Sorting Comma Separated Values in a cell

Hi Mandeep, Please revert. On Thu, Jan 14, 2016 at 5:37 PM, Devendra Sahay < devendrasahanypt...@gmail.com> wrote: > Hi, > > I dont want to sort column a, I want to sort the comma separated data > alphabetically & numerically in column 2. > > but the code which i have shared, it shorts the dat

RE: $$Excel-Macros$$ Re: Help Required

Dear sir I cannot understand kindly brief/example From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Mandeep Baluja Sent: Thursday, January 14, 2016 6:15 PM To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ Re: Help Required Multiply date wi

Re: $$Excel-Macros$$ Custom view change automatically after time set

Change the code to this: Private Sub Workbook_Open() ActiveWorkbook.CustomViews("TODAY'S BIRTHDAY").Show Application.Wait (Now + TimeValue("00:00:10")) ActiveWorkbook.CustomViews("ALL PERSONS").Show End Sub Change the highlighted time delay as per your need. On Fri, Jan 15, 2016 at 8:52 AM, b

$$Excel-Macros$$ Custom view change automatically after time set

Yes thanks a lot it works nicely Now i can do the same thing in other files too I really appreciate & thanks to have a such group. I am learning excel in details so i may have lot of queries too Even i have ask is there any course available in Mumbai then please let me know . I always think cr

$$Excel-Macros$$ Client in Houston TX need SAP Business Warehouse Developer

Hi Partner, Hope you are doing great … Please send resume to ma...@genuineitllc.com *Title :SAP BW Developer.* *All relevant experience must be detailed in the job responsibilities sections under each project. * *Client:* *Confidential at client’s request. Client will be disclosed once ca

$$Excel-Macros$$ Client in Toronto, ON need Business Transformation Specialist

Hi Partner, Hope you are doing great … Please send resume to ma...@genuineitllc.com *Title: **Business Transformation Specialist * *Location: **Toronto, ON* *Duration: 6+ Months* *REQUIREMENTS* Scope of Services and Deliverables - The Services and Deliverables to be provided by the consu

Re: $$Excel-Macros$$ Combined Output

Thank you. On Jan 8, 2016 7:57 PM, "Veera" wrote: > Dear Experts, > > PFA the scenario. > > Please provide solution for that scenario > > Regards, > Veera > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of

$$Excel-Macros$$ Student attendance

Dear all, Can someone help me with a attendance spreadsheet. I am attaching a sample spreadsheet. https://goo.gl/qL0eGx My requirement is that by entering the absentee roll nos in the Data entry sheet will mark those roll nos as absent in the consolidated attendance sheet. While the remaining st

Re: $$Excel-Macros$$ Re: Help Required

Multiply date with 1 On Thursday, January 14, 2016 at 5:54:19 PM UTC+5:30, neeraj chauhan wrote: > > Dear sir, > > > > Thanks sir !! > > Kindly share the formula. > > > > *From:* excel-...@googlegroups.com [mailto: > excel-...@googlegroups.com ] *On Behalf Of *Mandeep Baluja > *Sent:* Thursda

RE: $$Excel-Macros$$ Re: Help Required

Dear sir, Thanks sir !! Kindly share the formula. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Mandeep Baluja Sent: Thursday, January 14, 2016 4:50 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Re: Help Required PFA !! Ticket close

Re: $$Excel-Macros$$ Sorting Comma Separated Values in a cell

Hi, I dont want to sort column a, I want to sort the comma separated data alphabetically & numerically in column 2. but the code which i have shared, it shorts the data of column a & b both, So all the data shuffled This is the required format of the data. Col 1Col 2 A10,15,

Re: $$Excel-Macros$$ Sorting Comma Separated Values in a cell

Hey Devendra, Asked for output format? your query is not understandable. data shuffled all the data ??, Show me the output you require for this data given below :- Col 1Col 2 A10,8year,5 year,15 B15,20year,17 D30,50 year,12 -- Are you =EXP(E

Re: $$Excel-Macros$$ Sorting Comma Separated Values in a cell

Hi Mandeep, Please check the attached sample of data with the headers. On Thu, Jan 14, 2016 at 3:49 PM, Mandeep Baluja wrote: > Didn't get what is ref.name ??? Didn't find it anywhere in your data,Will >> it be possible if you share the output required format. >> > > Regards, > Mandeep baluja >

Re: $$Excel-Macros$$ Help Required

> > > multiply it by 1 simply !! Regards,Mandeep -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor th

$$Excel-Macros$$ Re: Help Required

> > PFA !! Ticket closed > Regards, Mandeep baluja -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor

Re: $$Excel-Macros$$ Help Required

PFA On Thu, Jan 14, 2016 at 3:56 PM, Neeraj Chauhan wrote: > Dear Experts. > > > > I want change Date Format > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussex

$$Excel-Macros$$ Help Required

Dear Experts. I want change Date Format -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titl

$$Excel-Macros$$ Re: combine 2 excel workbook using macros selecting only selected rows

Does output sheet created for each Pref value given below ?? if yes are these sheets created in same workbook with Pref name if not, means you need only one sheet for pref 10001 ? Regards, Mandeep Baluja Pref 1001 1002 1005 1007 1009 1005 25000 151233 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT))

Re: $$Excel-Macros$$ Sorting Comma Separated Values in a cell

> > Didn't get what is ref.name ??? Didn't find it anywhere in your data,Will > it be possible if you share the output required format. > Regards, Mandeep baluja -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of

Re: $$Excel-Macros$$ Combined Output

Put the below formulae in cell f2 then drag it till 10 rows =CONCATENATE($A$1,":",A2,";",$B$1,":",B2,";",$C$1,":",C2,";",$D$1,":",D2," ",E2) On Fri, Jan 8, 2016 at 7:57 PM, Veera wrote: > Dear Experts, > > PFA the scenario. > > Please provide solution for that scenario > > Regards, > Veera > >