date:20140908

Re: $$Excel-Macros$$ Need a Macro to find Variable Cost

2014-09-08 Thread Mahesh Patil

Hi,
PFA


On Mon, Sep 8, 2014 at 2:52 PM, Shaik Waheed  wrote:

> Hi friends,
>
> I need your help to create a macro, its motive is to find out the variable
> cost of physicians >4000.
>
> Attached is the sample data for your reference.
>
> Thanks in advance.
>
> Waheed
>
> --
> 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 titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Macro_Variable Cost .xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ Need help with time sheet

2014-09-08 Thread Ujjwal Desai

Hi Pramod,

It's not giving me for each row.

Also if possible can we have the hr time to 0 as compared to hh:mm:ss it is
giving by default to 12.

Thanks,
Ujjwal
On Sep 9, 2014 8:43 AM, "Pramod Singh"  wrote:

> Hi Ujjwal...
>
> PFA.
>
> On Tue, Sep 9, 2014 at 1:09 AM, Ujjwal Desai  wrote:
>
>> Hello ,
>>
>> I need your help in regards with the attached timesheet.
>>
>> 1.The Time should be captured for each row separately.
>> 2.Reset tab vba code is not working properly.
>>
>> Please provide your inputs.
>>
>> Thanks,
>> Ujjwal
>>
>>  --
>> 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 titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
>
> --
> *PramodSingh*
>
> --
> 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 titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to a topic in the
> Google Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/excel-macros/fictTDZTXUU/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Need help with time sheet

2014-09-08 Thread Pramod Singh

Hi Ujjwal...

PFA.

On Tue, Sep 9, 2014 at 1:09 AM, Ujjwal Desai  wrote:

> Hello ,
>
> I need your help in regards with the attached timesheet.
>
> 1.The Time should be captured for each row separately.
> 2.Reset tab vba code is not working properly.
>
> Please provide your inputs.
>
> Thanks,
> Ujjwal
>
>  --
> 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 titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>



-- 
*PramodSingh*

-- 
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 titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Timesheet.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

$$Excel-Macros$$ Re: Input data from userform into 2 sheets. 2nd sheet would be by matching header

2014-09-08 Thread Mr_Bill

Sample workbook if help to get the answer for this
https://www.dropbox.com/s/9ea1r3wfe24oav7/example%20workbook.xlsm?dl=0

On Monday, September 8, 2014 6:47:13 AM UTC-7, Mr_Bill wrote:
>
> I currently have a userform that works perfectly with the first sheet and 
> dont want to change that. What I would like to do is add one of the pieces 
> of data into a 2nd sheet that has a different layout. It would be something 
> like this
>
>
> *Classwork * 
> *Drafts * 
> *Records * 
> *Portfolio * 
> *Final * 98% 78% 23% 98% 0% 78% 23% 78% 78% 
>  78% 89% 0% 78% 
>  23% 23% 78% 23% 
>  23% 98% 98% 
>
>
> Each of these columns is named the same as the headers. In my form I would 
> like for it to input as it is now in sheet1 (GradeBook) and for Sheet2 I 
> would like for the grade only to be input into sheet2. Somehow it would 
> need to match the correct column using the assignment name given using a 
> combobox in the form. Here is the main part of the script for the info 
> input.
>
>> Private Sub cmdSubmit_Click()
>> Application.ScreenUpdating = False
>> Dim NextRw As Long
>> Dim ws As Worksheet
>> Dim startRow As Long
>> Dim CelFormat As String
>>
>> Set ws = Courses
>> NextRw = ws.Cells(Rows.Count, 1).End(xlUp).Offset(2, 0).Row
>> If NextRw < 6 Then NextRw = 6
>> '<< Add data to worksheet >>
>> ws.Cells(NextRw + 0, "A") = Me.txtAssignmentName.Value
>> ws.Cells(NextRw + 1, "A") = Me.txtDate.Value
>> ws.Cells(NextRw + 1, "A") = "Due: " & Me.txtDate.Value
>> ws.Cells(NextRw + 2, "A") = Me.txtAssignmentType.Value
>> If (Me.txtPointsReceived.Value & "X" = "X") Then
>> ws.Cells(NextRw + 0, "D").Value = "-"
>> Else
>> If InStr(1, txtPointsReceived, "%") = 0 Then   'and if 
>> txtAssignmentName.value matches sheets2 column name insert grade in next 
>> open cell that column starting at @ row3
>> CelFormat = "0.00"
>> Else
>> CelFormat = "0.00%"
>> End If
>> With ws.Cells(NextRw + 0, "D")
>> .NumberFormat = CelFormat
>> .Value = Me.txtPointsReceived.Value
>> End With
>> End If
>> If InStr(1, txtPointsPossible, "%") = 0 Then
>> CelFormat = """/"" 0.00"
>> Else
>> CelFormat = """/"" 0.00%"
>> End If
>> With ws.Cells(NextRw + 0, "E")
>> .NumberFormat = CelFormat
>> .Value = Me.txtPointsPossible.Value
>> End With
>>
>> Unload Me
>> End Sub
>>
>>
>
>
>
>
>
>
> I have also edited the combobox so it populates using the headers in row1 of 
> sheet2 (WeightedPage) if that helps at all.
>
> Sub UserForm_Initialize()
>> Dim rheadings As Range
>> Dim cl As Range
>> Set rheadings = Sheets("WeightedPage").Range("A1:I1")
>> For Each cl In rheadings
>> Me.txtAssignmentType.Value = "Assignment"
>> Me.txtAssignmentType.AddItem cl.Value
>> Next cl
>> End Sub
>>
>
>

-- 
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 titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Need help with time sheet

2014-09-08 Thread Ujjwal Desai

Hello ,

I need your help in regards with the attached timesheet.

1.The Time should be captured for each row separately.
2.Reset tab vba code is not working properly.

Please provide your inputs.

Thanks,
Ujjwal

-- 
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 titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Timesheet.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ Error in Filtering Data using VBA

2014-09-08 Thread Vaibhav Joshi

Hi

FA,

cheers!!

+
*I did not do this for you. God is here working through me for you.*

On Sun, Sep 7, 2014 at 11:54 PM, Nitin Balodi  wrote:

> Hi Experts,
>
> I am applying filter using VBA where I need to filter data for next three
> months basis current date for excample, today is 07-September-2014, then
> applying filter select data from 01-Oct-2014 to 31-December-2014. I have
> written the below code but it is not returning output:
>
> sdate = Application.WorksheetFunction.EoMonth(Now(), 0) + 1
> edate = Application.WorksheetFunction.EoMonth(Now(), 3)
>
> ActiveSheet.Range("$A$1:$M$1").AutoFilter Field:=11, Criteria1:= _
> ">=" & sdate, Operator:=xlAnd, Criteria2:="<=" & edate
>
> Sample Data Sheet is attached for your reference with code.
>
> Please advise.
>
> Regards.
>
> Yours Sincerely,
> *Nitin Balodi*
>
> --
> 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 titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


sort Data.xlsb
Description: application/vnd.ms-excel.sheet.binary.macroenabled.12

Re: $$Excel-Macros$$ Need a Macro to find Variable Cost

2014-09-08 Thread Vaibhav Joshi

Hi

Click blue button to run macro..

Cheers!!

+
*I did not do this for you. God is here working through me for you.*

On Mon, Sep 8, 2014 at 2:52 PM, Shaik Waheed  wrote:

> Hi friends,
>
> I need your help to create a macro, its motive is to find out the variable
> cost of physicians >4000.
>
> Attached is the sample data for your reference.
>
> Thanks in advance.
>
> Waheed
>
> --
> 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 titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Macro ph cost.xlsb
Description: application/vnd.ms-excel.sheet.binary.macroenabled.12

Re: $$Excel-Macros$$ Variable not defined, No able to figure out how to define this one.

2014-09-08 Thread Vaibhav Joshi

Hi

add below line  after Dim startRow As Long:

Dim CelFormat As String

Cheers!!
+
*I did not do this for you. God is here working through me for you.*

On Sun, Sep 7, 2014 at 9:16 PM, Mr_Bill  wrote:

> Have a small code that keeps returning a compile error will highlight the
> trouble area hopefully someone can tell me what im doing wrong
>
> Private Sub cmdSubmit_Click()
>> Application.ScreenUpdating = False
>> Dim NextRw As Long
>> Dim ws As Worksheet
>> Dim startRow As Long
>>
>>
>> Set ws = Courses
>> NextRw = ws.Cells(Rows.Count, 1).End(xlUp).Offset(2, 0).Row
>> If NextRw < 6 Then NextRw = 6
>>  '<< Add data to worksheet >>
>> ws.Cells(NextRw + 0, "A") = Me.txtAssignmentName.Value
>> ws.Cells(NextRw + 1, "A") = Me.txtDate.Value
>> ws.Cells(NextRw + 2, "A") = Me.txtAssignmentType.Value
>> If (Me.txtPointsReceived.Value & "X" = "X") Then
>>   ws.Cells(NextRw + 0, "D").Value = "-"
>> Else
>>   If InStr(1, txtPointsReceived, "%") = 0 Then
>> CelFormat = "0.00"
>>   Else
>> CelFormat = "0.00%"
>>   End If
>>   With ws.Cells(NextRw + 0, "D")
>> .NumberFormat = CelFormat
>> .Value = Me.txtPointsReceived.Value
>>   End With
>> End If
>> If InStr(1, txtPointsPossible, "%") = 0 Then
>>   CelFormat = """/"" 0.00"
>> Else
>>   CelFormat = "0.00%"
>> End If
>> With ws.Cells(NextRw + 0, "E")
>>   .NumberFormat = CelFormat
>>   .Value = Me.txtPointsPossible.Value
>> End With
>>
>>  Unload Me
>> End Sub
>>
>
>
> How do I define the CelFormat part of this?
>
> --
> 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 titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Input data from userform into 2 sheets. 2nd sheet would be by matching header

2014-09-08 Thread Mr_Bill

I currently have a userform that works perfectly with the first sheet and 
dont want to change that. What I would like to do is add one of the pieces 
of data into a 2nd sheet that has a different layout. It would be something 
like this


*Classwork * 
*Drafts * 
*Records * 
*Portfolio * 
*Final * 98% 78% 23% 98% 0% 78% 23% 78% 78% 
 78% 89% 0% 78% 
 23% 23% 78% 23% 
 23% 98% 98% 


Each of these columns is named the same as the headers. In my form I would 
like for it to input as it is now in sheet1 (GradeBook) and for Sheet2 I 
would like for the grade only to be input into sheet2. Somehow it would 
need to match the correct column using the assignment name given using a 
combobox in the form. Here is the main part of the script for the info 
input.

> Private Sub cmdSubmit_Click()
> Application.ScreenUpdating = False
> Dim NextRw As Long
> Dim ws As Worksheet
> Dim startRow As Long
> Dim CelFormat As String
>
> Set ws = Courses
> NextRw = ws.Cells(Rows.Count, 1).End(xlUp).Offset(2, 0).Row
> If NextRw < 6 Then NextRw = 6
> '<< Add data to worksheet >>
> ws.Cells(NextRw + 0, "A") = Me.txtAssignmentName.Value
> ws.Cells(NextRw + 1, "A") = Me.txtDate.Value
> ws.Cells(NextRw + 1, "A") = "Due: " & Me.txtDate.Value
> ws.Cells(NextRw + 2, "A") = Me.txtAssignmentType.Value
> If (Me.txtPointsReceived.Value & "X" = "X") Then
> ws.Cells(NextRw + 0, "D").Value = "-"
> Else
> If InStr(1, txtPointsReceived, "%") = 0 Then   'and if 
> txtAssignmentName.value matches sheets2 column name insert grade in next open 
> cell that column starting at @ row3
> CelFormat = "0.00"
> Else
> CelFormat = "0.00%"
> End If
> With ws.Cells(NextRw + 0, "D")
> .NumberFormat = CelFormat
> .Value = Me.txtPointsReceived.Value
> End With
> End If
> If InStr(1, txtPointsPossible, "%") = 0 Then
> CelFormat = """/"" 0.00"
> Else
> CelFormat = """/"" 0.00%"
> End If
> With ws.Cells(NextRw + 0, "E")
> .NumberFormat = CelFormat
> .Value = Me.txtPointsPossible.Value
> End With
>
> Unload Me
> End Sub
>
>






I have also edited the combobox so it populates using the headers in row1 of 
sheet2 (WeightedPage) if that helps at all.

Sub UserForm_Initialize()
> Dim rheadings As Range
> Dim cl As Range
> Set rheadings = Sheets("WeightedPage").Range("A1:I1")
> For Each cl In rheadings
> Me.txtAssignmentType.Value = "Assignment"
> Me.txtAssignmentType.AddItem cl.Value
> Next cl
> End Sub
>

-- 
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 titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Re: Invitation to the Excel Modeling World Championships 2014

2014-09-08 Thread Ashish Kumar

Hi Saleem,

Check the information link which is provided by Vaibhav Sir. Hope you find
your answer.


Regards
Ashish

-- 
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 titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Need a Macro to find Variable Cost

2014-09-08 Thread Shaik Waheed

Hi friends,

I need your help to create a macro, its motive is to find out the variable
cost of physicians >4000.

Attached is the sample data for your reference.

Thanks in advance.

Waheed

-- 
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 titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Macro.xlsx
Description: MS-Excel 2007 spreadsheet

$$Excel-Macros$$ Re: Categorise A,B,C,

2014-09-08 Thread 'Sleek' via MS EXCEL AND VBA MACROS

No no, 
Ashit, it is giving me values from the table, 
I want it to give A,B, C , D..

On Sunday, September 7, 2014 11:45:57 AM UTC+3, Sleek wrote:
>
> i need to place A,B,C,D, E or F in column D to to be picked from table at 
> right.
> A macro or formula could help.
>
>

-- 
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 titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Re: Invitation to the Excel Modeling World Championships 2014

2014-09-08 Thread Saleem Ansari

Please Reply Fast,








Thanks & Regards?
   
**
*Saleem Ansari*

*Logicash Solutions Pvt. Ltd.*
*A-79| Sector-4| Noida| Gautam Budh Nagar (U.P) 201301*

*Email Id :-* *saleem.logic...@gmail.com *

*Mobile : - +91 7840096219*



The information in this email is confidential and may be legally
privileged. It is intended solely for the addressee. Access to this email
by anyone else is unauthorized. If you are not the intended recipient, any
disclosure, copying, distribution or any action taken or committed to be
taken in reliance on it, is prohibited and may be unlawful.

Please consider the environment before printing this e-mail

*पेड़ बचाएँ*  *पर्यावरण बचाएँ*

[image: Description: cid:image003.gif@01CCD1FE.E699F6D0]*"Go Green, Save
Earth"**?*

*[image: Untitled]*

On Mon, Sep 8, 2014 at 12:58 PM, Vaibhav Joshi  wrote:

> Refer this thread & do not reply om this email/ thread:
>
> https://groups.google.com/d/msg/excel-macros/W_4PZEeQV88/7Zk8SUpNFhAJ
>
> Cheers!!
>
> +
> *I did not do this for you. God is here working through me for you.*
>
> On Mon, Sep 8, 2014 at 12:26 PM, Saleem Ansari 
> wrote:
>
>> Waiting For Reply ,
>>
>>
>>
>> Thanks & Regards?
>>
>> **
>> *Saleem Ansari*
>>
>> *Logicash Solutions Pvt. Ltd.*
>> *A-79| Sector-4| Noida| Gautam Budh Nagar (U.P) 201301*
>>
>> *Email Id :-* *saleem.logic...@gmail.com *
>>
>> *Mobile : - +91 7840096219*
>>
>>
>>
>> The information in this email is confidential and may be legally
>> privileged. It is intended solely for the addressee. Access to this email
>> by anyone else is unauthorized. If you are not the intended recipient, any
>> disclosure, copying, distribution or any action taken or committed to be
>> taken in reliance on it, is prohibited and may be unlawful.
>>
>> Please consider the environment before printing this e-mail
>>
>> *पेड़ बचाएँ*  *पर्यावरण बचाएँ*
>>
>> [image: Description: cid:image003.gif@01CCD1FE.E699F6D0]*"Go Green, Save
>> Earth"**?*
>> 
>> *[image: Untitled]*
>>
>> On Mon, Sep 8, 2014 at 12:03 PM, Saleem Ansari > > wrote:
>>
>>> Dear,
>>>
>>> How to convert number to word without VBA Program Only Excel Formula,
>>>
>>> Please Reply Fast,,,
>>>
>>>  
>>>
>>>
>>>
>>> Thanks & Regards?
>>>
>>> **
>>> *Saleem Ansari*
>>>
>>> *Logicash Solutions Pvt. Ltd.*
>>> *A-79| Sector-4| Noida| Gautam Budh Nagar (U.P) 201301*
>>>
>>> *Email Id :-* *saleem.logic...@gmail.com *
>>>
>>> *Mobile : - +91 7840096219*
>>>
>>>
>>>
>>> The information in this email is confidential and may be legally
>>> privileged. It is intended solely for the addressee. Access to this email
>>> by anyone else is unauthorized. If you are not the intended recipient, any
>>> disclosure, copying, distribution or any action taken or committed to be
>>> taken in reliance on it, is prohibited and may be unlawful.
>>>
>>> Please consider the environment before printing this e-mail
>>>
>>> *पेड़ बचाएँ*  *पर्यावरण बचाएँ*
>>>
>>> [image: Description: cid:image003.gif@01CCD1FE.E699F6D0]*"Go Green,
>>> Save Earth"**?*
>>> 
>>> *[image: Untitled]*
>>>
>>> On Mon, Sep 8, 2014 at 12:01 PM, Vaibhav Joshi  wrote:
>>>
 Hi Saleem,

 You are not following rule set, i you have not read rules ple read &
 start new thread:

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners
 and members are not responsible for any loss.

 +
 *I did not do this for you. God is here working through me for you.*

 On Mon, Sep 8, 2014 at 11:44 AM, Saleem Ansari <
 saleem.logic...@gmail.com> wrote:

> Hello Mr,
>
> without VBA ok
>
> Only For Excel Formula,Ok
> So Please Revised ,,
>
>
>
> Thanks & Regards?
>
> **
> *Saleem Ansari*
>
> *Logicash Solutions Pvt. Ltd.*
> *A-79| Sector-4| Noida| Gautam Budh Nagar (U.P) 201301*
>
> *Email Id :-* *saleem.logic...@gmail.com *
>
> *Mobile : - +91 7840096219*
>
>
>
> The information in this email is confidential and may be legally
> privileged. It is intended solely for the addressee. Access to this email
> by anyone else is unauthorized. If you are not the intended recipient, any
> disclosure, copying, distribution or any action taken or committed to be
> taken in reliance on it, is prohibited and may be unlawful.
>
> Please consider the environment before printing this e-mail
>
> *पेड़

Re: $$Excel-Macros$$ Number to Text Indiann rupee format using formula no add ins & UDF

2014-09-08 Thread Prafull Jadhav

Dear Vaibhavji,
Great!


Regards,
Prafull Jadhav
9920553518

On 8 September 2014 12:55, Vaibhav Joshi  wrote:

> FA, It works upto 99 crore, you can modify to extend further.
>
> Cheers!!
>
> +
> *I did not do this for you. God is here working through me for you.*
>
> On Mon, Sep 8, 2014 at 12:03 PM, Saleem Ansari 
> wrote:
>
>> Dear,
>>
>> How to convert number to word without VBA Program Only Excel Formula,
>>
>> Please Reply Fast,,,
>>
>>  
>>
>>
>>
>> Thanks & Regards?
>>
>> **
>> *Saleem Ansari*
>>
>> *Logicash Solutions Pvt. Ltd.*
>> *A-79| Sector-4| Noida| Gautam Budh Nagar (U.P) 201301*
>>
>> *Email Id :-* *saleem.logic...@gmail.com *
>>
>> *Mobile : - +91 7840096219*
>>
>>
>>
>> The information in this email is confidential and may be legally
>> privileged. It is intended solely for the addressee. Access to this email
>> by anyone else is unauthorized. If you are not the intended recipient, any
>> disclosure, copying, distribution or any action taken or committed to be
>> taken in reliance on it, is prohibited and may be unlawful.
>>
>> Please consider the environment before printing this e-mail
>>
>> *पेड़ बचाएँ*  *पर्यावरण बचाएँ*
>>
>> [image: Description: cid:image003.gif@01CCD1FE.E699F6D0]*"Go Green, Save
>> Earth"**?*
>> 
>> *[image: Untitled]*
>>
>> On Mon, Sep 8, 2014 at 12:01 PM, Vaibhav Joshi  wrote:
>>
>>> Hi Saleem,
>>>
>>> You are not following rule set, i you have not read rules ple read &
>>> start new thread:
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>>
>>> +
>>> *I did not do this for you. God is here working through me for you.*
>>>
>>> On Mon, Sep 8, 2014 at 11:44 AM, Saleem Ansari <
>>> saleem.logic...@gmail.com> wrote:
>>>
 Hello Mr,

 without VBA ok

 Only For Excel Formula,Ok
 So Please Revised ,,



 Thanks & Regards?

 **
 *Saleem Ansari*

 *Logicash Solutions Pvt. Ltd.*
 *A-79| Sector-4| Noida| Gautam Budh Nagar (U.P) 201301*

 *Email Id :-* *saleem.logic...@gmail.com *

 *Mobile : - +91 7840096219*



 The information in this email is confidential and may be legally
 privileged. It is intended solely for the addressee. Access to this email
 by anyone else is unauthorized. If you are not the intended recipient, any
 disclosure, copying, distribution or any action taken or committed to be
 taken in reliance on it, is prohibited and may be unlawful.

 Please consider the environment before printing this e-mail

 *पेड़ बचाएँ*  *पर्यावरण बचाएँ*

 [image: Description: cid:image003.gif@01CCD1FE.E699F6D0]*"Go Green,
 Save Earth"**?*
 
 *[image: Untitled]*

 On Mon, Sep 8, 2014 at 11:20 AM, Sandeep Sharma <
 sandeepsharma4...@gmail.com> wrote:

> Dear
>
> PFA as per desired u
>
>
> With Regards
> Sandeep Kumar Sharma
>
> *“Always laugh when you can. It is cheap medicine.*”
>
> On Sun, Sep 7, 2014 at 6:16 AM, NOORAIN ANSARI <
> noorain.ans...@gmail.com> wrote:
>
>> Dear Saleem,
>>
>> Please find the attachment. hope it will help to you.
>> now you can convert number to word by excel formula or vba UDF.
>>
>>
>> On Sat, Sep 6, 2014 at 12:01 PM, Saleem Ansari <
>> saleem.logic...@gmail.com> wrote:
>>
>>> Dear Noorain SIr,
>>>
>>> Please Help,
>>>
>>> My Query ho to convert number to word
>>>
>>>
>>> Please Help Sir,,
>>>
>>>
>>>
>>>
>>>
>>>
>>> On Saturday, August 30, 2014 7:18:44 PM UTC+5:30, Ayush Jain wrote:

 Dear members,

 We’d like to invite members of the discussexcel.com community to
 the annual Excel and Financial Modeling World Championship 2014 Event 
 (*ModelOff,
 www.modeloff.com *). The Advanced Excel
 educational competition helps celebrate Excel in Financial Services. 
 The
 fun, challenging and innovative competition has a mission to inspire 
 skill
 development with Microsoft Excel, Financial Modeling and Financial 
 Analysis
 which is central to global businesses and communities. The competition
 showcases some of the fastest, hard-working and talented Excel minds 
>

Re: $$Excel-Macros$$ Re: Invitation to the Excel Modeling World Championships 2014

2014-09-08 Thread Vaibhav Joshi

Refer this thread & do not reply om this email/ thread:

https://groups.google.com/d/msg/excel-macros/W_4PZEeQV88/7Zk8SUpNFhAJ

Cheers!!

+
*I did not do this for you. God is here working through me for you.*

On Mon, Sep 8, 2014 at 12:26 PM, Saleem Ansari 
wrote:

> Waiting For Reply ,
>
>
>
> Thanks & Regards?
>
> **
> *Saleem Ansari*
>
> *Logicash Solutions Pvt. Ltd.*
> *A-79| Sector-4| Noida| Gautam Budh Nagar (U.P) 201301*
>
> *Email Id :-* *saleem.logic...@gmail.com *
>
> *Mobile : - +91 7840096219*
>
>
>
> The information in this email is confidential and may be legally
> privileged. It is intended solely for the addressee. Access to this email
> by anyone else is unauthorized. If you are not the intended recipient, any
> disclosure, copying, distribution or any action taken or committed to be
> taken in reliance on it, is prohibited and may be unlawful.
>
> Please consider the environment before printing this e-mail
>
> *पेड़ बचाएँ*  *पर्यावरण बचाएँ*
>
> [image: Description: cid:image003.gif@01CCD1FE.E699F6D0]*"Go Green, Save
> Earth"**?*
> 
> *[image: Untitled]*
>
> On Mon, Sep 8, 2014 at 12:03 PM, Saleem Ansari 
> wrote:
>
>> Dear,
>>
>> How to convert number to word without VBA Program Only Excel Formula,
>>
>> Please Reply Fast,,,
>>
>>  
>>
>>
>>
>> Thanks & Regards?
>>
>> **
>> *Saleem Ansari*
>>
>> *Logicash Solutions Pvt. Ltd.*
>> *A-79| Sector-4| Noida| Gautam Budh Nagar (U.P) 201301*
>>
>> *Email Id :-* *saleem.logic...@gmail.com *
>>
>> *Mobile : - +91 7840096219*
>>
>>
>>
>> The information in this email is confidential and may be legally
>> privileged. It is intended solely for the addressee. Access to this email
>> by anyone else is unauthorized. If you are not the intended recipient, any
>> disclosure, copying, distribution or any action taken or committed to be
>> taken in reliance on it, is prohibited and may be unlawful.
>>
>> Please consider the environment before printing this e-mail
>>
>> *पेड़ बचाएँ*  *पर्यावरण बचाएँ*
>>
>> [image: Description: cid:image003.gif@01CCD1FE.E699F6D0]*"Go Green, Save
>> Earth"**?*
>> 
>> *[image: Untitled]*
>>
>> On Mon, Sep 8, 2014 at 12:01 PM, Vaibhav Joshi  wrote:
>>
>>> Hi Saleem,
>>>
>>> You are not following rule set, i you have not read rules ple read &
>>> start new thread:
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>>
>>> +
>>> *I did not do this for you. God is here working through me for you.*
>>>
>>> On Mon, Sep 8, 2014 at 11:44 AM, Saleem Ansari <
>>> saleem.logic...@gmail.com> wrote:
>>>
 Hello Mr,

 without VBA ok

 Only For Excel Formula,Ok
 So Please Revised ,,



 Thanks & Regards?

 **
 *Saleem Ansari*

 *Logicash Solutions Pvt. Ltd.*
 *A-79| Sector-4| Noida| Gautam Budh Nagar (U.P) 201301*

 *Email Id :-* *saleem.logic...@gmail.com *

 *Mobile : - +91 7840096219*



 The information in this email is confidential and may be legally
 privileged. It is intended solely for the addressee. Access to this email
 by anyone else is unauthorized. If you are not the intended recipient, any
 disclosure, copying, distribution or any action taken or committed to be
 taken in reliance on it, is prohibited and may be unlawful.

 Please consider the environment before printing this e-mail

 *पेड़ बचाएँ*  *पर्यावरण बचाएँ*

 [image: Description: cid:image003.gif@01CCD1FE.E699F6D0]*"Go Green,
 Save Earth"**?*
 
 *[image: Untitled]*

 On Mon, Sep 8, 2014 at 11:20 AM, Sandeep Sharma <
 sandeepsharma4...@gmail.com> wrote:

> Dear
>
> PFA as per desired u
>
>
> With Regards
> Sandeep Kumar Sharma
>
> *“Always laugh when you can. It is cheap medicine.*”
>
> On Sun, Sep 7, 2014 at 6:16 AM, NOORAIN ANSARI <
> noorain.ans...@gmail.com> wrote:
>
>> Dear Saleem,
>>
>> Please find the attachment. hope it will help to you.
>> now you can convert number to word by excel formula or vba UDF.
>>
>>
>> On Sat, Sep 6, 2014 at 12:01 PM, Saleem Ansari <
>> saleem.logic...@gmail.com> wrote:
>>
>>> Dear Noorain SIr,
>>>
>>> Please Help,
>>>
>>> My Query ho to convert number to word
>>>
>>>
>>> Please Help Sir,,
>>>
>>>
>>>
>

Re: $$Excel-Macros$$ Macros get deleted

2014-09-08 Thread Prafull Jadhav

Dear Rupesh,
Have u open it with Enable Macro?
and also save it as it Macro Enable file...


Regards,
Prafull Jadhav
9920553518

On 8 September 2014 12:40, Rupesh Patil  wrote:

>
> Hello Experts
> I am using office 2013, when download any macro included workbook from
> this group macro get deleted when open this workbook. could any one why
> this happen.
>
> Thanks in advance 
>
> --
> Thanks & Regards,
> Rupesh Patil,
>
>
>  --
> 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 titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Macros get deleted

2014-09-08 Thread Rupesh Patil

Hello Experts
I am using office 2013, when download any macro included workbook from this
group macro get deleted when open this workbook. could any one why this
happen.

Thanks in advance 

-- 
Thanks & Regards,
Rupesh Patil,

-- 
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 titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Need a Macro to find Variable Cost

Re: $$Excel-Macros$$ Need help with time sheet

Re: $$Excel-Macros$$ Need help with time sheet

$$Excel-Macros$$ Re: Input data from userform into 2 sheets. 2nd sheet would be by matching header

$$Excel-Macros$$ Need help with time sheet

Re: $$Excel-Macros$$ Error in Filtering Data using VBA

Re: $$Excel-Macros$$ Need a Macro to find Variable Cost

Re: $$Excel-Macros$$ Variable not defined, No able to figure out how to define this one.

$$Excel-Macros$$ Input data from userform into 2 sheets. 2nd sheet would be by matching header

Re: $$Excel-Macros$$ Re: Invitation to the Excel Modeling World Championships 2014

$$Excel-Macros$$ Need a Macro to find Variable Cost

$$Excel-Macros$$ Re: Categorise A,B,C,

Re: $$Excel-Macros$$ Re: Invitation to the Excel Modeling World Championships 2014

Re: $$Excel-Macros$$ Number to Text Indiann rupee format using formula no add ins & UDF

Re: $$Excel-Macros$$ Re: Invitation to the Excel Modeling World Championships 2014

Re: $$Excel-Macros$$ Macros get deleted

$$Excel-Macros$$ Macros get deleted

17 matches

Site Navigation

Mail list logo

Footer information