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 <xlst...@gmail.com> 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
>
> --
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.
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
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
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
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
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
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
No,
you can not add more thn 250 ppls
--
On Tue, Sep 13, 2016 at 2:03 PM, Pol Ktk <polkarnat...@gmail.com> 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 <
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
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 <xlst...@gmail.com> wrote:
> Hey please refer enclosed sample workbook (excel table to html code)
>
>
&g
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
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 <
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
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
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
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
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.
ou please upload some sample ASCII file if possible
>>
>> --
>>
>> On Wed, Sep 7, 2016 at 8:32 PM, Learner Excel <xls...@gmail.com> wrote:
>>
>>> Can you please upload some same ASCII same file if possible
>>>
>>> --
>>>
>>
sorry typo error,
Can you please upload some sample ASCII file if possible
--
On Wed, Sep 7, 2016 at 8:32 PM, Learner Excel <xlst...@gmail.com> wrote:
> Can you please upload some same ASCII same file if possible
>
> --
>
> On Wed, Sep 7, 2016 at 8:25 PM, Pierre <t
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
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
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,
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
>
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) !
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
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
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
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
>
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.
>
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
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
34 matches
Mail list logo