$$Excel-Macros$$ About Create Report

[Rupesh Patil]

Hello Expert
 I need Micro to generate report on button click.
 I have excel with 350 column, first column is unique id for each user.
each row is record for one user.
 My requirement is admin person enter id number in text box and hit enter
if this id match in sheet in first column then notify to Admin this id
present in sheet. then if admin press report button then report come up of
that user.

any single help or advice will  help lot
thanks in advance

-- 
Thanks and Regards, Rp.

-- 
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$$ Macro Code??

[Deepak Rawat]

Dear All,

I need macro to update multiple sheets from one sheet
Ref data is attached
Kindly provide the best code, as if macro run once it couldn't be undo.

Regards,
Deepak Rawat

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


Test.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Importing Excel Files

[Linda C]

There are around 40 files in the folder, but not all of them are needed.

The names are like 
"COUNTY_CALIFORNIA_01350143_Main.xlsx": If the file name starts with 
"COUNTY_CALIFORNIA" and ends with "Main", import into "Sheet FileA"
"REGION_BRITAIN_02242044_Sub.xlsx": if the file name starts with 
"REGION_BRITAIN" and ends with "Sub", import into "Sheet FileB"
"CITY_HK_05402044_Raw.xlsx" if the file name starts with "CITY_HK" and ends 
with "Raw", import into "Sheet FileC"

The destination sheets "Sheet FileA", "Sheet FileB"... are already existing.

Thank you!





On Saturday, 4 January 2014 13:18:18 UTC-5, ashish wrote:
>
> how many files are in folder .. can u share some full names of few files 
> and sheets thy need to go into
>  
> "Sheet FileA , "Sheet FileB will they be already existing or will be 
> created by macro only
>  
>  
>
>
> On Sat, Jan 4, 2014 at 10:04 PM, Linda C 
> > wrote:
>
>> Hi Ashish,
>>
>> On a separate note, is it possible to have a single button which will 
>> trigger the import of multiple files into specific sheets on an active 
>> workbook?
>>
>> For example, the user only needs to specify the folder containing all the 
>> files to be imported; there will be no user input to select which file to 
>> import, it will be handle by the logic below:
>>
>> If file name starts with "FileA" and ends with "Main", then import to 
>> "Sheet FileA" cell A1 to Z3000
>> If file name starts with "FileB" and ends with "Sub", then import to 
>> "Sheet FileB" cell A1 to Z3000
>> If file name starts with "FileC" and ends with "Raw", then import to 
>> "Sheet FileC" cell A1 to Z3000
>>
>> So user only needs to select the folder and click import once to trigger 
>> all these jobs.
>> Thanks again. :)
>>
>> On Monday, 30 December 2013 18:39:00 UTC-5, Linda C wrote:
>>>
>>> Thanks Ashish & Anoop!
>>>
>>> On Monday, 30 December 2013 09:44:29 UTC-5, ashish wrote:

 please find updated file attached

 Regards
 Ashish


 On Mon, Dec 30, 2013 at 10:47 AM, Anoop K Sharma 
 wrote:

> just use below line
>
> Application.GetOpenFilename ("All Excel File (*.xls*),*.xls*")
>
>
> On Sun, Dec 29, 2013 at 8:49 PM, Linda C  wrote:
>
>> Hi Ashish,
>>
>> Is it possible to actually show all the excel files (both .xls and 
>> .xlsx version) after clicking Browse button so I can directly click the 
>> file to be imported?  Instead of clicking the drop-down button to scroll 
>> to 
>> the file?  The reason is the files name could be very long and it would 
>> be 
>> easier if I can actually see the files in the "Please select the folder" 
>> box.
>>
>> Thanks a lot!
>> Linda
>>
>>
>> On Saturday, 28 December 2013 09:55:28 UTC-5, Linda C wrote:
>>>
>>> Thank you Ashish!
>>>
>>> I will look at the file and will let you know if I have further 
>>> questions. :)
>>>
>>> On Saturday, 28 December 2013 00:38:21 UTC-5, ashish wrote:

 enable macros

 1 choose browse button and select the folder having the files and 
 then choose file to import from first combobox


 2 choose the sheet name from 2nd combo box

 3 click on import button to import data

 Regards
 Ashish



 On Sat, Dec 28, 2013 at 3:34 AM, Linda C wrote:

> Yes, there is only one sheet in those import files.
>
> Thanks!
>
>
>
> On Friday, 27 December 2013 12:21:09 UTC-5, ashish wrote:
>
>> excel files will have only one sheet right?
>>  
>>
>> On Fri, Dec 27, 2013 at 10:48 PM, Linda C wrote:
>>
>>> Hi ashish,
>>>
>>> Thanks for the quick reply!
>>>
>>> The data range to be imported (A1 to Z20) is fixed for all the 
>>> import files.
>>>
>>> Sorry, I may not understand your second question.  Ideally, the 
>>> master.xlsx file will have a button in tab 1 to import 
>>> "FileA_Main.xlsx" 
>>> and another button in tab 2 to import "FileB_Main.xlsx".
>>>
>>> On a separate note, the files to be imported have a date in the 
>>> name "FileA_20130101_Main".  Since the import will be done 
>>> periodically 
>>> with different dates, I'm thinking of the possible options below:
>>>
>>> 1. Tab 1 in the master.xlsx will import the file name starting 
>>> with "FileA_" and ends with "_Main" (is it possible?)
>>> 2. Change the code manually each time to specify the new file 
>>> name (tedious but doable)
>>>
>>> Your help is greatly appreciated!
>>>
>>> If there is an easier way, please advise.
>>>
>>> Thanks!
>>>
>>>
>>> On Friday, 27 De

$$Excel-Macros$$ Fwd: Excel Newsletter - Excel TEXT Function – handy but limited…or is it?

[Kuldeep Singh]

-- Forwarded message --
From: My Online Training Hub 
Date: Wed, Jan 8, 2014 at 5:33 PM
Subject: Excel Newsletter - Excel TEXT Function – handy but limited…or is
it?
To: Kuldeep 


 Excel's TEXT function is handy but use it with caution, and
occasionally to wow your colleagues!View this tutorial in your
browser.
   Hi Kuldeep,

*Happy New Year!*

*Phil and I had a lovely break and spent some quality time with our boys.
As it’s still summer holidays in Australia they’ve not started school for
this year yet, so we’ll be juggling work and being child entertainers for
the next few weeks. Wish us luck!*

*I’m excited to be back and writing my weekly Excel Newsletters again and I
can’t wait to get stuck into working on our plans for 2014.*
Excel TEXT Function – handy but limited…or is it?


At first glance the TEXT function appears quite limited. Its purpose is to
convert numbers to text in a specific/custom format.

There are two key points here:

   1. The numbers become text. This means you can’t use them in any math
   type of formulas.
   2. On the upside you can format the numbers anyway you want…almost!

Hold up!

Why would you want to convert a number into text when it means you then
can’t use that number in any math calculations/formulas?

Wouldn’t you just format the cell with the number format you want?

The answer is ‘yes’ most of the time, but *I’ll show you a clever use for
it* in a moment.

First, the syntax is:

*TEXT(value, format_text)*

Where the *value* is the number or reference to the cell containing the
number you want to format, and *format_text* is the format you want,
enclosed in double quotes.
Download Workbook
Download the Excel
Workbook.
Note: this is a .xlsx file please ensure your browser doesn't change the
file extension on download.

Let’s look at some examples.
TEXT Formula Examples [image: Examples of Excel TEXT formulas]

*Example 1* – Format as a Currency.

[image: Excel TEXT function example 1]

If you don’t know the character codes to use you can refer to the Format
Cells dialog box (CTRL+1 to open it) to get the number format ‘code’ (that
is the $#,##0.00 part) you need:

[image: Examples of Excel TEXT formulas]

You can use any number formats for the *format_text* argument that you find
in the Format Cells dialog box under the ‘Number’ tab.

Or you can write your own custom format.

If you're new to custom number formats check out Jon von der Heyden’s
tutorial for a comprehensive guide to custom number
formats
.

*Example 2* – Formatted as a date with hyphens instead of the Excel
standard forward slash.

[image: Excel TEXT formula example 2]

Note: 41640 in cell A5 is the serial number for the date 1st Jan 2014. More
on understanding dates in Excel
here
.

*Example 3 *– Display day of the week.

[image: Excel TEXT formula example 3]

Again we’ve taken a date in cell A6 and with the TEXT function we’ve only
displayed the day of the week. If you wanted to display the full name of
the day you would use “”.

*Example 4* – Add leading zeros to a number.

[image: Excel TEXT formula example 4]

This is handy for invoice numbers or other numbers/codes that require a
leading zero.
Limitations of TEXT Formulas

As I mentioned at the beginning, the above examples all convert the numbers
in column A to text in column B.

Examples 3 and 4 are ok formatted as text (the day of the week and leading
zeros) as they are unlikely to ever be used in a math formula so having
them as text won’t cause you a problem.

But it’s not ideal for examples 1 and 2 (format as currency and date) as
it’s likely you’ll want to perform a calculation using those numbers at
some point in your worksheet’s life.

A better option for examples 1 and 2 is to just apply the number format to
the cell in column A.
Combine Text and Numbers in One Cell

I think the best use of the TEXT function is to use it to combine text and
numbers in one cell.

As you can see in cell A16 below:

[image: combine text and numbers in one cell using TEXT function]

In the formula bar you can see I’ve used the ampersand symbol (&) to
combine the text, “Sales up” and “Since 2010”, with the number returned by
the TEXT function, which I've formatted as a percentage:

="Sales up "&TEXT(B14/B11-1,"0%")&" Since 2010"

Which results in one text string:

Sales up 95% Since 2010

You’ll notice in this example I’ve also performed a calculation for the
*value* argument of the TEXT function, which is then formatted as a
percentage:

TEXT(B14/B1

$$Excel-Macros$$ Re: Data from one column to another without blanks but still in order?

[Basole]

'Hi Tom Yaxley,

'try this macro, copy and paste the code in sheet1 and to test, put some 
data in column "A" from cell "A1"

'Hope this helps.

'rgd, 

'Basole. 


Sub OrderData()
Dim orig, rev
Dim Lastrow As Integer
Dim i As Long
Lastrow = Cells.Find("*", [A1], , , xlByRows, xlPrevious).Row
i = 1
For i = i To Lastrow
orig = Cells(i, 1)
rev = StrReverse(orig)
Cells(i, 2) = rev
Next
Call UpdatData
Call Invert2
End Sub

Sub UpdatData()
ActiveWorkbook.Worksheets(1).Sort.SortFields.Clear
ActiveWorkbook.Worksheets(1).Sort.SortFields.Add Key:=Range("B1"), _

 SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
With ActiveWorkbook.Worksheets(1).Sort
.SetRange Range("B1:B500")
.Header = xlNo
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
End Sub

Sub Invert2()
Dim orig2, rev2, result
Dim z, Lastrow As Integer
Dim i As Long
z = Worksheets(1).Cells(Cells.Rows.Count, "B").End(xlUp).Row
i = 1
For i = i To z
orig2 = Cells(i, 2)
rev2 = StrReverse(orig2)
Cells(i, 2) = rev2
Next
End Sub

'.





Em quarta-feira, 8 de janeiro de 2014 11h18min26s UTC-2, Tom Yaxley 
escreveu:
>
>
>
> Hi All Experts,
>  
> I am looking to copy individual rows of data from one spreadsheet 
> which are separated by a varying amount of other data.
> It is also changing every day via a set of IF functions which pull data 
> daily from production spreadsheets.
> They are also not in order either...
> the rows appear as such:
> 001K
> 002K
> 003K
> 006K
>  
> (varying number of rows)
>  
> B004K
> B005K
> B007K
>  
> etc..
>  
> they need to become:
>  
> 001K
> 002K
> 003K
> B004K
> B005K
> 006K
> B007K
>  
> is there anyway to do this? (i cannot post the spreadsheet as it is 
> confidential data)
> Thanks
> Tom
>

-- 
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$$ Data from one column to another without blanks butstill in order?

[Prince]

Instead of sharing original share ur wprkbook with some dummy data

-Original Message-
From: "Tom Yaxley" 
Sent: 08-01-2014 06:48 PM
To: "excel-macros@googlegroups.com" 
Subject: $$Excel-Macros$$ Data from one column to another without blanks 
butstill in order?




Hi All Experts,
 
I am looking to copy individual rows of data from one spreadsheet which are 
separated by a varying amount of other data.
It is also changing every day via a set of IF functions which pull data daily 
from production spreadsheets.
They are also not in order either...
the rows appear as such:
001K
002K
003K
006K
 
(varying number of rows)
 
B004K
B005K
B007K
 
etc..
 
they need to become:
 
001K
002K
003K
B004K
B005K
006K
B007K
 
is there anyway to do this? (i cannot post the spreadsheet as it is 
confidential data)
Thanks
Tom
-- 
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.

$$Excel-Macros$$ Data from one column to another without blanks but still in order?

[Tom Yaxley]

Hi All Experts,
 
I am looking to copy individual rows of data from one spreadsheet which are 
separated by a varying amount of other data.
It is also changing every day via a set of IF functions which pull data 
daily from production spreadsheets.
They are also not in order either...
the rows appear as such:
001K
002K
003K
006K
 
(varying number of rows)
 
B004K
B005K
B007K
 
etc..
 
they need to become:
 
001K
002K
003K
B004K
B005K
006K
B007K
 
is there anyway to do this? (i cannot post the spreadsheet as it is 
confidential data)
Thanks
Tom

-- 
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$$ VBA Code for Hide specific column as per criteria

[amar takale]

Thank very much Ravi sir

But in code where I put sheet name or replace sheets name as per my data
sheets name where code activate on that specific sheets,in code you mention
For Each sh In Sheets.

Regards
Amar


On Wed, Jan 8, 2014 at 5:57 PM, Ravi Kumar  wrote:

> Hi,
>
>
>
>
>
> Please see this,, if u r looking for the same..
>
>
>
>
>
>
>
> *Warm Regards,*
>
> *Ravi Kumar.*
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *amar takale
> *Sent:* Wednesday, January 08, 2014 11:21 AM
>
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ VBA Code for Hide specific column as per
> criteria
>
>
>
> Hi Ravi Sir
>
> Good Morning!
>
> Can you looking this matter?
>
> Regards
>
> Amar T
>
>
>
> On Mon, Jan 6, 2014 at 5:27 PM, amar takale  wrote:
>
> Dear Ravi Sir,
>
> Great,very very thankful.
> Can we use this code for all sheet except some sheets,bcos there are maxi.
> 7 same format sheets so if I click this code then all 7 sheets do same
> activity process which do in first sheet.Can you give sheets name in code
> which sheets code only activate?
>
> Regards
>
> Amar T
>
>
>
> On Mon, Jan 6, 2014 at 3:45 PM, Ravi Kumar 
> wrote:
>
> Hi,
>
>
>
>
>
> Please find attached solution and let me know if u looking for the same.
>
>
>
>
>
>
>
> *Warm Regards,*
>
> *Ravi Kumar.*
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *amar takale
> *Sent:* Monday, January 06, 2014 1:37 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ VBA Code for Hide specific column as per
> criteria
>
>
>
> Dear mrExcel4u
>
> I have one more issue if i used this code in my sample file then it not
> work.pl correct code otherwise tell me where I wrong.
>
> Appreciate help sir
>
> Regards
>
> AmarT
>
>
>
> On Mon, Jan 6, 2014 at 11:05 AM, amar takale  wrote:
>
> Dear mrExcel4u
>
> Mind Freaking Sir !!! Awesome!!!
>
>
>
> Thanks job which I want,now lot of time save.
>
>
>
> Regards
>
> Amar T
>
>
>
> On Fri, Jan 3, 2014 at 9:03 PM, mrExcel4u  wrote:
>
> Hi Amar,
>
>
>
> Please find attached the file hope this will help you.
>
>
>
> regards,
>
> Vikas verma
>
>
>
> On Fri, Jan 3, 2014 at 11:56 AM, amar takale  wrote:
>
> Dear Experts team
>
> Any help on this issue?
>
> Regards
>
> Amar
>
>
>
> On Thu, Jan 2, 2014 at 12:38 PM, amar takale  wrote:
>
> Dear Experts
>
> Pls help me on this topic.All detailed give in excel attached.
>
> Regards
>
> Amar T
>
> --
> 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$$ Best Cognos Online Training in Australia

[steephen aqui]

Cognos Online Training by Sunitlabs We are providing excellent Cognos 
Training by real-time 

IT industry experts Our training methodology is very unique Our Course 
Content covers all the in-

depth critical scenarios. We have completed more than 200 Cognos batches 
through Online Cognos

Training program, Our Cognos Classes covers all the real time scenarios, 
and its completely on Hands-

on for each and every session.

Please call us for the Demo Classes we have regular batches and weekend 
batches.

Contact Number : India :+91 9030928000,

Email : i...@sunitlabs.com ,

Web: http://sunitlabs.com/cognos-online-training/

-- 
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$$ How to generate correlated random variables in excel?

[Kartik Dale]

Use =randbetween() formula

e.g: =randbetween(1,100) which can give you a number which is between 1 to
100

Regards,
Kartik


On Thu, Dec 19, 2013 at 10:15 PM, XX  wrote:

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



-- 
Thanks
Kartik

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