date:20131220

$$Excel-Macros$$ Re: Introduce Yourself !!

2013-12-20 Thread khushal

Hie All,

I'm CA Khushal Sheth working with dad in his firm "KVMDS & ASSOCIATES, 
@ Pune" as a partner. I'm very keen and interested to learn new things in 
excel and now I want to learn about VBA which can help me do the task 
easily and with standardized procedures.
I will really appreciate if we can have videos regarding excel and/or VBA 
to learn from basics to masters.

Thank you for all your support and answers to all my queries.

Regards,

On Saturday, June 9, 2012 12:51:59 AM UTC+5:30, Ayush Jain wrote:

> Hey all new and current posters,
>  
> Welcome to excel group,one of the largest online community of excel Fans!
>  
> I hope you enjoy your time here & find this forum to be a friendly and 
> knowledgeable community. Please feel free to post a small introduction, a 
> friendly hello or tell us a bit about yourself. Why not tell us where are 
> you from, what you do, what your interests are, how old you are, which is 
> your favourite excel site or blog is or anything else that comes to mind!
>
> Thanks for your time
> Ayush Jain
> Group Manager
> Microsoft MVP
>

-- 
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/groups/opt_out.

$$Excel-Macros$$ Optimize code to minimize runtime of the macro

2013-12-20 Thread amitjha2487

Hi friends,
I have been writing some macros to perform some astrological calculations 
(calculating sign, lunar mansion, D9 & D60). The raw data is in the 
following format:



lng in the above image stands for longitude expressed in 
degree,minute,second format. The output has to be in the following format:



I have whipped up the following code to read the data from the input sheet 
and format & copy it to the output sheet then do calculations with the 
longitude of each planet to calculate required fields.
Sub prepareOutput()
Application.ScreenUpdating = False
Dim c, count, d, l, ll
Dim r As Range
Set r = Worksheets("Ephemerides").Range("a4:" & 
Worksheets("Ephemerides").Range("a4").End(xlDown).Address)
Worksheets("output").Range("a3").Value = "Date"
For Each d In r
Worksheets("output").Cells(d.Row, 1).Value = d.Value
Next

For Each c In Worksheets("Ephemerides").Range("d2:o2")
If Not IsEmpty(c) Then
count = count + 5
'MsgBox count
If count = 5 Then
Worksheets("output").Cells(2, 2).Value = c.Value
Worksheets("output").Cells(3, 2).Value = "Longitude"
Worksheets("output").Cells(3, 3).Value = "Sign"
Worksheets("output").Cells(3, 4).Value = "Nakshatra"
Worksheets("output").Cells(3, 5).Value = "Navamsa"
Worksheets("output").Cells(3, 6).Value = "D60"
For Each l In Worksheets("Ephemerides").Range(c.Offset(2, 
0), c.End(xlDown).Address)
Worksheets("output").Cells(l.Row, 2).Value = l.Value
Worksheets("output").Cells(l.Row, 3).Value = 
calcSign(l.Value)
Next
count = 2
Else
Worksheets("output").Cells(2, count).Value = c.Value
Worksheets("output").Cells(3, count).Value = "Longitude"
Worksheets("output").Cells(3, count + 1).Value = "Sign"
Worksheets("output").Cells(3, count + 2).Value = "Nakshatra"
Worksheets("output").Cells(3, count + 3).Value = "Navamsa"
Worksheets("output").Cells(3, count + 4).Value = "D60"
For Each ll In Worksheets("Ephemerides").Range(c.Offset(2, 
0), c.End(xlDown).Address)
Worksheets("output").Cells(ll.Row, count).Value = 
ll.Value
Worksheets("output").Cells(ll.Row, count + 1).Value = 
calcSign(ll.Value)
Next
End If
End If
Next
Application.ScreenUpdating = True
End Sub



Private Function deg2dec(deg As String) As Variant
d = Val(Mid(deg, 1, InStr(deg, "°") - 1))
m = Val(Mid(deg, InStr(deg, "°") + 1, 2)) / 100
deg2dec = d + m
End Function


Private Function calcSign(deg As String) As String
dec = deg2dec(deg)
Select Case dec
Case 0 To 30
calcSign = "Aries"
Case 30 To 60
calcSign = "Taurus"
Case 60 To 90
calcSign = "Gemini"
Case 90 To 120
calcSign = "Cancer"
Case 120 To 150
calcSign = "Leo"
Case 150 To 180
calcSign = "Virgo"
Case 180 To 210
calcSign = "Libra"
Case 210 To 240
calcSign = "Scorpio"
Case 240 To 270
calcSign = "Saggitarius"
Case 270 To 300
calcSign = "Capricorn"
Case 300 To 330
calcSign = "Aquarius"
Case 330 To 360
calcSign = "Pisces"
End Select
End Function


The above code doesn't calculate all 4 computed fields, just one for now.

The problem I am having is that I have 24000 rows and 12 columns in my 
input sheet and it is taking a lot of time to just copy this data to the 
output sheet and then doing calculations on it to compute one more 
value.And I have to calculate 3 more fields from one longitude value.

So if you guys could take a look at the code and let me know how i could go 
about minimizing the runtime here, that would help a lot.

Thanks in advance to all those who take out time to reply.

Cheers

-- 
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 an

RE: $$Excel-Macros$$ VBA to send excel file using outlook

2013-12-20 Thread B.N.Chethan Kumar

It worked. . thanks
On Dec 10, 2013 11:29 AM, "Ravinder"  wrote:

> give some examples
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *B.N.Chethan Kumar
> *Sent:* Monday, December 09, 2013 6:13 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ VBA to send excel file using outlook
>
>
>
> I have to send excel as attachment to end user. But using  different
> account. Like using "from" as a "Common I'd"
>
> --
> 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/groups/opt_out.
>
> --
> 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/groups/opt_out.
>

-- 
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/groups/opt_out.

RE: $$Excel-Macros$$ Ie

2013-12-20 Thread B.N.Chethan Kumar

Thanks. It worked.
On Dec 19, 2013 11:44 AM, "Ravinder"  wrote:

> Try this if looking for this..  actually in this you can login in yahoo
> and gmail through form…
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *B.N.Chethan Kumar
> *Sent:* Thursday, December 19, 2013 10:41 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* RE: $$Excel-Macros$$ Ie
>
>
>
> I am trying to connect Google \ analytics and pull report.
>
> On Dec 19, 2013 10:35 AM, "Ravinder"  wrote:
>
> Provide website and data you want to extract…
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *B.N.Chethan Kumar
> *Sent:* Thursday, December 19, 2013 4:19 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Ie
>
>
>
> Hi
> I am trying to connect IE 9 using vba and create a loop download data. Any
> 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/groups/opt_out.
>
> --
> 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/groups/opt_out.
>
> --
> 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/groups/opt_out.
>
> --
> 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 thr

$$Excel-Macros$$ Re: Need Help with VBA in Excel

2013-12-20 Thread Basole

PG, Please share an example with some data!



regards,
Basole.



Em sexta-feira, 20 de dezembro de 2013 16h27min17s UTC-2, PG escreveu:
>
> Hi, 
> I have a problem to solve here. 
>
> I have a master list of about 1000 records, which has Order ID, Customer 
> Name, Address, and Order Amount columns.
> Now I need to print an order list with some Order IDs (hand picked) on it 
> from time to time which will have all the above columns. Now to print this 
> Order list, I want to use a User form to enter the Order ID and want other 
> fields to get populated itself from the master list. Then when I click on a 
> button to Add, this data gets added to the Order List. 
>
> So basically I want to pull data from the master list into the Order list 
> but using the form so that when I enter the Order ID manually, the other 
> corresponding values get populated itself in the form and then get added to 
> the Order List, until all the orders are added. Then to print this order 
> list in the end. By this way I don't have to manually pick the Order IDs 
> from the master List and copy-Paste into the Order List.
>
> I don't want to use the simple vlookup in Excel because there is a chance 
> of someone manipulating the data by mistake. I would like the master 
> database to be hidden from the user and the User Form to show when the 
> program is run and then get the final printed Order List.
>
> Hope this is clear, if not please feel free to clarify. 
>
> Thank you so much in advance.
>
> Regards
>
>

-- 
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/groups/opt_out.

$$Excel-Macros$$ Need Help with VBA in Excel

2013-12-20 Thread PG

Hi, 
I have a problem to solve here. 

I have a master list of about 1000 records, which has Order ID, Customer 
Name, Address, and Order Amount columns.
Now I need to print an order list with some Order IDs (hand picked) on it 
from time to time which will have all the above columns. Now to print this 
Order list, I want to use a User form to enter the Order ID and want other 
fields to get populated itself from the master list. Then when I click on a 
button to Add, this data gets added to the Order List. 

So basically I want to pull data from the master list into the Order list 
but using the form so that when I enter the Order ID manually, the other 
corresponding values get populated itself in the form and then get added to 
the Order List, until all the orders are added. Then to print this order 
list in the end. By this way I don't have to manually pick the Order IDs 
from the master List and copy-Paste into the Order List.

I don't want to use the simple vlookup in Excel because there is a chance 
of someone manipulating the data by mistake. I would like the master 
database to be hidden from the user and the User Form to show when the 
program is run and then get the final printed Order List.

Hope this is clear, if not please feel free to clarify. 

Thank you so much in advance.

Regards

-- 
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/groups/opt_out.

$$Excel-Macros$$ Re: Find, move & delete

2013-12-20 Thread Basole

You're welcome, 


Regards,
Basole.


Em segunda-feira, 16 de dezembro de 2013 23h09min31s UTC-2, Bill Q escreveu:
>
> Hi, 
>  
> The macro below currently finds and removes selected characters that it 
> find. It works great. No issues.
>  
> What I would like is this to be modified so that if it finds a character 
> within the array - it will move the character in question to the adjacent 
> cell to the right, THEN it will clear the character it just found.
>  
> Thanks.  
>  
>  
> Sub CLEARNUMBERS001()
> s = Array("+", "-", ".5", "-.5", "0", "1", "2", "3", "4", "5", "6", "7", 
> "8", "9")
> For Each r In Selection
> v = r.Value
> For i = 0 To 13
> v = Replace(v, s(i), " ")
> Next
> r.Value = v
> Next
> 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/groups/opt_out.

$$Excel-Macros$$ Re: How to generate correlated random variables in excel?

2013-12-20 Thread Basole

Not at all!


regards,
Basole

Em quinta-feira, 19 de dezembro de 2013 14h45min36s UTC-2, XX escreveu:
>
> HI all,
>
> I need some help with using excel to generate two sets of correlated 
> random variables, anyone can help me with this? What's the formula to use?
> Thanks alot!
>

-- 
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/groups/opt_out.

$$Excel-Macros$$ Re: How to generate correlated random variables in excel?

2013-12-20 Thread XX

thanks for the help, have solved my problem! :)

On Friday, 20 December 2013 01:07:32 UTC+8, Basole wrote:
>
> Hi, if not what you need,  " =RANDBETWEEN(1,100)*0.5 " 
>
> please share an example for better understanding of your problem.
>
> regards, 
> Basole
>
>
>
> Em quinta-feira, 19 de dezembro de 2013 14h45min36s UTC-2, XX escreveu:
>>
>> HI all,
>>
>> I need some help with using excel to generate two sets of correlated 
>> random variables, anyone can help me with this? What's the formula to use?
>> Thanks alot!
>>
>

-- 
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/groups/opt_out.

Re: $$Excel-Macros$$ material Stock Inventory in Excel

2013-12-20 Thread Rupesh Patil

dear Sandeep

I am really sorry about that but that was by-mistake

I am really really sorry again. it won't happen again




On Fri, Dec 20, 2013 at 1:28 PM, Sandeep Kumar Chhajer <
chhajersand...@gmail.com> wrote:

> Rupesh,
>
> Please use new thread for new queries, don't send new queries on others
> thread.
>
> Thanks & Regards,
> Sandeep Kumar Chhajer
> Mumbai
> India
>
> Sent on my BlackBerry® from Vodafone
> --
> *From: * Rupesh Patil 
> *Sender: * excel-macros@googlegroups.com
> *Date: *Fri, 20 Dec 2013 13:05:56 +0530
> *To: *
> *ReplyTo: * excel-macros@googlegroups.com
> *Subject: *Re: $$Excel-Macros$$ material Stock Inventory in Excel
>
> Hi expert
>
> I need some assistance, dose any buddy have application that used around
> 10 userForm and save data in excel around 450 columns for one record.
>
> thanks in advance
>
>
> On Fri, Dec 20, 2013 at 12:59 PM, Jocky Beta  wrote:
>
>> Hi Sandeep,
>>
>> I want an excel sheet form which  i can easily generate  the reports like
>> Current Stock, Enters,Material Exits by months, material issue details,
>> material received details etc.
>>
>> Regards
>>
>>
>> On Fri, Dec 20, 2013 at 12:51 PM, Sandeep Kumar Chhajer <
>> chhajersand...@gmail.com> wrote:
>>
>>> Hi Jockey,
>>>
>>> Please specify your requirement.
>>> Thanks & Regards,
>>> Sandeep Kumar Chhajer
>>> Mumbai
>>> India
>>>
>>> Sent on my BlackBerry® from Vodafone
>>> --
>>> *From: * Jocky Beta 
>>> *Sender: * excel-macros@googlegroups.com
>>> *Date: *Fri, 20 Dec 2013 12:49:38 +0530
>>> *To: *
>>> *ReplyTo: * excel-macros@googlegroups.com
>>> *Subject: *$$Excel-Macros$$ material Stock Inventory in Excel
>>>
>>> Hi All,
>>>
>>> Does anybody have material Stock Inventory sheet in Excel. if Yes kindly
>>> share
>>>
>>> *Rgerads*
>>> *Jocky*
>>>
>>> --
>>> 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/groups/opt_out.
>>>
>>> --
>>> 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/groups/opt_out.
>>>
>>
>>  --
>> 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.

$$Excel-Macros$$ Re: Introduce Yourself !!

$$Excel-Macros$$ Optimize code to minimize runtime of the macro

RE: $$Excel-Macros$$ VBA to send excel file using outlook

RE: $$Excel-Macros$$ Ie

$$Excel-Macros$$ Re: Need Help with VBA in Excel

$$Excel-Macros$$ Need Help with VBA in Excel

$$Excel-Macros$$ Re: Find, move & delete

$$Excel-Macros$$ Re: How to generate correlated random variables in excel?

$$Excel-Macros$$ Re: How to generate correlated random variables in excel?

Re: $$Excel-Macros$$ material Stock Inventory in Excel

10 matches

Site Navigation

Mail list logo

Footer information