Re: $$Excel-Macros$$ User wise view or edit rights

2014-12-05 Thread Vaibhav Joshi
is it still open? + *I did not do this for you. God is here working through me for you.* On Thu, Dec 4, 2014 at 9:53 PM, Atul Kavade wrote: > Please find attached sheet > and help > Last sheet is for user database > I need to give rights as per username > eg. > if username is Manisha then s

$$Excel-Macros$$ Re: need function to get data on exact match

2014-12-05 Thread Mandeep Baluja
Kindly find the solution Regards, Mandeep Baluja LearningZmyPassion https://www.linkedin.com/profile/view?id=312532939 https://www.facebook.com/VBAEXCELSQL?ref=hl On Saturday, December 6, 2014 9:14:25 AM UTC+5:30, Ashish_Bhalara wrote: > > Dear experts, > > I need function to receive data o

$$Excel-Macros$$ Re: Pull-down selections

2014-12-05 Thread Mandeep Baluja
Can I get that file with the result On Saturday, December 6, 2014 12:06:42 AM UTC+5:30, Paul Schreiner wrote: > > I have a worksheet template in which I display a 3-digit Product Code. > I have a hidden worksheet that has a list of Product Codes and > corresponding product names like: > Code Prod

$$Excel-Macros$$ need function to get data on exact match

2014-12-05 Thread Ashish Bhalara
Dear experts, I need function to receive data on fulfill particular cell data, the demo is attached herewith, thanks in advance. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- Are you =EXP(E:RT) or =

$$Excel-Macros$$ Pull-down selections

2014-12-05 Thread Paul Schreiner
I have a worksheet template in which I display a 3-digit Product Code. I have a hidden worksheet that has a list of Product Codes and corresponding product names like: Code Product 000 Product_A 001 Product_B 002 Product_C 003 Product_D I'd like to have a pull-down in the Product Code Field that

Re: $$Excel-Macros$$ How to protect only few cells

2014-12-05 Thread Ashish Kumar
Welcome Putta. -- 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

Re: $$Excel-Macros$$ Re: Explanation

2014-12-05 Thread Vaibhav Joshi
In index formula we are using index(array,1,0). Means whole 1st row is selected, in this case 1st row has 1,2,3. So there is no increment but formula is passing values all first row value to array.. + *I did not do this for you. God is here working through me for you.* On Fri, Dec 5, 2014 a

$$Excel-Macros$$ Re: Explanation

2014-12-05 Thread Mandeep Baluja
Hey vabz , Even a selected range can also be considered as an array. Can a range variable work ??? Join(Application.Index(c01.Value,1,0), "|") Next step Join(Application.Index({1,2,3},1,0), "|") how it is selecting 2 even there is no increment is going on Join can combine the array values

$$Excel-Macros$$ Problem in calculating yield to maturity

2014-12-05 Thread Arjun S. Gupta
Dear Friends, I am new to excel and my query is very small. I have to calculate yield to maturity for a bond. I am calculating it using XIRR and yield function in excel. Values are different. XIRR =12.13% whereas Yield =12.40% Please advice me what I have done wrong in calculating yield. I have

Re: $$Excel-Macros$$ How to protect only few cells

2014-12-05 Thread Putta Madaiah
Thank you Ashish..this is working fine On Dec 5, 2014 1:52 PM, "Ashish Kumar" wrote: > Hi Putta, > > Steps for Lock cells : > > Step 1: Select all cells in current worksheet with pressing the Ctrl key > and A key together. > > Step 2: Right click, and select the Format Cell item from the context

Re: $$Excel-Macros$$ Explanation

2014-12-05 Thread Vaibhav Joshi
Hi when you perform index function on one row by x columns, result given by excel is in Array.. e.g. put A in cell A1, B in Cell B1 & C in cell C1. Now write this formula in A2, =INDEX(A1:C1,1,0) now goto cell A2 & then press shift + f3, press enter.. see in result you will see {"A","B","C"}, wh

Re: $$Excel-Macros$$ How to protect only few cells

2014-12-05 Thread Ashish Kumar
Hi Putta, Steps for Lock cells : Step 1: Select all cells in current worksheet with pressing the Ctrl key and A key together. Step 2: Right click, and select the Format Cell item from the context menu. Step 3: In the Format Cells dialog box, uncheck the Locked option under Protection tab, and c