Re: $$Excel-Macros$$ new querry

Hi Gandhi find the attachment and revert if it is not helpful. -- *Thanks & Regards Thamu * On Wed, Mar 2, 2011 at 10:45 AM, Nemi Gandhi wrote: > attached again with explanation. > > -- > Nemi Gandhi > 98204 92963 > > -- > > -

Re: $$Excel-Macros$$ 22 days left - Launch of discussexcel.com

Best use all the tags and change the tag after a week. On Thu, Mar 3, 2011 at 9:49 AM, Jenie wrote: > Hi Ayush, > > > > Welcome in Planet Excel > > Explore Excel Universe > > > > Planeto-Excel > > > > Universe in Excel > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@goo

RE: FW: $$Excel-Macros$$ Macro to Average a series of numbers in excel

You're the best, thanks again Dave -Original Message- From: Dilip Pandey [mailto:dilipan...@gmail.com] Sent: Wednesday, March 02, 2011 10:22 PM To: excel-macros@googlegroups.com Cc: Pehrson, Dave Subject: Re: FW: $$Excel-Macros$$ Macro to Average a series of numbers in excel Dear Dave,

RE: $$Excel-Macros$$ Macro to Average a series of numbers in excel

Thanks Dilip Your solution is great, and does exactly what i needed, your support is so very much appreciated. Thanks a Million Dave -Original Message- From: Dilip Pandey [mailto:dilipan...@gmail.com] Sent: Wednesday, March 02, 2011 10:17 PM To: excel-macros@googlegroups.com Cc: Pehrs

RE: $$Excel-Macros$$ New Web Query get data from existing open IE Browser instead of opening new browser window

Thanks for asking this, I have a similar problem. I hope Xls.Gurus will help.. Cheers -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of RCGUA Sent: Thursday, February 17, 2011 5:47 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Ma

RE: $$Excel-Macros$$ 22 days left - Launch of discussexcel.com

Hi Ayush, Welcome in Planet Excel Explore Excel Universe Planeto-Excel Universe in Excel From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of kanwaljit Singh Sent: Wednesday, March 02, 2011 2:54 PM To: excel-macros@googlegroups.com Subject: Re: $$

RE: $$Excel-Macros$$ Re: Ashish Koul : Most helpful Member

Congratulation Ashish... keep it up -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of DILIPandey Sent: Wednesday, March 02, 2011 3:07 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Re: Ashish Koul : Most helpful Member Con

RE: $$Excel-Macros$$ 20 days Left : Here is first Look of discussexcel.com

Great work Ayush.. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Vin@y Sent: Tuesday, March 01, 2011 11:17 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ 20 days Left : Here is first Look of discussexcel.com URL of the website pl

Re: $$Excel-Macros$$ Macro to Average a series of numbers in excel

Dear Dave, You are always welcome...!! :) Thanks, DILIPandey On 3/3/11, Pehrson, Dave wrote: > Thanks Dilip > > Your solution is great, and does exactly what i needed, your support is > so very much appreciated. > > Thanks a Million > > Dave > > -Original Message- > From: Dilip Pandey

Re: FW: $$Excel-Macros$$ Macro to Average a series of numbers in excel

Dear Dave, This is really a great group, no doubt about that. Little delay happened, apologies for that but I am 100% sure that no query remains unanswered in this group. I have just answered your query. Thanks for keeping up your hopes high :) Best Regards, DILIPandey On 3/3/11, Pehrson, Dave

Re: $$Excel-Macros$$ Re: Ashish Koul : Most helpful Member

congrats Sir ji... > > > On Mar 1, 8:38 pm, Ayush wrote: > > Hello Everyone, > > > > Ashish Koul has been selected as *'Most Helpful Member'* for the month of > > Feb 2011. > > He has posted 97 posts (13% of total posts) in February 2011 and helped > many > > people through his expertise. He has

Re: $$Excel-Macros$$ Emergency: Vba Code requested for PDF file has to be converted as Word Document.

its an image to convert it into text use "ocr to excel or word" converter . http://www.onlineocr.net/default.aspx able to extarct professional version On Thu, Mar 3, 2011 at 3:37 AM, ChilExcel wrote: > hi > > > I tried to make a portabel I have, but it is a picture ... can not be > transfor

Re: $$Excel-Macros$$ Emergency: Vba Code requested for PDF file has to be converted as Word Document.

hi I tried to make a portabel I have, but it is a picture ... can not be transformed to xls, I can only change the header of each page... I did not use macro, I just used my "portable" from PDF to XLS 2011/3/2 Rajasekhar Praharaju > > > hi experts, > > Please find the attached folder zip

Re: $$Excel-Macros$$ Re: Ashish Koul : Most helpful Member

Great contributions by Ashish. Keep up the good work. We need your help N.SHIVKUMAR Mobile : +919422613567 Office : +912332301775 Alternate Email: shiv1...@yahoo.com *Please consider the environment before printing this email.* On 2 March 2011 17:36, DILIPandey wrote: > Congrats Ashish...

Re: $$Excel-Macros$$ Re: Ashish Koul : Most helpful Member

congrats buddy Warm Regards, Harmeet Singh IT Analyst McKinsey & Company http://www.facebook.com/Harmeeet On Wed, Mar 2, 2011 at 11:06 PM, DILIPandey wrote: > Congrats Ashish...!! > > Best Regards, > DILIPandey > > On Mar 1, 8:38 pm, Ayush wrote: > > Hello Everyone, > > > > Ashish K

Re: $$Excel-Macros$$ Delete extra information from a cell

Thank you very much. This works perfectly. You guys are great!!! On Mar 2, 4:13 am, siti Vi wrote: > please test if it helps > > Sub BlaBlaBla() >    'siti Vi / jakarta, 2 mar 2011 >    Dim Dat As Range, r As Long, c As Integer >    Set Dat = Sheets(1).Cells(1).CurrentRegion >    For r

Re: $$Excel-Macros$$ Excel Interview Q & A

hai ayush' some of the questions asked by th interviewer how many if condition can be used in formulas... can we use custom formulas in pivot table... explain arguments in hlookup thanks sukumar On Tue, Mar 1, 2011 at 9:39 PM, Ayush wrote: > Hello Members, > > Since Excel skill is tested i

Re: $$Excel-Macros$$ Re: Ashish Koul : Most helpful Member

Congrats Ashish On Wed, Mar 2, 2011 at 5:36 PM, DILIPandey wrote: > Congrats Ashish...!! > > Best Regards, > DILIPandey > > On Mar 1, 8:38 pm, Ayush wrote: > > Hello Everyone, > > > > Ashish Koul has been selected as *'Most Helpful Member'* for the month of > > Feb 2011. > > He has posted 97 po

$$Excel-Macros$$ FW: VBA Lead Position with SYNTEL for PUNE Location

if anyone intrested.. -- Date: Wed, 2 Mar 2011 13:00:43 +0530 Subject: VBA Lead Position with SYNTEL for PUNE Location From: puja.st...@gmail.com To: puja.st...@gmail.com STEPS is an Executive Search Organization headquartered in New Delhi. We partner wit

Re: $$Excel-Macros$$ Delete extra information from a cell

See if you can adapt this: '- Option Explicit Public Const ForReading = 1, ForWriting = 2, ForAppending = 3 Sub ReadData()     Dim fso, ft, Str, CSVFile     Dim R     ThisWorkbook.Activate     Sheets("Sheet1").Select     CSVFile = "C:\temp\vba\Tes

$$Excel-Macros$$ Re: Please read and adhere to these Simple Rules

Thanks Chris for the feedback. Actually , You are right that each message includes email address , however we do not have any option to use Online Pseudonyms in Google Groups. We can only avoid using email address in the posts they made. I always encourage members to use better english in the po

Re: $$Excel-Macros$$ Re: Excel Interview Q & A

wow... "everyone knowledgeable knows that VBA performs slow when compared to inbuilt Excel functions" I guess my 18 years and 80,000 lines of VBA code don't qualify as "knowledgeable". Whenever possible, I try to use VBA code because I can get it done faster than inbuilt Excel functions! I ha

$$Excel-Macros$$ Please read and adhere to these Simple Rules

Ayush Jain, Comments on 'Please read and adhere to these Simple Rules'. 1 I agree with virtually all that you propose. 2 I agree with 'Don't put your email address in a post unless you're dying for more spam in your inbox. ' However, I note that each message auto

Re: $$Excel-Macros$$ 22 days left - Launch of discussexcel.com

Excelerator On Tue, Feb 22, 2011 at 11:29 PM, Ayush Jain wrote: > Dear members, > > I am too excited to share that discussexcel.com website development is in > good progress and we are ready to launch the website on 4th Anniversary of > ou

$$Excel-Macros$$ Re: Ashish Koul : Most helpful Member

Congrats Ashish...!! Best Regards, DILIPandey On Mar 1, 8:38 pm, Ayush wrote: > Hello Everyone, > > Ashish Koul has been selected as *'Most Helpful Member'* for the month of > Feb 2011. > He has posted 97 posts (13% of total posts) in February 2011 and helped many > people through his expertise.

$$Excel-Macros$$ Income Tax Calculater

Hi Dear Members Please any one can send me Tax Calculator in excel format. thanx <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> Sudhir Verma Asstt. Mngr. A/c's 9818479722 * P think Before you print * * ** Life is Very beautiful !!! * * ¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)

Re: $$Excel-Macros$$ Delete extra information from a cell

please test if it helps Sub BlaBlaBla() 'siti Vi / jakarta, 2 mar 2011 Dim Dat As Range, r As Long, c As Integer Set Dat = Sheets(1).Cells(1).CurrentRegion For r = 1 To Dat.Rows.Count c = InStr(1, Dat(r, 1), " 12 $", vbTextCompare) - 1 Dat(r, 2) = Left(Dat(r, 1), c) Next

RE:$$Excel-Macros$$ Investment Declaration

The query can be done using outlook forms... Tools->forms... A colleague in my previous organization has done it... So i don't have the complete idea... But for sure i can say that its possible using outlook forms... Thanks Vinod # # # Mail sent from handheld # # # --

$$Excel-Macros$$ Re: Excel Interview Q & A

The Favorited question happens to be "VLOOkUP" for me... on every interview this has been asked. The no of parameters (which is 4) and the last parameter (which is 0/1 or False and True). Next come the way to look up on the left which VLOOKUP can't do.. so INDEX and MATCH functions with OFFSET of c

$$Excel-Macros$$ Investment Declaration

Guys, I need a help of your expertise. I want to send email to all the employees of my organisation for their investment declaration. Would request your help that how will i do this. In Mail there is a table in which employee enter there declaration and press on submit button. as they press the