Re: $$Excel-Macros$$ Moving Completed rows to sheet2

2014-09-23 Thread Vaibhav Joshi
Ok, chk this.. Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Sep 22, 2014 at 9:38 PM, Eugene Bernard eugene.bern...@gmail.com wrote: Dear Joshi, Thanks for your reply. As already explained in my first post, rows having code with 11 is not

Re: $$Excel-Macros$$ If Condition Problem

2014-09-23 Thread Vaibhav Joshi
Hi Also you may be required to set myAddIn.Installed = True when condition is met,, because once addin is disabled it wont get automatically enabled/installed. CHeers!! + *I did not do this for you. God is here working through me for you.* On Tue, Sep 23, 2014 at 10:06 AM, my excel

Re: $$Excel-Macros$$ Loop in cell in different sheet in a workbook

2014-09-23 Thread Paul Schreiner
can you give me an example? I tried a couple of things to see if it could get VBA to act up. No luck... seems to work fine in Excel 2010. Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At

Re: $$Excel-Macros$$ Loop in cell in different sheet in a workbook

2014-09-23 Thread Vaibhav Joshi
Hi Fill data in relevant cells of sheet1 to get values in sheet 2. Starring cell is C32 in Sheet 1 after that looping is done offsetting 10 rows 10 column. PFA, macro is working correctly Cheers!! + *I did not do this for you. God is here working through me for you.* On Fri, Sep 19,

$$Excel-Macros$$ Example of Userform with Tabstrip or Multipage

2014-09-23 Thread Paul Schreiner
I've got a very robust Excel 2010 application that reads from an Oracle database to build a multi-sheet document (utilizing different templates). Currently there are 28,751 lines of VBA code to support this specific application. The document retrieved from Oracle can have anywhere from 2 to 300

Re: $$Excel-Macros$$ Macro to highlight Max Value in a Column and copy/transpose data in another file

2014-09-23 Thread prkhan56
Hello All, Can someone help me with the Second Macro? Thanks On Monday, September 22, 2014 7:34:17 PM UTC+4, prkhan56 wrote: Hi Pramod, Thanks for your prompt reply. Works great! The second macro should run when the Cell Pointer is in Column T on a Highlighted Cell (in red). *Can red

Re: $$Excel-Macros$$ Moving Completed rows to sheet2

2014-09-23 Thread Eugene Bernard
Exactly. Thank you so much Joshi. Is it possible to add the rows in sheet2, without removing existing rows in sheet2. Regards Eugene On Tue, Sep 23, 2014 at 12:07 PM, Vaibhav Joshi v...@vabs.in wrote: Ok, chk this.. Cheers!! + *I did not do this for you. God is here working through

Re: $$Excel-Macros$$ SumProduct

2014-09-23 Thread SUDHIR VERMA
Dear Ravi, what is use of -- before B2:B13 in above formula. Please explain. On 13 September 2013 16:28, Ravi Kumar excellearn2...@gmail.com wrote: Hi, Try this.. =SUMPRODUCT((E1=A2:A13)*(--B2:B13=F1)*(C2:C13=G1)*(D2:D13)) *Warm Regards,* *Ravi Kumar.* *From:*

Re: $$Excel-Macros$$ SumProduct

2014-09-23 Thread Waseem Saifi
It converts values in Boolean (TRUE or FALSE, 1 or 0) which are enclosed in bracket after --. On Tue, Sep 23, 2014 at 10:40 AM, SUDHIR VERMA newinex...@gmail.com wrote: Dear Ravi, what is use of -- before B2:B13 in above formula. Please explain. On 13 September 2013 16:28, Ravi Kumar

Re: $$Excel-Macros$$ Moving Completed rows to sheet2

2014-09-23 Thread Vaibhav Joshi
Yes.. Remove line which clears existing data in sheet 2 from code.. If you need help then do tell me. Cheers On Sep 23, 2014 9:42 PM, Eugene Bernard eugene.bern...@gmail.com wrote: Exactly. Thank you so much Joshi. Is it possible to add the rows in sheet2, without removing existing rows in

Re: $$Excel-Macros$$ Macro to highlight Max Value in a Column and copy/transpose data in another file

2014-09-23 Thread Pramod Singh
Hi prkhan56 , Please find the your second macro.Kindly see the path as i mention your attached file.[File2.xlsb] your will be second file. Thanks P On Tue, Sep 23, 2014 at 9:23 PM, prkhan56 prkha...@gmail.com wrote: Hello All, Can someone help me with the Second Macro? Thanks On

Re: $$Excel-Macros$$ Moving Completed rows to sheet2

2014-09-23 Thread Vaibhav Joshi
Try this... Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Sep 23, 2014 at 11:54 PM, Vaibhav Joshi v...@vabs.in wrote: Yes.. Remove line which clears existing data in sheet 2 from code.. If you need help then do tell me. Cheers On Sep 23,

$$Excel-Macros$$ for updating the worksheet through the user form

2014-09-23 Thread Shankar Bheema
Good morning all, I am attaching an excel workbook which is meant for office file tracking. On the worksheet I placed commandbutton namely Entry Form. Which enables entry of the data into the sheet. Entry fields will be initially filled upto TIMEIN column. From the Timeout, entry of columns