Re: $$Excel-Macros$$ Help required for changing the file name in a query programmatically

Basole, Thanks for your solution. Can you please send me the working example along with excel file with sample data. I tried your code with my data, and i am getting an error message. Regards Eugene On Saturday, August 23, 2014 7:04:59 PM UTC+5:30, Basole wrote: > > Hi, > > See this example

Re: $$Excel-Macros$$ Help required for changing the file name in a query programmatically

Hi, See this example extracts the data from your file T2308.xls (T & date: and change the name according to the current(or system date)), using ADO and SQL statement. regards. Basole 2014-08-23 8:55 GMT-03:00 Eugene Bernard : > Dear all, > > I am daily using the attached sample query file t

$$Excel-Macros$$ Help required for changing the file name in a query programmatically

Dear all, I am daily using the attached sample query file to extract data from an excel file stored in my windows desktop. I am pasting below a part of code from the test.dqy file, where I am daily changing the file name based on the date on which it is being run. Instead of changing it manually

Re: $$Excel-Macros$$ Help required on Macro

Jocky Beta >To: excel-macros@googlegroups.com >Sent: Sunday, June 29, 2014 11:41 PM >Subject: Re: $$Excel-Macros$$ Help required on Macro > > >Hi Team, > >Can anybody help me for converting above attached file to comfortable >for office 2010 as this file is made in

Re: $$Excel-Macros$$ Help required on Macro

Jun 2014 13:58:15 +0530 > Subject: Re: $$Excel-Macros$$ Help required on Macro > To: jocky6...@gmail.com > > Does this work ? > > > On Thu, Jun 26, 2014 at 1:46 PM, Jocky Beta wrote: > >> Hi all, >> >> Any hope regarding on the same. >> >

Re: $$Excel-Macros$$ Help required on Macro

>> > >> > But sheet provided by you is not working It's showing *"Can't exit >> design >> > mode because control Combobox5 can not be created" *error. >> > >> > could you please help me on this? >> > >> > Regards

Re: $$Excel-Macros$$ Help required on Macro

. > > could you please help me on this? > > Regards > > -- Forwarded message -- >> From: Manoj Garg >> Date: Wed, 25 Jun 2014 11:52:30 +0530 >> Subject: Re: $$Excel-Macros$$ Help required on Macro >> To: excel-macros@googlegroups.com, Jo

Re: $$Excel-Macros$$ Help required on Macro

gt; Date: Wed, 25 Jun 2014 11:52:30 +0530 > Subject: Re: $$Excel-Macros$$ Help required on Macro > To: excel-macros@googlegroups.com, Jocky Beta > > pfa > > > On Wed, Jun 25, 2014 at 11:05 AM, Jocky Beta wrote: > > > Hi Team, > > > > I got below attached s

RE: $$Excel-Macros$$ Help Required Urgent

Thanks Ravinder From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ravinder Sent: Wednesday, April 02, 2014 5:11 PM To: excel-macros@googlegroups.com Cc: Soum Subject: RE: $$Excel-Macros$$ Help Required Urgent PFA From: excel-macros@googlegroups.com

RE: $$Excel-Macros$$ Help Required Urgent

PFA From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Neeraj Chauhan Sent: Wednesday, April 02, 2014 4:43 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help Required Urgent Dear experts, Kindly find the attached sheet

$$Excel-Macros$$ Help Required Urgent

Dear experts, Kindly find the attached sheet. --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com -- 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$$ Help required on formula

Please help Regards On 3/29/14, Jocky Beta wrote: > Hi pramod, > > Please find the attached sheet in which i had explain what i required, > Request you to kindly go through it and help me to solve the problem. > > Regards > > > On Sat, Mar 29, 2014 at 10:13 AM, Pramod Singh wrote: > >> hey what

Re: $$Excel-Macros$$ Help required on formula

Hi pramod, Please find the attached sheet in which i had explain what i required, Request you to kindly go through it and help me to solve the problem. Regards On Sat, Mar 29, 2014 at 10:13 AM, Pramod Singh wrote: > hey what u want can u enplane complete... > > > On Sat, Mar 29, 2014 at 8:08

Re: $$Excel-Macros$$ Help required on formula

hey what u want can u enplane complete... On Sat, Mar 29, 2014 at 8:08 AM, Jocky Beta wrote: > Hi, > I have already assigned formula but its showing error. > > Please help me. > > Regards > > > On Fri, Mar 28, 2014 at 1:51 PM, Jocky Beta wrote: > >> Hi, >> >> Please help me on this _ >> >> >>

Re: $$Excel-Macros$$ Help required on formula

Hi, I have already assigned formula but its showing error. Please help me. Regards On Fri, Mar 28, 2014 at 1:51 PM, Jocky Beta wrote: > Hi, > > Please help me on this _ > > > Regards > > > On Fiday, March 28, 2014, Jocky Beta wrote: > > Hi All, > > > > Pls fin above attached sheet in which Q

Re: $$Excel-Macros$$ Help required on formula

Hi, Please help me on this _ Regards On Fiday, March 28, 2014, Jocky Beta wrote: > Hi All, > > Pls fin above attached sheet in which Query sheet when i type any word related to Item code ELEC0001 (Kindly see the master sheet) it will search the Item Name automatically. But when i put bulb it's

$$Excel-Macros$$ Help required on formula

Hi All, Pls fin above attached sheet in which Query sheet when i type any word related to Item code ELEC0001 (Kindly see the master sheet) it will search the Item Name automatically. But when i put bulb it's not showing any vale as well as Item name also. hence request you to kindly help me on th

Re: $$Excel-Macros$$ help required urgently

1. change date format in d/mm/ 2. change text to column 3.now use date function to combined date again Divaker On Thu, Mar 27, 2014 at 4:04 PM, Neeraj Chauhan wrote: > Dear experts, > > > > We have givne below date format how to convert right format of date like > 13-Jan-2014 > > > > TT Mo

$$Excel-Macros$$ help required urgently

Dear experts, We have givne below date format how to convert right format of date like 13-Jan-2014 TT Modified Date & Time 13/01/2014 15/01/2014 19:51 2-Nov-14 1-Jun-14 2-Nov-14 15/01/2014 19:57 1-Jun-14 13/01/2014 17:10 15/01/2014 19:47 18/01/2014 15:44 Descr

Re: $$Excel-Macros$$ Help Required

com > *Subject:* $$Excel-Macros$$ Help Required > > > > Hi Friends, > > > > > > > > Please find the attachment. > > Help Please > > > > -- > Thanks £ Regards > Rakesh Kumar > +91-9650303464 > > > > -- > Are you =EXP(E:RT) o

RE: $$Excel-Macros$$ Help Required

PFA From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rakesh kumar Sent: Friday, January 24, 2014 4:26 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help Required Hi Friends, Please find the attachment. Help Please

$$Excel-Macros$$ Help Required

Hi Friends, Please find the attachment. Help Please -- Thanks £ Regards Rakesh Kumar +91-9650303464 -- 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 of this forum @ https://www.facebook.com/discussexcel FORUM RU

RE: $$Excel-Macros$$ Help required for PDF Stamp

@googlegroups.com Subject: $$Excel-Macros$$ Help required for PDF Stamp Dear Experts, Greetings! I am using Blue Beam software (PDF) and I have a query that in PDF we used stamp & e-sign. My requirement is as below: - I am receive documents by mail and printing the same and once a

$$Excel-Macros$$ Help required for PDF Stamp

Dear Experts, Greetings! I am using Blue Beam software (PDF) and I have a query that in PDF we used stamp & e-sign. My requirement is as below: - I am receive documents by mail and printing the same and once again scanning and sending to other user by email. I like to use electroni

Re: $$Excel-Macros$$ help required on attached Macro

Hi, I don't have password for this file is there any alternative way to complete same. On Thu, Oct 17, 2013 at 2:03 PM, Anil Gawli wrote: > Dear Jocky, > > Kindly unlock the password and resend. > > Warm Regards, > Gawli Anil > Thanks & Regards, > Gawli Anil Narayan > Software Developer, >

Re: $$Excel-Macros$$ help required on attached Macro

Dear Jocky, Kindly unlock the password and resend. Warm Regards, Gawli Anil Thanks & Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Thu, Oct 17, 2013 at 1:59 PM, Jocky Beta wrote: > Hi Team, > > Can anybody fix this attached error for me. i am also attachi

RE: $$Excel-Macros$$ Help required in a small formula.....

-Macros$$ Help required in a small formula. Hello Experts, Kindly find attached the file, and can anyone please explain me why the results are comming different by using the same kind of formula in the column no. E2 and E4? Thanks in advance. -- Indrajit Disclaimer: This

Re: $$Excel-Macros$$ Help required in a small formula.....

This formula have 6 part *=1-(**(B3/D2)^2**+**(B4/D2)^2**+**(B5/D2)^2**+**(B5/D2)^2**+**(B6/D2)^2**+**(B7/D2)^2**)* And this Only 5 Part, Purple part was missing *=1-(**(1/5)^2**+**(1/5)^2**+**(1/5)^2**+**(1/5)^2**+**(1/5)^2**)* On 12-10-2013 3:52, Indrajit $nai wrote: Hello Experts, Kindly fi

$$Excel-Macros$$ Help required in a small formula.....

Hello Experts, Kindly find attached the file, and can anyone please explain me why the results are comming different by using the same kind of formula in the column no. E2 and E4? Thanks in advance. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confident

Re: $$Excel-Macros$$ Help required in formula.....

s@googlegroups.com] *On Behalf Of *Indrajit $nai > *Sent:* Friday, October 04, 2013 7:13 AM > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Help required in formula. > > ** ** > > Hi Ravinder, > > ** ** > > Actually it wa

Re: $$Excel-Macros$$ Help required in formula.....

d > drag > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai > *Sent:* Thursday, October 03, 2013 1:29 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Help required in formu

RE: $$Excel-Macros$$ Help required in formula.....

googlegroups.com] On Behalf Of Indrajit $nai Sent: Thursday, October 03, 2013 5:56 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help required in formula. Hi Experts, PFA, kindly let me know is there any formula to sum-up the col B nos into col D. As of now I am do

Re: $$Excel-Macros$$ Help required in formula.....

t; ** ** > > Next > > ** ** > > End Function > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai > *Sent:* Thursday, October 03, 2013 5:56 AM > *To:* excel-macros@googlegroups.com

$$Excel-Macros$$ Help required in formula.....

Hi Experts, PFA, kindly let me know is there any formula to sum-up the col B nos into col D. As of now I am doing it manually, but it's very long term process! Kindly let me know is there any way out to do it through any formula. Thanks in advance. -- Indrajit Disclaimer: This electronic mes

Re: $$Excel-Macros$$ Help Required : How i import Data in Excel from DBF File & Get Max voucher Number

,* > > *Ravi Kumar.* > > ** ** > > *From:* excel-macros@googlegroups.com [ > mailto:excel-macros@googlegroups.com ] *On > Behalf Of *Ravinder > *Sent:* Wednesday, September 11, 2013 3:56 PM > *To:* excel-macros@googlegroups.com > *Cc:* Soum > *Subjec

RE: $$Excel-Macros$$ Help Required : How i import Data in Excel from DBF File & Get Max voucher Number

cel-macros@googlegroups.com <mailto:excel-macros@googlegroups.com> Cc: Soum Subject: RE: $$Excel-Macros$$ Help Required : How i import Data in Excel from DBF File & Get Max voucher Number Use below formula or attached file.may be u r looking for this.. =IF(A2="",&

RE: $$Excel-Macros$$ Help Required : How i import Data in Excel from DBF File & Get Max voucher Number

mber 11, 2013 2:19 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help Required : How i import Data in Excel from DBF File & Get Max voucher Number Dear All, I have a DBF Table containing Vouchers Month wise like 70001 (Dated : 05-July-13) 70002 (Dated : 08-July-13) 8

RE: $$Excel-Macros$$ Help Required : How i import Data in Excel from DBF File & Get Max voucher Number

Pls provide example file for more clarification. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of rashid memon Sent: Wednesday, September 11, 2013 2:19 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help Required : How i import Data in

$$Excel-Macros$$ Help Required : How i import Data in Excel from DBF File & Get Max voucher Number

Dear All, I have a DBF Table containing Vouchers Month wise like 70001 (Dated : 05-July-13) 70002 (Dated : 08-July-13) 80001 (Dated : 02-August-13) Now i want to get New voucher # by month wise like : New # 70003 dated 15-July-13 or New # 80002 dated 18-Aug-13 Kindly Help me in this regard

Re: $$Excel-Macros$$ Help Required

Hi pfa Anil Kumar From: Neeraj Chauhan To: excel-macros@googlegroups.com Sent: Wednesday, 17 July 2013 3:41 PM Subject: $$Excel-Macros$$ Help Required Dear experts,   How to subtract time in hours and minute   10:30 AM -  10:30 PM

Re: $$Excel-Macros$$ Help Required

Please find attachment. it might help you On 7/17/13, Neeraj Chauhan wrote: > Dear experts, > > > > How to subtract time in hours and minute > > > > > 10:30 AM > > - 10:30 PM > > = > > > > > > Thanks & Regards > > Neeraj Chauhan > > +91-9756706350 > > neerajchauhan...@gmail.com > > > > -

$$Excel-Macros$$ Help Required

Dear experts, How to subtract time in hours and minute 10:30 AM - 10:30 PM = Thanks & Regards Neeraj Chauhan +91-9756706350 neerajchauhan...@gmail.com -- 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

Re: $$Excel-Macros$$ Help required to change cursor colour in excel sheet

You can do this type of thing, but only by using VBA (or macros) - there is no built in Excel setting to control this. There is one massive drawback, and that is that this technique will use something called "Event Procedures", which means that the macro will fire every time you move the cursor -

$$Excel-Macros$$ Help required to change cursor colour in excel sheet

Dear Seniors, It is possible to change cursor colour in excel sheet from black to green. If yes, then please help me and provide resolution. Thanks in advance. Thanks Ashish -- 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 Fac

Fwd: $$Excel-Macros$$ HELP REQUIRED - TOP 3 VALUES

*With Simple Formula.* -- Forwarded message -- From: Kuldeep Singh Date: Thu, May 23, 2013 at 2:35 PM Subject: Re: $$Excel-Macros$$ HELP REQUIRED - TOP 3 VALUES To: "excel-macros@googlegroups.com" Hi, PFA... Regards, Kuldeep Singh Assistant Manager Quality

Re: $$Excel-Macros$$ HELP REQUIRED - TOP 3 VALUES

Hi, PFA... Regards, Kuldeep Singh Assistant Manager Quality Game Zone India Limited Phone.: +91-9716615535 || naukrikuld...@gmail.com || *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* * * On Thu, May 23, 2013 at 2:23 PM, Prashant Pawle wrote: >

Re: $$Excel-Macros$$ Help Required

Hi Priti Great work, Thanku so much. Thank Raeksh k On Wed, May 1, 2013 at 9:56 AM, priti verma wrote: > Hi Rakes, > Yes you can do this without using another column.Please see the > attachement. > Regards, > Priti verma > > > On Tue, Apr 30, 2013 at 6:12 PM, Rakesh kumar wrote: > >> Hi priti,

Re: $$Excel-Macros$$ Help Required

Hi Rakes, Yes you can do this without using another column.Please see the attachement. Regards, Priti verma On Tue, Apr 30, 2013 at 6:12 PM, Rakesh kumar wrote: > Hi priti, > thanks for the help, > Is it possible without using another column. > > > > On Tue, Apr 30, 2013 at 5:49 PM, priti verma

Re: $$Excel-Macros$$ Help Required

Hi priti, thanks for the help, Is it possible without using another column. On Tue, Apr 30, 2013 at 5:49 PM, priti verma wrote: > Hi Rakesh, > Please see the attachment. > Regards, > Priti verma > > > On Tue, Apr 30, 2013 at 5:22 PM, Rakesh kumar wrote: > >> Thanks Prafull >> >> >> >> >> On Tue

Re: $$Excel-Macros$$ Help Required

Hi Rakesh, Please see the attachment. Regards, Priti verma On Tue, Apr 30, 2013 at 5:22 PM, Rakesh kumar wrote: > Thanks Prafull > > > > > On Tue, Apr 30, 2013 at 4:47 PM, Prafull Jadhav > wrote: > >> Dear Rakesh, >> >> find the same. >> >> Regards, >> Prafull jadhav. >> >> >> On Tue, Apr 30, 2

Re: $$Excel-Macros$$ Help Required

Thanks Prafull On Tue, Apr 30, 2013 at 4:47 PM, Prafull Jadhav wrote: > Dear Rakesh, > > find the same. > > Regards, > Prafull jadhav. > > > On Tue, Apr 30, 2013 at 4:37 PM, Ahmed Honest wrote: > >> Rakesh: >> >> Run Pivot table, if no Idea just google it to learn Pivot tables / go to >> youtub

Re: $$Excel-Macros$$ Help Required

Dear Rakesh, find the same. Regards, Prafull jadhav. On Tue, Apr 30, 2013 at 4:37 PM, Ahmed Honest wrote: > Rakesh: > > Run Pivot table, if no Idea just google it to learn Pivot tables / go to > youtube to learn pivot table. You will learn less time. > > Start exploring. > > Thanks, > > > > >

Re: $$Excel-Macros$$ Help Required

Rakesh: Run Pivot table, if no Idea just google it to learn Pivot tables / go to youtube to learn pivot table. You will learn less time. Start exploring. Thanks, On Tue, Apr 30, 2013 at 2:04 PM, Rakesh kumar wrote: > Hi Friends, > > I have some problem in excel, please help me. > > column A

$$Excel-Macros$$ Help Required

Hi Friends, I have some problem in excel, please help me. column A is having list of company and column B having a name of seals Representative.some company name are repeated by some seals representative. so i want find out no of unique company name by each seals representative. -- Thanks £ R

Re: $$Excel-Macros$$ help required

Hello, Please elaborate on this statement "I want formudata for e which is unique date agains each site" It s not clear. Thankyou On Sat, Apr 13, 2013 at 3:22 AM, Neeraj Chauhan wrote: > Dear experts, > > ** ** > > Kindly find the attached sheet > > -- > Are you =EXP(E:RT) or =NOT(E

Re: $$Excel-Macros$$ help required.

Dear Rakesh, Pl find attached herewith FYI. Warm Regards, Gawli Anil On Fri, Mar 8, 2013 at 3:53 PM, Rakesh Sharma wrote: > can we arrange rearrange spellings in Excel column. > > like i want to arrange my name > > hsekar to rakesh > > > -- > ** > RA

Re: $$Excel-Macros$$ Help required in Bifurcation of data from one column to another two

Sure. 1. When you import the text file, choose *Delimited* and put " (inverted commas) in the *Other* field. This will take address in a separate column. Adjust the values of addresses by removing first blank cell. 2. After you have imported, insert a column after the name and choose *Text to Colu

Re: $$Excel-Macros$$ Help required in Bifurcation of data from one column to another two

Perfect Abhishek, Thanx a lot, may I ask you, which formulae or function is been used to do this ? Please... Regards Sandeep On Wed, Feb 20, 2013 at 2:02 PM, Abhishek Jain wrote: > Does this work for you? > > > On Wed, Feb 20, 2013 at 1:46 PM, Sandeep wrote: >> >> Thanx Abhishek, >> >> Still w

Re: $$Excel-Macros$$ Help required in Bifurcation of data from one column to another two

Does this work for you? On Wed, Feb 20, 2013 at 1:46 PM, Sandeep wrote: > Thanx Abhishek, > > Still waiting for my query to be resolved, meanwhile I'm sharing the > .txt file for your better insight. > > > Regards > > Sandeep > > On Wed, Feb 20, 2013 at 12:34 PM, Abhishek Jain > wrote: > > Hi

Re: $$Excel-Macros$$ Help required in Bifurcation of data from one column to another two

Thanx Abhishek, Still waiting for my query to be resolved, meanwhile I'm sharing the .txt file for your better insight. Regards Sandeep On Wed, Feb 20, 2013 at 12:34 PM, Abhishek Jain wrote: > Hi Sandeep, > > Welcome to the group. I hope that the experts here would help resolve your > query.

Re: $$Excel-Macros$$ Help required in Bifurcation of data from one column to another two

Hi Sandeep, Welcome to the group. I hope that the experts here would help resolve your query. Meanwhile, could you also share with us the text file (in its original format) from which you have imported this data. I believe it would help in getting a better insight. Thanks, Abhishek On Wed, Fe

$$Excel-Macros$$ Help required in Bifurcation of data from one column to another two

Dear Experts, This is my first interaction with this group though I have been a member of this group for a long. Let me introduce my self as Sandeep, works for the Hospital in Accounts department. Most of my work is related with excel and I do have a sound knowledge of excel but not to the expert

Re: $$Excel-Macros$$ Help Required

Hi Sriram, Try this "=SUBSTITUTE(A206,CHAR(160),"")" On Sat, Feb 2, 2013 at 5:31 PM, sriram ji wrote: > Dear Excel Guru, > > I want remove space after the data. Any one can suggest Excel formula for > below attached file. > > Thanks & Regards, > Sriram G > Chennai. > > > > -- > Ar

Re: $$Excel-Macros$$ HELP REQUIRED

Pl provide a meaningfull subject. Warm Regards, Gawli Anil On Fri, Jan 11, 2013 at 10:57 AM, joginder kumar wrote: > HI GUROPS MEMBER , > > > PLEASE HELP REGARDING THIS SHEET . > > -- > Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use

Re: $$Excel-Macros$$ Help required

*Mr Neeraj,* *Pl always write the useful subject to your mails to get immediate response on your queries...* * * *Regards,* *Pravin. * On Mon, Dec 10, 2012 at 5:02 PM, neeraj chauhan wrote: > Dear Experts, > > kindly find the attached sheet, this long file i am not able to pivot. i > am not able t

$$Excel-Macros$$ Help Required on : Sending an Auto generated E-mail, If there is any Value in the Pivot

Dear Masters, Good evening... Could you kindly help me in sending an Auto generated e-mail Only when there is a value in the Pivot. Enclosed more info in the Excel sheet. Thanks in advance !!! JP -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RUL

Re: $$Excel-Macros$$ HELP REQUIRED FOR me

_ From: Somnath Khadilkar To: excel-macros@googlegroups.com Sent: Sun, November 4, 2012 9:10:28 AM Subject: $$Excel-Macros$$ HELP REQUIRED FOR me Dear SIrs,   I have an XL file with few sheets [ DATANov01] One of the sheets contain general info named -common info .   One sheet na

Re: $$Excel-Macros$$ Help Required

Hi neeraj, see the attachment. -- ***Best Regards, Ms Excel User * On Fri, Nov 2, 2012 at 5:39 PM, neeraj chauhan wrote: > Dear Experts, > > kindly find the attached sheet. > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RU

Re: $$Excel-Macros$$ Help Required

Hi, use this =ROUND(C3,2) On Fri, Nov 2, 2012 at 5:39 PM, neeraj chauhan wrote: > Dear Experts, > > kindly find the attached sheet. > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for violation) > > 1) Use

Re: $$Excel-Macros$$ Help Required

hi Neeraj, You can just use the Ctrl+Shift+~ key for general format. Aamir Shahzad On Fri, Nov 2, 2012 at 5:21 PM, sunil jagtap wrote: > Hi Neeraj, > > Please try below formula > > =ROUND((C3*100),2) > > Thanks and Regards, > Sunil > > > > On Fri, Nov 2, 2012 at 5:39 PM, neeraj chauhan > wrote

Re: $$Excel-Macros$$ Help Required

Hi Neeraj, Please try below formula =ROUND((C3*100),2) Thanks and Regards, Sunil On Fri, Nov 2, 2012 at 5:39 PM, neeraj chauhan wrote: > Dear Experts, > > kindly find the attached sheet. > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RU

$$Excel-Macros$$ Help Required

Dear Experts, kindly find the attached sheet. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula

Re: $$Excel-Macros$$ Help Required

Dear Sriram, Please try it.. Sub NTest() Dim a$, b$, c$ Dim i% a$ = Range("A1").Value For i = 1 To Len(a$) b$ = Mid(a$, i, 1) If b$ Like "[A-Z,a-z,0-9 ]" Then c$ = c$ & b$ End If Next i Range("B1").Value = c$ End Sub On Wed, Oct 10,

Re: $$Excel-Macros$$ Help Required

Hi Sriram, Use this =SUBSTITUTE(A1,"!","") and you are change to the special character. -- *Regards,* * * *Excel Beginner* * * On Wed, Oct 10, 2012 at 4:02 PM, sriram ji wrote: > Dear Excel Guru, > > Any formula for removing special character ex (!, -, &,~,?,_,;,',). Please >

$$Excel-Macros$$ Help Required

Dear Excel Guru, Any formula for removing special character ex (!, -, &,~,?,_,;,',). Please Help me. Thanks & Regards, Sriram G (chennai) -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use conci

$$Excel-Macros$$ HELP REQUIRED

Dear Groups Member Please Help me, i have attached one Sheet i need that when we fill Sheet 2 then automatically update Annual, Monthly & Sheet -1 -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Us

Re: $$Excel-Macros$$ Help Required

its working fine All cells marked with green are input cells . Just follow the instructions and enter the data in requested format only On Sat, Oct 6, 2012 at 2:51 PM, Hari Nair wrote: > I am attaching an excel utility file which I have downloaded form Central > Excise Web site to File online re

Re: $$Excel-Macros$$ Help Required

Thanks jeet!! On Thu, Oct 4, 2012 at 3:27 PM, jeet singh wrote: > Dear Friend, > > Plz find the attached file. > > > > On Thu, Oct 4, 2012 at 2:40 PM, Neeraj wrote: > >> Dear Experts >> >> ** ** >> >> Kindly see the attached sheet and urgently req. >> >> -- >> Join off

Re: $$Excel-Macros$$ Help Required

Dear Friend, Plz find the attached file. On Thu, Oct 4, 2012 at 2:40 PM, Neeraj wrote: > Dear Experts > > ** ** > > Kindly see the attached sheet and urgently req. > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM

$$Excel-Macros$$ Help Required

Dear Experts Kindly see the attached sheet and urgently req. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Pleas

Re: $$Excel-Macros$$ help required

Pls share a sample workbook with group On Wed, Aug 1, 2012 at 2:36 PM, ARUN(°•¤a®µn¤•°™) wrote: > Dear Members, > Need a macro for converting one subtotal part into diffrent sheets from a > workbook. > 10x & regards > Arun > > > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1

Re: $$Excel-Macros$$ help required

pl share us with some files.. Regards, Gawli Anil. On Wed, Aug 1, 2012 at 2:36 PM, ARUN(°•¤a®µn¤•°™) <> wrote: > Dear Members, > Need a macro for converting one subtotal part into diffrent sheets from a > workbook. > 10x & regards > Arun > > > > -- > FORUM RULES (986+ members already BANNED for v

$$Excel-Macros$$ help required

Dear Members, Need a macro for converting one subtotal part into diffrent sheets from a workbook. 10x & regards Arun -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code

Re: $$Excel-Macros$$ Help:- Required VBA Code for Restrict Previous Week Data Entry......

Thanks Noorain it's working fine, thank for your valuable support. On Mon, Jul 16, 2012 at 4:15 PM, Anil Gawli wrote: > dear noorian > Thanks Bro... > > > Regards, > Gawli Anil > > On Mon, Jul 16, 2012 at 3:45 PM, NOORAIN ANSARI > wrote: > >> Dear Anil Bro, >> >> Please right click on

Re: $$Excel-Macros$$ Help:- Required VBA Code for Restrict Previous Week Data Entry......

dear noorian Thanks Bro... Regards, Gawli Anil On Mon, Jul 16, 2012 at 3:45 PM, NOORAIN ANSARI wrote: > Dear Anil Bro, > > Please right click on Toolbox goto Additional Control and select Microsoft > Date and Time Picker. > > see attached screenshot > > or > > if your system doesn't support Dat

Re: $$Excel-Macros$$ Help:- Required VBA Code for Restrict Previous Week Data Entry......

dear noorian How u add the Dt picker in user form... pls let me know.. Regards Gawli Anil On Mon, Jul 16, 2012 at 3:04 PM, NOORAIN ANSARI wrote: > Dear DS, > > Please try it.. > > *Private Sub CommandButton1_Click() > Dim i As Integer > Dim dt As Date > i = Cells(Rows.Count, "A").End(xlUp).Row

Re: $$Excel-Macros$$ Help:- Required VBA Code for Restrict Previous Week Data Entry......

Dear DS, Please try it.. *Private Sub CommandButton1_Click() Dim i As Integer Dim dt As Date i = Cells(Rows.Count, "A").End(xlUp).Row + 1 dt = Me.DTPicker1 With Application.WorksheetFunction If .WeekNum(dt) > (.WeekNum(Date) - 1) Then Cells(i, 1) = Me.DTPicker1.Value Else MsgBox "Restricted Last

Re: $$Excel-Macros$$ Help:- Required VBA Code for Restrict Previous Week Data Entry......

Dear Dhartikumar Pls share us with some data. Regards, Gawli Anil On Mon, Jul 16, 2012 at 12:46 PM, Dhartikumar Sahu <> wrote: > awaiting for reply.. > > > -- Forwarded message -- > From: Dhartikumar Sahu > Date: Mon, Jul 16, 2012 at 10:18 AM &

Re: $$Excel-Macros$$ help required for creating a formula

Hi, Also try... =SUMIF(A7:A291,D7,B7:B291) On Fri, May 18, 2012 at 8:10 AM, Seraj Alam wrote: > Hi Ashish, > > You can try below formula also... > > > =INDEX(B:B,MATCH(D7,A:A,0)) > > > On Wed, May 16, 2012 at 6:03 AM, ashish damor wrote: > >> Dear Sir, >> >> Thanks for your very useful and pro

Re: $$Excel-Macros$$ help required for creating a formula

Dear Sir, Thanks for your very useful and prompt reply. I am really very grateful to you. Take care. With regards, Ashish On 5/16/12, Prajakt Pande wrote: > Dear Ashish Damor, > > solved, sheet attached. > > > > =VLOOKUP(D7,$A$7:$B$291,2,0) > > > Thanks & Regards, > Prajakt Pande > +97155138

Re: $$Excel-Macros$$ help required for creating a formula

Dear Ashish Damor, solved, sheet attached. =VLOOKUP(D7,$A$7:$B$291,2,0) Thanks & Regards, Prajakt Pande +971551388482 ** On Wed, May 16, 2012 at 1:48 PM, ashish damor wrote: > Dear All, > > I have a list of industry in one column and in corresponding column > the rates as per industry are

$$Excel-Macros$$ help required for creating a formula

Dear All, I have a list of industry in one column and in corresponding column the rates as per industry are given. I want to create a formula whereby when i selected a specific industry from the dropdown list automatically the corresponding rate is displayed in next cell. I am enclosing my workshe

Re: $$Excel-Macros$$ Help required on how to create iterative formula

Thank you so much for all your help On Thu, May 3, 2012 at 9:30 AM, David Grugeon wrote: > If you want to calculate for a different net amount (m) just put the new > value in the cell at the top marked "Target". All the calcs will then > change. You can also change (h) if required but if

Re: $$Excel-Macros$$ Help Required to update off days in a tracker

hello everyone, please help with the query below. Regards Seema On Saturday, 5 May 2012 17:54:42 UTC+5:30, Seema wrote: > hi, > > thankyou. the tracker looks good. but it allows the user to have the same > day off for two consecutive weeks. and also allows the user to choose > multiple da

Re: $$Excel-Macros$$ Help Required to update off days in a tracker

hi, thankyou. the tracker looks good. but it allows the user to have the same day off for two consecutive weeks. and also allows the user to choose multiple days off in the same week. please help in putting these two conditions. 1. the user should not be allowed to have the same day off for 3

Re: $$Excel-Macros$$ Help Required to update off days in a tracker

hi, Thanks for the solution. the Tracker is working fine except that it allows the user to have the same day for the second consecutive week. The user should not be allowed to take the same day off for 3 consecutive weeks. Ex: if user has monday as off for week1, then the user should not be

Re: $$Excel-Macros$$ Help Required to update off days in a tracker

i have made some changes in Noorain's code :) [?] PFA *Regards,* *Lalit Mohan* *https://www.facebook.com/buzinesstransformation* On Fri, May 4, 2012 at 11:16 PM, Seema wrote: > hi, > > thank you for the effort. but the sheet is not getting upd

Re: $$Excel-Macros$$ Help Required to update off days in a tracker

hi, thank you for the effort. but the sheet is not getting updated instead throws an error asking to debug at line15. also, please let me know the logic applied here. Regards On Friday, 4 May 2012 22:51:29 UTC+5:30, NOORAIN ANSARI wrote: > Dear Vaseema, > > Please see attached workbook, Hope

Re: $$Excel-Macros$$ Help Required to update off days in a tracker

Dear Vaseema, Please see attached workbook, Hope it will help to you. -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Fri, May 4, 2012 at 11:29 AM, Seema wrote: > > hello, > > i am using a form as a user interface for an employee to enter the off

Re: $$Excel-Macros$$ HELP REQUIRED IN MACRO FUNCTION

or the formula. > > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille...@gmail.com > > *From:* Sourabh Salgotra > *Sent:* Friday, May 04, 2012 1:03 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ HELP REQUIRED IN MACRO FUNCTION

<    1   2   3   4   5   >