Re: $$Excel-Macros$$

2015-05-13 Thread Rakesh
Dear Ashish, Thanks for your efforts, pl find the attached sheet for your reference. Kindly suggest any appropriate formula which give me the exect which i want. RAKESH SHARMA NPI –Team Ericsson India Pvt. Ltd. 4th Floor, Gupta Towers, Commercial Block, Rail Head Jammu & Kashmir, INDIA Phone

Re: $$Excel-Macros$$

2015-05-13 Thread Ashish Kumar
Share Example. ?? Regards Ashish On 14 May 2015 at 11:18, Rakesh wrote: > Dear Experts, > > can you please tell me how to get 2nd,3rd... values with the Vlookup. > > Thanks > Rakesh > > -- > 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

$$Excel-Macros$$

2015-05-13 Thread Rakesh
Dear Experts, can you please tell me how to get 2nd,3rd... values with the Vlookup. Thanks Rakesh -- 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

Re: $$Excel-Macros$$ Re: Copy PDF data to Excel macro require

2015-05-13 Thread Michael Vinoth
Hi Pankaj Sharma , Please find the attached macro file. kindly let me know if you have any queries. Regards, MV On Saturday, May 9, 2015 at 3:01:04 PM UTC+5:30, Pankaj Sharma wrote: > i recd 20-30 Mobile Bills in PDF format every month, which i need to copy > in Excel with different sheets. >

Re: $$Excel-Macros$$ Text separated with formula

2015-05-13 Thread Nur Hossain
Dear Paul Schreiner & Pankaj Sharma & Swapnil Palande : Thanks all of your help in this regard , On Wed, May 13, 2015 at 5:27 PM, Paul Schreiner wrote: > So... you want to do it from within the macro. > As Pankaj Sharma mentioned, there is a TextToColumns VBA method. > > Depending on how much

Re: $$Excel-Macros$$ Text separated with formula

2015-05-13 Thread Paul Schreiner
So... you want to do it from within the macro.As Pankaj Sharma mentioned, there is a TextToColumns VBA method. Depending on how much "control" you want, you can also do this with an array. the split() function will divide up your value and put it into an array. So, you can use: mArray = split(r

Re: $$Excel-Macros$$ Re: DropDown List

2015-05-13 Thread Mandeep Baluja
Dependent drop down list will be used to create there will be a no of possible combination which depend on previous column value, I have sent the same code earlier, you should search. Regards, Mandeep baluja On Wednesday, May 13, 2015 at 3:46:14 PM UTC+5:30, rk sharma wrote: > > Dear Nasir,

Re: $$Excel-Macros$$ Re: DropDown List

2015-05-13 Thread Rakesh
Dear Nasir, Thanks for your efforts. but dear i need data in drop down list . for example. if i select indus in drop down then in zte cluster option i will get zte cluster and same for the zdm name and zdm number RAKESH SHARMA NPI –Team Ericsson India Pvt. Ltd. 4th Floor, Gupta Towers, Commerc

Re: $$Excel-Macros$$ Text separated with formula

2015-05-13 Thread Pankaj Sharma
use this Selection.TextToColumns Destination:=Range("B1"), DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, Other:=True, _ otherchar:="_", fieldinfo:=Array(Array(1, 1), Array(2, 1), Array(3, 1)),TrailingMinusNumbers:=True -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you

$$Excel-Macros$$ DropDown List

2015-05-13 Thread Rakesh
Dear Experts, Help required for attached sheet urgently -- 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. Poo

Re: $$Excel-Macros$$ Text separated with formula

2015-05-13 Thread Swapnil Palande
Hi, Check below link: http://www.get-digital-help.com/2014/12/02/split-text-across-columns/ Regards, Swapnil On Wed, May 13, 2015 at 11:16 AM, Nur Hossain wrote: > Hi Paul Schreiner, thanks for replay , I am using office 2007, yes I agree > with you that it is possible by doing text to column