$$Excel-Macros$$ Help in creating macro to identify number of people birthday on particular day in a month

2013-12-12 Thread Reyn
Hi Everyone, I would appreciate your help on this. I'm currently learning how to create simple macro but couldn't get my head this one. Basically I just want to identify the number of people with the same birthdates as seen below. Using excel formula for this is possible but I want to know ho

$$Excel-Macros$$ Conditional Format

2013-12-12 Thread Troy Nieto
I want to display in E8 "Complete" if D8 has a strikthrough format in the cell, otherwise leave it blank -- 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 R

$$Excel-Macros$$ Re: Please provide the code for data entry as mentioned in excel

2013-12-12 Thread Michael Paul
Add these codes: [code] Private Sub UserForm_Activate() Dim AlphaInSlNo As String Dim NumInSlNo As String Dim LenSLNo As Integer Dim NewSlNo As String Sheets("VolunteerList").Select LastRecNum = Cells(Rows.Count, "a").End(xlUp).Row 'to go to last data cell inspite of blank cells Range("A" &

$$Excel-Macros$$ Re: Excel Forum available @ discussexcel.com

2013-12-12 Thread manoj kumar
> Dear members, > I want to know the excel formula's becoz write now i am making the > excel database if you have the information plz send me the excel > formula's.on my email id manoj3...@gmail.com > > Thanks for your active participation in the group. Feel free to write > bac