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 the value should be
>>> automatically generated in
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
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
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
please share your code.
--
On Tue, Sep 20, 2016 at 1:33 PM, chandrashekarb.xls <
chandrashekarb@gmail.com> wrote:
>
> Hi Team,
> Am trying to format few rows using vba code but it taking lot of time
> still have kept screenupdating & enableevent to false.
>
> Regards,
> Chandru
>
>
> Sent fr
No,
You can not record macro on Outlook, if you are looking for basic of
outlook macro thn please refer below url-
http://www.easytweaks.com/add-macros-outlook-2016/
--
On Mon, Sep 19, 2016 at 8:54 PM, dza49 wrote:
> Anyone have any idea on how to record macros in Outlook and have a place
> w
Hey Bil,
You can do this thru formula only.
Enclosed without macro solution, let us know if you still required macro.
--
On Sun, Sep 18, 2016 at 8:42 AM, Bill Q wrote:
> Please see attached.
>
> Looking for a macro to automate a repetitive task.
>
> 1. It is to look for a specific text in Col
Welcome back Ashish!.😉
--
On Fri, Sep 16, 2016 at 9:57 PM, Ashish Koul wrote:
> =IF(COUNTIFS($A:$A,$G9,$B:$B,$F9,$C:$C,H$4)=1,"Y","N")
>
> On Fri, Sep 16, 2016 at 9:47 PM, Kal xcel wrote:
>
>> Dear Experts,
>>
>> Please help me to solve the attached query.
>>
>> --
>> *Kalyan Chattopadhyay*
>>
Hey,
If you are good in VBA coding then you can search "pdf to excel convert
vba" and take reference.
Please see below the some useful urls-
https://www.linkedin.com/groups/1871310/1871310-74131482
http://quickvba.blogspot.in/2010/12/import-pdf-in-excel.html
http://www.vbaexpress.com/kb/getarti
No,
you can not add more thn 250 ppls
--
On Tue, Sep 13, 2016 at 2:03 PM, Pol Ktk wrote:
> is there any option in whatsup appln to add unlimited members(in single
> group)
> paid or free ?
>
> On 11 September 2016 at 11:50, Learner Excel wrote:
>
>> Thanks Prabhu!..
Thanks Prabhu!..
Happy to here from you!>=.
--
On Sun, Sep 11, 2016 at 11:31 AM, Prabhu Pinky
wrote:
> Hi Friends,
>
> Since i have created Whatsapp group for VBA Macro learners/experts.
>
> And i have added many peoples in this group. Please Msg me to 9500087194
> in whatsapp to get added in
Please go thru below url
http://dailydoseofexcel.com/archives/2015/02/13/converting-an-excel-range-to-html-the-hard-way/
--
On Sat, Sep 10, 2016 at 9:49 PM, Learner Excel wrote:
> Hey please refer enclosed sample workbook (excel table to html code)
>
>
>
> --
>
> On Sat,
Hey please refer enclosed sample workbook (excel table to html code)
--
On Sat, Sep 10, 2016 at 4:35 PM, Dheeraj Bankoti wrote:
> hi
> is any expert there in group who can short out the issue..
>
> Regards
> -- Forwarded message --
> From: Dheeraj Bankoti
> Date: Sun, Sep
Please refer below url
https://gist.github.com/jkatricak/801024
http://windowssecrets.com/forums/showthread.php/107929-VBA-code-to-HTML
http://dailydoseofexcel.com/archives/2011/09/20/roll-your-own-html-from-excel-vba/
--
On Sat, Sep 10, 2016 at 12:18 PM, Devendra Sahay <
devendrasahanypt...@gma
Who's making this group, please reply? else I can take initiave to do the
same.
--
On Sat, Sep 10, 2016 at 11:07 AM, Satheesh Arumugam Naidu <
satheesh.arumu...@gmail.com> wrote:
> please add 8861087687
>
> On Thu, Sep 8, 2016 at 1:01 PM, prkhan56 wrote:
>
>> Please add me
>> 8291577844
>> Rash
Try enclosed one
--
On Fri, Sep 9, 2016 at 9:37 AM, GENIUS wrote:
> working perfectly, thank you very much for your help
>
> one more question, if I have figures in column A as shown in the sheet
> and I want to take the 17% in column B of the amount of column A as shown
> in the attachment t
Is there any relation between both sheets? If yes you can use vlookup.
It would be great if you can upload (attache) some sample data with your
requirement
--
On Fri, Sep 9, 2016 at 5:17 PM, Sandeep Kumar Baranwal <
sandeepkumarbaran...@gmail.com> wrote:
> Hi
>
> I have a spreadsheet with two t
Opps you have register incorrect data type against variable j, data type
should be string
[image: Inline image 1]
--
On Thu, Sep 8, 2016 at 10:01 PM, GENIUS wrote:
>
> Sir
>>>
>> Thanks for your follow up, I enable which you have mentioned in the last
>> mail but there is another message pleas
Attachment missing
--
On Thu, Sep 8, 2016 at 9:59 PM, GENIUS wrote:
> Sir
>>
> Thanks for your follow up, I enable which you have mentioned in the last
> mail but there is another message please see the attachment
>
> right now I have three version of excel i.e. 2007,2010 & 2013, I opened
> th
ile if possible
>>
>> --
>>
>> On Wed, Sep 7, 2016 at 8:32 PM, Learner Excel wrote:
>>
>>> Can you please upload some same ASCII same file if possible
>>>
>>> --
>>>
>>> On Wed, Sep 7, 2016 at 8:25 PM, Pierre wrote:
>>&g
sorry typo error,
Can you please upload some sample ASCII file if possible
--
On Wed, Sep 7, 2016 at 8:32 PM, Learner Excel wrote:
> Can you please upload some same ASCII same file if possible
>
> --
>
> On Wed, Sep 7, 2016 at 8:25 PM, Pierre wrote:
>
>> the data is a
Can you please upload some same ASCII same file if possible
--
On Wed, Sep 7, 2016 at 8:25 PM, Pierre wrote:
> the data is an ASCII file that I need to parse
>
> On Wednesday, September 7, 2016 at 10:35:29 AM UTC-4, XLS S wrote:
>>
>> Hi Pirerre,
>>
>> Please help me understand -
>> 1. Is this
Is the data in PDF is text or image?
If text, please refer below urls for your reference
http://www.vbaexpress.com/kb/getarticle.php?kb_id=1101
http://www.ozgrid.com/forum/showthread.php?t=186024
https://acrobatusers.com/forum/general-acrobat-topics/search-text-pdf-vba-only-adobe-reader-installed
Hi Pirerre,
Please help me understand -
1. Is this in excel only?
2. There is any unique identifier if the blocks are more than one.
Suggestions -
1. We can you us Text to column than use some formulas to make table
2. You can extract value thru using LEFT,RIGHT formula
--
On Wed, Sep 7, 20
Brother, you have to add Outlook reference as well
[image: Inline image 1]
--
On Tue, Sep 6, 2016 at 9:18 AM, GENIUS wrote:
> Sir
>
> I'm waiting for your reply very anxiously
>
> --
> 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 offici
If the row count is really 60lac than I strongly suggest you to please use
MS-Access for any DB (like MYSql or MSSQL) as Excel have rows limit (10lac
only.)
--
On Tue, Sep 6, 2016 at 1:24 PM, Malungo Tomson Banda <
malungotoms...@gmail.com> wrote:
> I need help breaking a numerical data range.
You need to add "Microsoft Outlook 14.0 Object Library" in references
--
On Sat, Sep 3, 2016 at 10:10 PM, Izhar wrote:
>
> Please see the question in the attachment
>
> --
> 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
Please add 886006795
--
On Sat, Sep 3, 2016 at 8:17 AM, Ankit Monga wrote:
> Pls add my number 9560718272
>
> On Sep 3, 2016 7:19 AM, "Suhas" wrote:
>
>> Hi, Please add me to the whatsapp excel group. My Nbr +91 9791760609
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
For list of file name, use enclosed code.
--
On Fri, Sep 2, 2016 at 10:33 PM, Izhar wrote:
>
> Please open the file and see the question
>
> --
> 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
Hey Dheeraj
Please see below urls hope this will help
http://answers.microsoft.com/en-us/office/forum/office_2010-outlook/outlook-2010-some-names-in-sent-items-appear-in/c3c1ef47-6af0-44d5-bdec-ae7d4b0f7bef?auth=1
https://www.experts-exchange.com/questions/26282293/Single-Quotes-in-E-mail-Address
Yes, its working for me,
can you please share the screenshot.
thanks
--
On Sat, Aug 27, 2016 at 10:48 PM, Manju Keerthi
wrote:
> Was it working fine for you? i am getting error in the below two line
> (error #1044) so, Else part "Range("b2").Validation.Delete" is not
> working.
>
> .Add Type:
Try enclosed one.
--
On Sat, Aug 27, 2016 at 10:01 PM, Manju Keerthi
wrote:
> Thank you so much. This helped me a lot:-)
>
> Is there any option to disappear the dropdown when user does not have any
> value in column B. instead of disable the drop down in the column B.
>
> once again Thanks a l
HI Manju,
See this help you
--
On Sat, Aug 27, 2016 at 11:33 AM, Manju Deva wrote:
> Hi
>
>
>
> I need your help to create a macro for the below mentioned scenario.
>
>
>
> *Scenario*
>
>
>
> We need two columns namely User, drop down
>
>
>
> *“IF user enter data in User column(cells) a automa
WelCome Manju,
Keep posting and learn more and more.
Why you need this thru marco/VBA? Are you familiar with VBA or macor
--
On Sat, Aug 27, 2016 at 11:12 AM, Manju Keerthi
wrote:
> Hi,
>
> I am a beginner in excel i need your help to solve the following scenario
> i need to create a macro wh
34 matches
Mail list logo
