Re: $$Excel-Macros$$ Macro is not working

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

Re: $$Excel-Macros$$ Re: VBA macro - WhatsApp group.

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

Re: $$Excel-Macros$$ Macro not working

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) !

Re: $$Excel-Macros$$ I need help breaking a numerical data range. I have an excel worksheet with over 6000000 rows of dat

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.

Re: $$Excel-Macros$$ Macro not working

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 >

Re: $$Excel-Macros$$ Single Quotes Added to Email Address

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

Re: $$Excel-Macros$$ Re: how i convert pdf file to Excel using macro.

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

Re: $$Excel-Macros$$ VBA - How to extract text from blocks defined by “$begin” and “$end” ?

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,

Re: $$Excel-Macros$$ VBA - How to extract text from blocks defined by “$begin” and “$end” ?

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

Re: $$Excel-Macros$$ VBA - How to extract text from blocks defined by “$begin” and “$end” ?

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 >>> >>> -- >>> >>

Re: $$Excel-Macros$$ VBA - How to extract text from blocks defined by “$begin” and “$end” ?

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

Re: $$Excel-Macros$$ Macro not working

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.

Re: $$Excel-Macros$$ Macro not working

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

Re: $$Excel-Macros$$ Macro not working

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

Re: $$Excel-Macros$$ To seek help on writing Excel formula

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

Re: $$Excel-Macros$$ VBA Macro - Whatsapp Group

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 <

Re: $$Excel-Macros$$ Macro to extract datas from PDF form to Excel sheet

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

Re: $$Excel-Macros$$ Excel Table to HTML table

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 <

Re: $$Excel-Macros$$ Single Quotes Added to Email Address

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

Re: $$Excel-Macros$$ VBA Macro - Whatsapp Group

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

Re: $$Excel-Macros$$ Re: VBA macro - WhatsApp group.

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

Re: $$Excel-Macros$$ Single Quotes Added to Email Address

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

Re: $$Excel-Macros$$ VBA MACRO NEEDED (SIMPLE??)

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

Re: $$Excel-Macros$$ Re: Outlook 2016 - Macro Help!

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

Re: $$Excel-Macros$$ Macro run very slow

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

Re: $$Excel-Macros$$ Query on formula

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

Re: $$Excel-Macros$$ Re: Need help in macro

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. >

Re: $$Excel-Macros$$ Re: Need help in macro

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 >

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

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

Re: $$Excel-Macros$$ Need help in macro

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

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

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

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

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 > > --

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

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.

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

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