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

2016-10-11 Thread sonuraj1240
Thanks for Help On Tuesday, 11 October 2016 10:00:45 UTC+5:30, De Premor wrote: > > Try this one ! > > [dp] > > On 10/10/2016 19:46, sonur...@gmail.com wrote: > > Hi > > I need help for separate data through VBA. > > My Data is below type.. > sku Size > 10307963 XS,S,M,L > 103

$$Excel-Macros$$ https://www.wolfssl.com/wolfSSL/Home.html

2016-10-11 Thread Alex
https://www.wolfssl.com/wolfSSL/Home.html -- 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

Fwd: $$Excel-Macros$$ Conditional calculation required for multiple criteria.

2016-10-11 Thread Dheeraj Bankoti
HI IS IT POSSIBLE? -- Forwarded message -- From: Dheeraj Bankoti Date: Sun, Oct 9, 2016 at 1:24 PM Subject: Fwd: $$Excel-Macros$$ Conditional calculation required for multiple criteria. To: excel-macros@googlegroups.com -- Forwarded message -- From: Dheeraj Banko

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

2016-10-11 Thread sourav devrani
Use this Man Sub SplitTest() Dim VarArrayAs Variant Dim LngRAs Long Dim LngCAs Long Dim LngIndexAs Long Dim VaresultAs Variant LngIndex = 1 VarArray = Intersect(Sheet2.Range("A1").CurrentRegion, Sheet2.Range("A1").CurrentRegion.Offset(1))

Re: $$Excel-Macros$$ Need a help in formating an equation for the nested if..

2016-10-11 Thread Learner Excel
here you go.. -- On Tue, Oct 11, 2016 at 6:59 PM, HOTEL PRESIDENT < hotelpresident.raj...@gmail.com> wrote: > pl > reply soon > > *Thanks & Regards* > > *Sohil S. Hudani* > * C/O Hotel President* > *Mo. 9998241341* > > > On Tue, Oct 11, 2016 at 6:37 PM, HOTEL PRESIDENT < > hotelpreside

Re: $$Excel-Macros$$ Need a help in formating an equation for the nested if..

2016-10-11 Thread HOTEL PRESIDENT
pl reply soon *Thanks & Regards* *Sohil S. Hudani* * C/O Hotel President* *Mo. 9998241341* On Tue, Oct 11, 2016 at 6:37 PM, HOTEL PRESIDENT < hotelpresident.raj...@gmail.com> wrote: > here the attachment is missing. i need a simple logic for room no 205 and > 201 the rate for pax 1 is

Re: $$Excel-Macros$$ Need a help in formating an equation for the nested if..

2016-10-11 Thread HOTEL PRESIDENT
here the attachment is missing. i need a simple logic for room no 205 and 201 the rate for pax 1 is 1500 and the rate for 2 pax is 1700, same way for room no 202,203 and 204 the rate for 1 pax is 1200 and rate for 2 pax is 1400 here i am attching a file in which upon entering the room no and pax th

Re: $$Excel-Macros$$ Need a help in formating an equation for the nested if..

2016-10-11 Thread HOTEL PRESIDENT
here the attachment is missing. i need a simple logic for room no 205 and 201 the rate for pax 1 is 1500 and the rate for 2 pax is 1700, same way for room no 202,203 and 204 the rate for 1 pax is 1200 and rate for 2 pax is 1400 here i am attching a file in which upon entering the room no and pax th

Re: $$Excel-Macros$$ Need a help in formating an equation for the nested if..

2016-10-11 Thread Learner Excel
oops attachment missing -- On Tue, Oct 11, 2016 at 5:49 PM, Learner Excel wrote: > Hi Enclosed solution with simple vlookup. > > It would be great if you can share the tariff plan calculation logic so > that we are create this more dynamic > > -- > > On Tue, Oct 11, 2016 at 1:55 PM, HOTEL PRESI

Re: $$Excel-Macros$$ Need a help in formating an equation for the nested if..

2016-10-11 Thread Learner Excel
Hi Enclosed solution with simple vlookup. It would be great if you can share the tariff plan calculation logic so that we are create this more dynamic -- On Tue, Oct 11, 2016 at 1:55 PM, HOTEL PRESIDENT < hotelpresident.raj...@gmail.com> wrote: > pl reply > > *Thanks & Regards* > > *Sohil S. Hu

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

2016-10-11 Thread Learner Excel
Hi Try below VBA code Option Base 1 Sub rr() For Each r In Range("b2:b" & Range("b9").End(xlUp).Row) x = Split(r, ",") For t = LBound(x) To UBound(x) Range("h9").End(xlUp).Offset(1).Value = Cells(r.Row, 1) Range("i9").End(xlUp).Offset(1).Value = x(t) Next Next End S

Re: $$Excel-Macros$$ Need a help in formating an equation for the nested if..

2016-10-11 Thread HOTEL PRESIDENT
pl reply *Thanks & Regards* *Sohil S. Hudani* * C/O Hotel President* *Mo. 9998241341* On Tue, Oct 11, 2016 at 1:07 PM, HOTEL PRESIDENT < hotelpresident.raj...@gmail.com> wrote: > Here I've attached a format please check it.. Details given in format > > *Thanks & Regards* > > *Sohil S.

Re: $$Excel-Macros$$ Need a help in formating an equation for the nested if..

2016-10-11 Thread HOTEL PRESIDENT
Here I've attached a format please check it.. Details given in format *Thanks & Regards* *Sohil S. Hudani* * C/O Hotel President* *Mo. 9998241341* On Tue, Oct 11, 2016 at 12:53 PM, Deepu Dubey wrote: > Hi, > > What equation you need?? elaborate > > > On Tue, Oct 11, 2016 at 12:51 PM,

Re: $$Excel-Macros$$ Need a help in formating an equation for the nested if..

2016-10-11 Thread Deepu Dubey
Hi, What equation you need?? elaborate On Tue, Oct 11, 2016 at 12:51 PM, wrote: > > > Need a help in formating an equation for the nested if.. > > -- > 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 @

$$Excel-Macros$$ Need a help in formating an equation for the nested if..

2016-10-11 Thread hotelpresident . rajula
Need a help in formating an equation for the nested if.. -- 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. P