$$Excel-Macros$$ Multiple Order Should Pickup

2014-05-15 Thread Pravin Gunjal
Dear Friends, Greetings! I have attached an excel file. The data is already entered in this file and nothing can be changed. The "Qty" column must be multiple of "Pack" column. If it is correct then it should display: "Correct" otherwise "Incorrect" in "Result" column. Hope you would help me.

Re: $$Excel-Macros$$ What is Call Back URL...

2014-05-15 Thread Paul Schreiner
Remember:  Google is your friend.   searching for "Call Back URL" returns 1,530,000 hits.   with explanations and examples!  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 all the times you c

$$Excel-Macros$$ What is Call Back URL...

2014-05-15 Thread Kuldeep Singh
Dear All Champs, Please share, what is *Call Back URL*. thanks in advance. If you have any web developer please contact me urgently. Regards, Kuldeep Singh Assistant Manager Quality Game Zone India Limited Phone.: +91-8586978648 || naukrikuld...@gmail.com || *Please* *Consider the environment. Pl

Re: $$Excel-Macros$$ Excel macro from 2003 no longer works in Excel 2010

2014-05-15 Thread Paul Schreiner
For:  Workbooks("ESS CentreVu Stats Half").Worksheets("Mel").Range("b3").Value   Is the workbook "ESS CentreVu Stats Half" open?   I tested code with my workbook. It seems that the file extension must be included.   In my case: Workbooks("Ora_RMS_Flags_Master.xlsb").Sheets("Ora_PN").Range("B3").Va

$$Excel-Macros$$ Re: Help with a pop up window with relevant information upon clicking a value in cell

2014-05-15 Thread Prayank Vidyarthi
Hi Vaibhav, Thanks for the prompt response. It works. As I am an alien to VBA, I would appreciate if you could also help in fixing the formatting issue. Best regards Prayank On Thursday, May 15, 2014 2:16:21 PM UTC+5:30, Prayank Vidyarthi wrote: > > Hi, > > I have a dashboard with 3 columns a

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

2014-05-15 Thread Vaibhav Joshi
Welcome Prayank.. Cheers!! On Thu, May 15, 2014 at 2:27 PM, Prayank Vidyarthi < prayank.vidyar...@gmail.com> wrote: > Hi Excel Gurus! > > I am Prayank Vidyarthi from Gurgaon. I work for the Modigroup of companies > in the travel space as a Sr. Manager Business Planning. My role includes a > lo

Re: $$Excel-Macros$$ Here is a Great Challenge - Retrieve data in from a multiple urls in one step

2014-05-15 Thread Frank Zolf
Nice try, but this inverts the output and there is too much movement. So, it's not scalable. Anyone else? Challenge closes 10:00 GMT 20/05/2014. Optimise processor use and query intervals ;) On Wednesday, 14 May 2014 06:47:09 UTC+2, ashish wrote: > > try this code > > Sub Macro1() > > Dim i

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

2014-05-15 Thread Prayank Vidyarthi
Hi Excel Gurus! I am Prayank Vidyarthi from Gurgaon. I work for the Modigroup of companies in the travel space as a Sr. Manager Business Planning. My role includes a lots of analysis and number crunching, hence I landed here. Apart from work, I love to: Play Cricket and Table tennis, Draw and P

$$Excel-Macros$$ Help with a pop up window with relevant information upon clicking a value in cell

2014-05-15 Thread Prayank Vidyarthi
Hi, I have a dashboard with 3 columns as depicted below, where year means the period referred to, Newbees are the new agencies and Existing are the already existing agencies. Year Newbee Existing 2010-11 2.12 163.43 2011-12 7.92 206.04 2012-13 11.83 236.19 2013-14 16.95 237.90 What I want to

Re: $$Excel-Macros$$ ODS TO EXCEL CONVERSION PROBLEM

2014-05-15 Thread Vaibhav Joshi
what error you are getting? Share screen shot!! On Thu, May 15, 2014 at 12:59 AM, Renukachari Kasee wrote: > Dear experts please suggest > > how to convert bunch of openoffice clac ods formats in a folder i want > to convert > ods to xlsx format > > here i am sharing one the web resource, while

Re: $$Excel-Macros$$ Excel macro from 2003 no longer works in Excel 2010

2014-05-15 Thread Vaibhav Joshi
Hi What error you are getting, can you send screenshot?? Cheers!! On Thu, May 15, 2014 at 5:33 AM, Sabosis wrote: > Hello- > > I am getting an error message on a certain line in my module that always > worked before switching to Office 2010. The line checks for a zero value in > a cell and wi