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

2013-12-19 Thread Sandeep Kumar Chhajer
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 -Original Message- From: Rupesh Patil Sender: excel-macros@googlegroups.com Date: Fri, 20 Dec 2013 13:05:56

$$Excel-Macros$$ Userforms

2013-12-19 Thread Rupesh Patil
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 -- 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:

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

2013-12-19 Thread Rupesh Patil
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 gener

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

2013-12-19 Thread Jocky Beta
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 J

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

2013-12-19 Thread Sandeep Kumar Chhajer
Hi Jockey, Please specify your requirement. Thanks & Regards, Sandeep Kumar Chhajer Mumbai India Sent on my BlackBerry® from Vodafone -Original Message- From: Jocky Beta Sender: excel-macros@googlegroups.com Date: Fri, 20 Dec 2013 12:49:38 To: Reply-To: excel-macros@googlegroups.com

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

2013-12-19 Thread Jocky Beta
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

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

2013-12-19 Thread Basole
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 correlate

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

2013-12-19 Thread XX
Hey there, thanks for the reply! Is there any way to make the 2 sets of numbers have a correlation coefficient of 0.5? Thanks! On Friday, 20 December 2013 00:53:00 UTC+8, Basole wrote: > > XX, try this: > > Ex. > > =RANDBETWEEN(1,100) > and press "F9" for test. > > Basole > > > > Em quinta-fe

$$Excel-Macros$$ Interactive charts

2013-12-19 Thread Pavan Valluru
Hi Guyz, can anyone tell me can i call any macro or event once user moves the cursor to a particular series of chart? i would like show the selected series data just below the chart once user moves their cursor on a series. Can we do this using API or anything else? any ideas? Please guide me

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

2013-12-19 Thread Basole
XX, try this: Ex. =RANDBETWEEN(1,100) and press "F9" for test. 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 fo

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

2013-12-19 Thread XX
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

$$Excel-Macros$$ vlookup in sheet2

2013-12-19 Thread Rajesh Agarwal
Hello Sir I want to put vlookup in sheet2 as per mention in the sheet from sheet1 Thanks -- *Rajesh Kumar Agarwal* *9811063001* -- 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.c

Re: $$Excel-Macros$$ About Formula

2013-12-19 Thread Rupesh Patil
Dear Ravinder thanks you for replay, you are saying this formula will not work = VLOOKUP(K2,A2:K494,6,FALSE), I sure you understand what i wants write, so is there any alternate way to get output thanks you On Thu, Dec 19, 2013 at 2:24 PM, Ravinder wrote: > Your look up value is K2 however

RE: $$Excel-Macros$$ About Formula

2013-12-19 Thread Ravinder
Your look up value is K2 however your range is starting from A2, So formula should be =vlookup(a2,a2:k494,6,false) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rupesh Patil Sent: Thursday, December 19, 2013 1:54 PM To: excel-macros@googlegroups.com Su

Re: $$Excel-Macros$$ About Formula

2013-12-19 Thread Anil Gawli
Dear Rupesh, put $ sign in between the ranges like this =VLOOKUP(K2,$A$2:$K$494,6,FALSE) it will work Warm Regards, Gawli Anil On Thu, Dec 19, 2013 at 1:54 PM, Rupesh Patil wrote: > Hi Experts, > > =VLOOKUP(K2,A2:K494,6,FALSE) > > Can any one suggest me, what is wrong with above formula >

$$Excel-Macros$$ About Formula

2013-12-19 Thread Rupesh Patil
Hi Experts, =VLOOKUP(K2,A2:K494,6,FALSE) Can any one suggest me, what is wrong with above formula -- 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.co