Re: $$Excel-Macros$$ Re: please help

2015-07-07 Thread Kumar Bhanushali
Dear Apoorve, It works. Thanks.. Regards, Kumar Bhanushali Re: $$Excel-Macros$$ Re: please help Apoorve Kumar to: excel-macros 07-07-15 06:10 PM Sent by: excel-macros@googlegroups.com Cc: kumar.bhanushali From: Apoorve Kumar To: excel-macros@googlegroups.com Cc

Re: $$Excel-Macros$$ Re: please help

2015-07-07 Thread Apoorve Kumar
Please check this file. Regards, Apoorve On Tuesday, July 7, 2015 at 5:05:38 PM UTC+5:30, Kumar Bhanushali wrote: > > *Dear Apoorve,* > > Please refer this sheet again > > > > > > > *Regards, Kumar Bhanushali* > > >*$$Excel-Macros$$ Re: please help* > *Apoorve Kumar * to: excel-

Re: $$Excel-Macros$$ Re: please help

2015-07-07 Thread Kumar Bhanushali
Dear Apoorve, Please refer this sheet again Regards, Kumar Bhanushali $$Excel-Macros$$ Re: please help Apoorve Kumar to: excel-macros 07-07-15 05:03 PM Sent by: excel-macros@googlegroups.com Cc: kumar.bhanushali From: Apoorve Kumar To: excel-macros@googlegroups.com Cc:

Re: $$Excel-Macros$$ Re: Please help with Activex "cannot insert object". error

2015-04-26 Thread Ashish Bhalara
Try to search after un-hide files from explorer Tools-Folder options-View. On Sun, Apr 26, 2015 at 1:28 PM, Rohit Jadhav wrote: > Hi Paul > I tried doing searching the .exd files in the appdata folder but as you > can see the attachment there is nothing in the search of the folder. Also I > have

Re: $$Excel-Macros$$ Re: Please help with Activex "cannot insert object". error

2015-04-24 Thread Paul Schreiner
Just to be sure, try changing to the  C:\users\[username]\Appdata  folder and search for *.exd from there. I actual found two but they evidently have been corrected.Since they're dated 3/24/2015 and 3/25/2015and are not causing a problem. Paul- “Do all the

RE: $$Excel-Macros$$ Re: Please Help

2013-12-13 Thread Ravinder
PFA, may be helpful for you, first select path where you want to save file. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of pmyk Sent: Friday, December 13, 2013 4:58 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Please Help Try th

Re: $$Excel-Macros$$ Re: Please help Excel Gurus

2013-06-04 Thread Vabz
PFA On Tuesday, June 4, 2013 11:14:15 AM UTC+5:30, Harish P Y wrote: > > Hi, > Thank you very much for replying to my quire y, > > firstly the amount needs to be calculated for a day and then equally > distributed for no of days in that particular month. kindly help me > regarding this. > > re

Re: $$Excel-Macros$$ Re: Please help Excel Gurus

2013-06-03 Thread Harish P Y
Hi, Thank you very much for replying to my quire y, firstly the amount needs to be calculated for a day and then equally distributed for no of days in that particular month. kindly help me regarding this. regards Harish With Regards *HARISH P Y* *P** **THINK BEFORE YOU PRINT:**Before printing

Re: $$Excel-Macros$$ Re: Please help - How to export specific range by ID to other excel file.

2012-11-26 Thread Anoop K Sharma
Hi Natron, I can't see any attachment here. Well, I hope you can simply get a range in a variable as follows: dim myRange as range set myRange= Worksheets(index).Range(define_range) and then you can call this range anywhere. Regards, Anoop On Wed, Nov 21, 2012 at 6:42 PM, Natron wrote: > My

Re: $$Excel-Macros$$ Re: Please help - How to export specific range by ID to other excel file.

2012-11-21 Thread Natron
My apologies Anoop, I hope you can understand my code, I tried to comment it at key locations. I attached a workbook the second go around. On Tuesday, November 20, 2012 9:38:32 PM UTC-5, Enrique Martin wrote: > It's better to attach the file and put you query there. > No one gonna study this co

Re: $$Excel-Macros$$ Re: Please help - How to export specific range by ID to other excel file.

2012-11-20 Thread Anoop K Sharma
It's better to attach the file and put you query there. No one gonna study this code as different people have different logic. Regards, Anoop On Tue, Nov 20, 2012 at 1:49 AM, Natron wrote: > This is close and might get you a kickstart. > > Sub selectme() > '' > 'Origina

Re: $$Excel-Macros$$ Re: Please help me.. on sumproduct

2012-10-18 Thread Vabz
Hi You can do that with simple Vlookup function. Rgds On Thursday, October 18, 2012 3:25:30 PM UTC+5:30, Manoj Kumar wrote: > > Hi, > > I want to know if coll "A" Data found in Coll "C", it found the value of > Coll "A". using sumproduct.. > > > On Thu, Oct 18, 2012 at 3:08 PM, Vabz > wrote: >

Re: $$Excel-Macros$$ Re: Please help me.. on sumproduct

2012-10-18 Thread Vabz
Hi Then you are getting correcr answer, try Multiplying 1 with Text Value eg. 1 x V5/A & G-040 results in to #VALUE!. You can get values only data is non text one. Rgds//Vabs On Thursday, October 18, 2012 3:25:30 PM UTC+5:30, Manoj Kumar wrote: > > Hi, > > I want to know if coll "A" Data found

Re: $$Excel-Macros$$ Re: Please Help to Find out the solution

2012-09-17 Thread Wassi Agnihotri
Hello Vabs, Thanks again.Really helpful group with helping hand. Love you all because you guys help without shouting. On Sat, Sep 15, 2012 at 5:15 PM, Vabz wrote: > Hi > > Thanks.. for acknowledgement!! :) > > Happy to Help Excel Lovers.. > > Cheerz.. > > Rgds//Vabs > > > On Saturday, Septem

Re: $$Excel-Macros$$ Re: Please Help to Find out the solution

2012-09-16 Thread Vabz
Hi Thanks.. for acknowledgement!! :) Happy to Help Excel Lovers.. Cheerz.. Rgds//Vabs On Saturday, September 15, 2012 5:04:02 PM UTC+5:30, Wassi wrote: > Hello Vabs. > > Hats off bro. Both of your solution are working for me. > Thank you. > > Cheers > > On Sat, Sep 15, 2012 at 4:52 PM

Re: $$Excel-Macros$$ Re: Please Help to Find out the solution

2012-09-15 Thread Wassi Agnihotri
Hello Vabs. Hats off bro. Both of your solution are working for me. Thank you. Cheers On Sat, Sep 15, 2012 at 4:52 PM, Vabz wrote: > HI > > You can also use this formual.. > > =OFFSET(A2,1,1,) for Company & =OFFSET(A2,1,2,) for Phone number > > After that copy & paste sepcial all data to its v

Re: $$Excel-Macros$$ Re: Please Help

2012-09-06 Thread dguillett1
ditto Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Paul Schreiner Sent: Thursday, September 06, 2012 6:27 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Please Help Have you read the "Forum Rules"? (Well, SOME are

Re: $$Excel-Macros$$ Re: Please Help

2012-09-06 Thread Paul Schreiner
Have you read the "Forum Rules"? (Well, SOME are more of a "guideline".)   1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. As an example: My Excel-

Re: $$Excel-Macros$$ Re: Please Help

2011-03-23 Thread sudhir kumar
hI bhushan thanking you On 23/03/2011, Bhushan Sabbani wrote: > =SUBTOTAL(9,$E$24:E25)-SUBTOTAL(9,$F$24:F25) > > The subtotal is the function which update the sum of number is the filter is > done. > > See the attached file of the clear understanding. > > When you drag the formula,As e24 ref. is

Re: $$Excel-Macros$$ Re: Please help - VBA book

2010-06-25 Thread flebber
I have the Excel VBA 2007 book by Mr Excel. It is a good book to get you up and running and it is good to reference back to. I still find using online resources and videos helpful as well. on the Mr Excel site you will find over 600 video podcasts(though video quality a little lacking) and a forum.

Re: $$Excel-Macros$$ Re: Please help - VBA book

2010-06-25 Thread Dilip Pandey
Dear Taruna, Try subscribing various online Google / Microsoft forums as well, which will benefit you in your learning. Start with Recording macro and then look out the codes in the visual basic editor. -- Thanks & Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilip

Re: $$Excel-Macros$$ Re: Please help In seperating alphabets and numbers from a cell

2010-05-07 Thread Rahul Gandhi.
Guys I am very Sorry for turning up very late and giving you an alarm with respect to that all the above formula will not work if we found any alphanumeric string Lets take an example if we have appended string then the above formula will not work. "Hello my 9711 no is in 77 alpha numeric 2297 st

Re: $$Excel-Macros$$ Re: Please help In seperating alphabets and numbers from a cell

2010-04-01 Thread Dipika Mallya
Great point Paul, @Abhi To add to Paul's Excell insight with a working example, Suppose two functional links. http://j.mp/gate2010csit http://j.mp/gate2010cs exist Does your function need to identify the csit link from the cs link or not. Regards, DM http://anonomi.com/iname http://anonomi.co