Re: $$Excel-Macros$$ Re: URGENT HELP( CONDITION SEARCH OF UNIQUE TEXT)

its super one.. + *I did not do this for you. God is here working through me for you.* On Wed, Oct 1, 2014 at 7:37 PM, Rajan Verma wrote: > in J1 > > =LOOKUP(1,N(COUNTIF(D2:H2,D2:H2)>1))=1 > > Regards > Rajan. > > On Thursday, 25 September 2014 11:15:01 UTC-6, SUDHIR VERMA wrote: >> >> Dear

Re: $$Excel-Macros$$ Re: URGENT HELP( CONDITION SEARCH OF UNIQUE TEXT)

thanking you so much On 1 October 2014 19:37, Rajan Verma wrote: > in J1 > > =LOOKUP(1,N(COUNTIF(D2:H2,D2:H2)>1))=1 > > Regards > Rajan. > > On Thursday, 25 September 2014 11:15:01 UTC-6, SUDHIR VERMA wrote: >> >> Dear Experts, >> >> Kindly resolve my problem. >> >> Explanation in attached workb

$$Excel-Macros$$ Re: URGENT HELP( CONDITION SEARCH OF UNIQUE TEXT)

in J1 =LOOKUP(1,N(COUNTIF(D2:H2,D2:H2)>1))=1 Regards Rajan. On Thursday, 25 September 2014 11:15:01 UTC-6, SUDHIR VERMA wrote: > > Dear Experts, > > Kindly resolve my problem. > > Explanation in attached workbook. > > Thanking You > > Regards > Sudhir > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT))

$$Excel-Macros$$ Re: URGENT Help! How to display "Period" the data has been selected through the timeline.

Hi Lalit, No I don't want the timeline to scroll down. What I want is that suppose I have the timeline on top of the dashboard. I select a particular period to view. If you notice that on the time line it displays the period you have selected (E.g. Q1 2014 or Jan-Feb 2014). But if I scroll down

$$Excel-Macros$$ Re: URGENT Help! How to display "Period" the data has been selected through the timeline.

What you want whenever you scroll down the timline should also scroll down? On Friday, 27 June 2014 14:59:45 UTC+5:30, Prayank Vidyarthi wrote: > > Hi Excel Gurus, > > I need your help as I am really stuck over here. I have data starting from > Nov 2012 till March 2014. I have created various cha

$$Excel-Macros$$ Re: URGENT - Help regarding SaveasPDF Macro for Excel

you should try with two add on printer software adobe pdf printer or bullzip printer. Thanks Chintan On Thursday, January 23, 2014 9:22:29 AM UTC+5:30, Aatmik Muchhal wrote: > > My code is - > > Sub SavePDF() > ' pdf Macro > Application.ScreenUpdating = False > Sheets("Invoice").Select >

Re: $$Excel-Macros$$ Re: Urgent Help.

PFA.. solved On Sat, Oct 5, 2013 at 11:23 AM, Rakesh kumar wrote: > Please find the attachment. > > > > On Sat, Oct 5, 2013 at 11:22 AM, Rakesh kumar wrote: > >> >> Dear Friend, >> >> i want to use total no of present or absent list using pivot table. >> >> Please find the attachment. >> >> >> -

$$Excel-Macros$$ Re: Urgent Help.

Please find the attachment. On Sat, Oct 5, 2013 at 11:22 AM, Rakesh kumar wrote: > > Dear Friend, > > i want to use total no of present or absent list using pivot table. > > Please find the attachment. > > > -- > Thanks £ Regards > Rakesh Kumar > +91-9650303464 > > > -- Thanks £ Regards Rak

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

Hello Arpita, A little confusion in the part "=><1/-1" If you want to SUM all >0 values, you can use * =SUMIF(A1:A16,">0",A1:A16)* If you are looking to SUM between >=-1 to 1 (minus 1 to positive 1), use * =SUM(SUMIF(A1:A16,{">=**-**1",">1"},A1:A16)*{1,-1})* HTH Haseeb On Monday, February 27,

$$Excel-Macros$$ Re: Urgent Help

> Dear santosh, > > Please follow below link > > http://www.techbookreport.com/tutorials/fso1.html > > Thanks & regards, > Noorain Ansari > http://excelmacroworld.blogspot.com/ > http://noorain-ansari.blogspot.com/ > > - Show quoted text - > > On Sat, Sep 10, 2011 at 10:01 AM, Santosh V

$$Excel-Macros$$ Re: Urgent Help Graph

See if this helps, haven't tested it though. On Mon, Aug 8, 2011 at 4:01 PM, Sundarvelan N wrote: > Hi Friends, > > I need one help. > > I have 5 to 6 graphs in a sheet. On clicking a combo box respective graph > should pop up. Please help me. > Thanks > N.Sundarvelan > 9600160150 > > --

Re: $$Excel-Macros$$ Re: Urgent help required in vba coding!!!!!!!!!!!!!!!!!!!!!

*Thanks Milindthanks a lot.* On Mon, Mar 7, 2011 at 10:05 AM, mkarnik wrote: > Quick reply for 2nd point: > IN VBE, > Select: > Tools / VBA Project Propoerties / Protection > Now enable "Lock Project for Viewing", enter password twice and click > on OK. > Most Imp: Do not forget the passowr

$$Excel-Macros$$ Re: Urgent help required in vba coding!!!!!!!!!!!!!!!!!!!!!

Quick reply for 2nd point: IN VBE, Select: Tools / VBA Project Propoerties / Protection Now enable "Lock Project for Viewing", enter password twice and click on OK. Most Imp: Do not forget the passowrd. regards, Milind On Mar 6, 3:52 pm, "Indrajit $nai" wrote: > Hi All, > > I need a urgent help

Re: $$Excel-Macros$$ Re: Urgent help Invoice Macro modification

The solution was sent through mail. Is the solution working fine, reply back. Regards, Kishan Reddy, K On Jul 29, 8:33 am, Nagendra Modupalli wrote: > Hi Team, > > The password is correct "STPIInvoices" in this up to STPII is CAPS letter > nvoices is small latters. > > Please let me know if you

Re: $$Excel-Macros$$ Re: Urgent help Invoice Macro modification

Hi Team, The password is correct "STPIInvoices" in this up to STPII is CAPS letter nvoices is small latters. Please let me know if you have any questions on this.Thanks in advance. *Private Sub cmdPrint_Click() Set objDataSheet = Me.Parent.Sheets("Data") objDataSheet.Unprotect "STPIInvo

$$Excel-Macros$$ Re: Urgent help Invoice Macro modification

Code is not opening, The password might be wrong. Kishan Reddy, K On Jul 27, 10:21 am, Nagendra Modupalli wrote: > Hi Team, > > I have Invoices printing macro.It is printing row wise.I want to modify > customer wise.Can you please help me.Thanks in advance. > > And also i have attached my macro

$$Excel-Macros$$ Re: Urgent Help needed regarding using macro

Use This formula just change the range =SUMPRODUCT(MAX(($A$2:$A$100=A3)*($D$2:$D$100))) -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/excelda

$$Excel-Macros$$ Re: Urgent Help Required in a macro

Hi ZAC, I have created a user form as per your needs. The shortcut is CTRL + Y and userform will pop up on this shortcut. The data will be updated on click of submit button. The fields will reset on data successfully updated. Please have a look and let me know if any further assistance is require

Re: $$Excel-Macros$$ Re: Urgent Help Needed!!

Regards - Dave. > > -- > Date: Thu, 7 Jan 2010 12:36:39 +0530 > > Subject: Re: $$Excel-Macros$$ Re: Urgent Help Needed!! > From: pkkara...@gmail.com > > To: excel-macros@googlegroups.com > > Hello Anish, > > Please check the attached file and let me know if this is what y

Re: $$Excel-Macros$$ Re: Urgent Help Needed!!

Jan 2010 12:36:39 +0530 > > Subject: Re: $$Excel-Macros$$ Re: Urgent Help Needed!! > From: pkkara...@gmail.com > > To: excel-macros@googlegroups.com > > Hello Anish, > > Please check the attached file and let me know if this is what you were > looking for. > > run the

RE: $$Excel-Macros$$ Re: Urgent Help Needed!!

Hey Praveen, Good solution. I didn't think of doing it by macro. Pretty silly when this is a macro group! Regards - Dave. Date: Thu, 7 Jan 2010 12:36:39 +0530 Subject: Re: $$Excel-Macros$$ Re: Urgent Help Needed!! From: pkkara...@gmail.com To: excel-macros@googlegroups.com Hello Anish, P

Re: Thanks praveen, Dave, Ankur!! Re: $$Excel-Macros$$ Re: Urgent Help Needed!!

multibyte character strings >> >> Regards, >> Praveen >> >> On Wed, Jan 6, 2010 at 3:57 PM, Anish Shrivastava >> wrote: >> >>> Experts >>> >>> Please help....or advice if it is possible... >>> >>>

Thanks praveen, Dave, Ankur!! Re: $$Excel-Macros$$ Re: Urgent Help Needed!!

gt; -- Forwarded message -- >> From: Anish Shrivastava >> Date: Tue, Jan 5, 2010 at 2:29 PM >> Subject: Re: $$Excel-Macros$$ Re: Urgent Help Needed!! >> To: excel-macros@googlegroups.com >> >> >> Hi Dave, >> >> Attached please find

Re: $$Excel-Macros$$ Re: Urgent Help Needed!!

> Date: Tue, Jan 5, 2010 at 2:29 PM > Subject: Re: $$Excel-Macros$$ Re: Urgent Help Needed!! > To: excel-macros@googlegroups.com > > > Hi Dave, > > Attached please find the file with sample data, I have seprated titles > Character wise...we have 3 categories.. > ENGLI

Fwd: $$Excel-Macros$$ Re: Urgent Help Needed!!

Experts Please helpor advice if it is possible... -- Forwarded message -- From: Anish Shrivastava Date: Tue, Jan 5, 2010 at 2:29 PM Subject: Re: $$Excel-Macros$$ Re: Urgent Help Needed!! To: excel-macros@googlegroups.com Hi Dave, Attached please find the file with

Re: $$Excel-Macros$$ Re: Urgent Help Needed!!

at 6:43 PM, Dave Bonallack wrote: > Please attach a workbook with a sample of English and non-English > characters > Regards - Dave > > -- > Date: Mon, 4 Jan 2010 15:40:08 +0530 > Subject: $$Excel-Macros$$ Re: Urgent Help Needed!! > From: anish..

RE: $$Excel-Macros$$ Re: Urgent Help Needed!!

Please attach a workbook with a sample of English and non-English characters Regards - Dave Date: Mon, 4 Jan 2010 15:40:08 +0530 Subject: $$Excel-Macros$$ Re: Urgent Help Needed!! From: anish@gmail.com To: excel-macros@googlegroups.com Experts!!! Any updates on below query?? Thanks

$$Excel-Macros$$ Re: Urgent Help Needed!!

Experts!!! Any updates on below query?? Thanks!! ANISh On Wed, Dec 30, 2009 at 1:31 PM, Anish Shrivastava wrote: > Hello Experts, > > Thank you very much for helping me on my earlier queries. > Could you please help me in finding cells which contains multibyte > characters. > I mean how can we

$$Excel-Macros$$ Re: Urgent help on simple macro

Hi Vinod Try the Macro below. Sub update() Dim x As Integer x = 3 Do While Sheet1.Cells(x, 2).Value <> "" If Sheet1.Cells(x, 4).Value = "Core" Then Sheet1.Cells(x, 2).Value = "PAT" End If x = x + 1 Loop End Sub -- -

$$Excel-Macros$$ Re: Urgent help required with Date/Time Format

Just have to add ' in front of Time to make it text. Then can be used in the formula as desired outcome _ From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Amitabh Bose Sent: Friday, August 07, 2009 3:45 PM To: VBA_ Google Subject: $$Excel-Macros$$ Ur

$$Excel-Macros$$ RE: Urgent help required with Date/Time Format-DisRegard

Hi All, Apologies for sending this request. I seem to have found out the solution. I wasted one whole hour trying to figure out something which was simple, but I seem to have over looked how the formatting is done. Please do not waste your time on this request. Apologies once again.

$$Excel-Macros$$ Re: Urgent help requird

Hi,Swanand/Vivekplease find the attached copy,hope this explains how I required, Advance thanks, regards, Shiva On Mon, Aug 3, 2009 at 3:12 PM, vivek agrawal wrote: > Hi Shivashankar > > cal u please clarufy in which structure or format do you require the result > in > > Thanks and Regards, >

$$Excel-Macros$$ Re: URGENT HELP

Excellent Norman , this solved my problem, Thanks,Appreciated Best regards Rajesh On Mon, Aug 3, 2009 at 4:29 PM, Norman May wrote: > Rajesh, > > Try the formula below: > =INDEX(B1:B12,MATCH(9.99E+307,B1:B12)) > > Norman > > On Mon, Aug 3, 2009 at 1:01 AM, Rajesh Janardanan wrote:

$$Excel-Macros$$ Re: URGENT HELP

Rajesh, Try the formula below: =INDEX(B1:B12,MATCH(9.99E+307,B1:B12)) Norman On Mon, Aug 3, 2009 at 1:01 AM, Rajesh Janardanan wrote: > > Dear All, > Need an urgent help , please refer the attached file , I need a formula > which will read YTD (B13) as the last cell entered , in the

$$Excel-Macros$$ Re: Urgent help requird

Hi Shivashankar cal u please clarufy in which structure or format do you require the result in Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Mon, Aug 3, 2009 at 1:44 PM, shivashankar katageri < shankarkatag...@gmail.com> wrote

$$Excel-Macros$$ Re: Urgent help requird

Shivashankar, I suggest you give us a sample format in which you want to see the data so that it is easier then. Regards, Swanand Deshpande Cell: +91- 90110 99165 From: shivashankar katageri Sent: Monday, August 03, 2009 1:44 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Urg

$$Excel-Macros$$ Re: URGENT HELP

hi Venkatesh, Can u give me a suggestion on the If command u have mentioned? Best regards rajesh On Mon, Aug 3, 2009 at 9:34 AM, Rajesh Janardanan wrote: > yes Venkatesh, it will be Jan to December only, please advise me withe > the if command > > Best regards > rajesh > > On Mon, Aug 3, 2009

$$Excel-Macros$$ Re: URGENT HELP

sorry guys.. looks like i am too late...to reply sorry ... On 8/3/09, Rajesh Janardanan wrote: > > Guys, > > I am waiting for an answer , Please respond > > Best regards > rajesh > > > On Mon, Aug 3, 2009 at 8:01 AM, Rajesh Janardanan wrote: > >> >> Dear All, >> Need an urgent help , please ref

$$Excel-Macros$$ Re: URGENT HELP

rajesh can you confirm if the number of rows in just 13 or will it cross more than that... if its just Jan to Dec.. we can fix it with an simple {if condition.. } or else we need to find other ideas.. Regards Venkatesh On 8/3/09, Rajesh Janardanan wrote: > > > Dear All, > Need an urgent hel

$$Excel-Macros$$ Re: URGENT HELP

Guys, I am waiting for an answer , Please respond Best regards rajesh On Mon, Aug 3, 2009 at 8:01 AM, Rajesh Janardanan wrote: > > Dear All, > Need an urgent help , please refer the attached file , I need a formula > which will read YTD (B13) as the last cell entered , in the attached file > B9

$$Excel-Macros$$ Re: urgent Help Required

some cells aren´t entered as date. Their values are text with the format xx-xx-xx You´ve to enter every cell and change it to date, and then format the number as you wish... 2009/7/13 sachin patil > Hi, > > I'm Very new for this group.I'm facing problem in Excel in Date Formatting. > When I'

$$Excel-Macros$$ Re: urgent Help Required

Hi Sachin, You have entered date which seems as date but actually are strings. You have to write dated in the format mm/dd/yy. So your date should be 03/31/09, not 31-03-09. This will solve your problem Regards, Upendra Singh +91-9910227325, +91-9310760597

$$Excel-Macros$$ Re: urgent Help Required

Hi, Use text to column wizard in 3rd step select date and "DMY" format all your dates will be converted to data format Regards Sathish Jalendran From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of sachin patil Sent: 13 July 2009 PM 03:00 To: Excel S

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

Hello, Plz let me know below query. On Thu, Jul 2, 2009 at 2:26 PM, vinod rao wrote: > Hello, > > Can i know how was radio icon created linked to year 1,2 3.? > > Thanks in advance. > Vinod > > On Wed, Jul 1, 2009 at 5:09 PM, Sachin Shukla wrote: > >> Dear Dilip, >> >> Thanks a lot. Its working

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

Hello, Can i know how was radio icon created linked to year 1,2 3.? Thanks in advance. Vinod On Wed, Jul 1, 2009 at 5:09 PM, Sachin Shukla wrote: > Dear Dilip, > > Thanks a lot. Its working. > > > Thanks > > Sachin Shukal > > On Wed, Jul 1, 2009 at 3:57 PM, Dilip Pandey wrote: > >> Hi Sachin

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

Dear Dilip, Thanks a lot. Its working. Thanks Sachin Shukal On Wed, Jul 1, 2009 at 3:57 PM, Dilip Pandey wrote: > Hi Sachin, > > Attached sheet has been solved. Thanks, > -- > DILIP KUMAR PANDEY > MBA-HR,B COM(Hons.),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.c

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

Hi Sachin, Attached sheet has been solved. Thanks, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Tue, Jun 30, 2009 at 11:53 AM, Sachin Shukla wrote: > Dear All, > > Please provied me help on attached sheet

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

Dear Daniel, Thanks a lot for prompt respense. your formula is working properly. But I could not understood logic. Can you explain your fourmula please?. Why you multiply by 5 in (g3-1). Thanks Sachin Shukla On Tue, Jun 30, 2009 at 7:25 PM, Daniel wrote: > Try : > > =SUM(OFFSET(D13,(G3-1)*

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

I forget to link Here is the file. - Original Message - From: Sachin Shukla To: excel-macros@googlegroups.com Sent: Tuesday, June 30, 2009 11:53 AM Subject: $$Excel-Macros$$ Urgent Help Required Dear All, Please provied me help on attached sheet. Thanks Sachin Sh

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

Hello Sachin can find the attached solution for your problem, You are doing it in a long way (wrong) as there are only 9 choices and you are going to use about 27 conditions (if conditions) for your solution, but i used only 8. Remember if you are using IF function for a problem with N choices

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

Try : =SUM(OFFSET(D13,(G3-1)*5,0,D2,1)) In cell D45. HTH Daniel De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De la part de Sachin Shukla Envoyé : mardi 30 juin 2009 08:23 À : excel-macros@googlegroups.com Objet : [Norton AntiSpam] $$Excel-Macros$$ Urgent Help Re

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

Hi Sachin, Please find enclosed the file as per your requirement. Please let me know does that suffice your need. On 6/30/09, Sachin Shukla wrote: > > Dear All, > > Please provied me help on attached sheet. > > > Thanks > > Sachin Shukla > > > > > -- Thanks & Regards Ankit Mehra --~--~---

$$Excel-Macros$$ Re: Urgent help

: Monday, June 29, 2009 10:08 AM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Re: Urgent help Hi, try this code Activeworkbook.saveas(Thiswookbook.path & "\" ClinentName & format(now (),"ddmmhhmm")&".xls") With regards BALA On Jun 2

$$Excel-Macros$$ Re: Urgent Help required!!!! Please help!!!

Hi Dilip, Thanks a lot for your respose. This is something which i am expecting to perform. However, i forgot to mention one thing in my previous mail. It would be great if a macro could be created, where all these things (which you have made in the file) could be automatically keeping in mind t

$$Excel-Macros$$ Re: Urgent help

Hi, try this code Activeworkbook.saveas(Thiswookbook.path & "\" ClinentName & format(now (),"ddmmhhmm")&".xls") With regards BALA On Jun 27, 5:14 pm, "Chidurala, Shrinivas " wrote: > Dear Friends > > I want file should be save like client name with current date & time > > e.g. > > ICICI

$$Excel-Macros$$ Re: Urgent help

Not sure what you question is exactly about... but If you want a macro to open automatically, each time a user opens a file 1. , then save the macro in "Personal Workbook". This is a default workbook which is always hidden. 2. create an add-in or if you don't want a macro to open each time automa

$$Excel-Macros$$ Re: Urgent help

There are two places for a macro that opens automatically. One is to create a macro in a Module. You can either rename your macro to Auto_Open, or create a new macro called Auto_Open and within it, run your macro. Another way is to create a Workbook_Open event in the ThisWorkbook module. In this

$$Excel-Macros$$ Re: Urgent Help required

Can you please send the sample text file.. Regards, Andy On Fri, Jun 12, 2009 at 8:10 AM, Balachander S wrote: > May be this is very simple for you experts . I am unable to crack the > converiosn from Test file to excel for the data below. > > The fields are not aligned to draw column lines for

$$Excel-Macros$$ Re: Urgent help to split the column values

Hi Akshu, The best and quick way is "Text - to -Column" feature of the excel. I believe, if we do it by a function then we might have to drag that to the end of the columns/ rows (IV or 65536) or else VBA is the sure shot answer for your query. Thanks, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.)

$$Excel-Macros$$ Re: Urgent help to split the column values

Please check out the attachment. Regards, Mudassar Ramzan - Original Message - From: Akshu Bhagat To: excel-macros@googlegroups.com Sent: Wednesday, June 03, 2009 3:46 PM Subject: $$Excel-Macros$$ Urgent help to split the column values Hi everyone, I want each name of

$$Excel-Macros$$ Re: Urgent Help in Access

Hi Prashanth, Write the below query and let me know if it is working: Update Test1 Set Test1.Month = Month.Month Where Test1.Weekno. = Month.Weekno Regards, Upendra Singh 9910227325 From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Prash

$$Excel-Macros$$ Re: Urgent help filter macro

havent heard, still waiting for the answer, wake up... --- On Tue, 4/14/09, shannu shannu wrote: From: shannu shannu Subject: Urgent help filter macro To: excel-macros@googlegroups.com Date: Tuesday, April 14, 2009, 10:16 AM Hi All,       Can anyone help me in creating a macro.

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

Good idea, but we can come out of that situation. Harish, Just put a line in the macro before msgbox: activeworbook.save hope that solves the issue On Tue, Apr 14, 2009 at 8:55 PM, santosh bahuguna wrote: > > working with share file is much diffcult to fix this problem in excel > becouse ev

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

working with share file is much diffcult to fix this problem in excel becouse every user will seat in different different pcs and everytime user have save the data to make the data sheet update my suguestion is this please user msaccess to perform this task thank santosh bahuguna On 4/11/09,

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

Hi Harmeet, I used the other macro to fix my date and time issue since I was trying to link this date and time with availble field in raw data but this was refreshing so time was also refreshed but anyway I have fixed that but eventually I have found that the data acquired is always misses the fir

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

One more thing, You can also use shortcuts to enter time/date. *Ctrl+;* to enter date and *Ctrl+shift+;* to enter time. On Mon, Apr 13, 2009 at 7:00 PM, Harmeet Singh wrote: > Hi Harish, > First of all, Thanks a lot for appreciation. > If now I do the changes that you have mentioned in your ma

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

Hi Harish, First of all, Thanks a lot for appreciation. If now I do the changes that you have mentioned in your mail, will be a spoon feeding. I have not protected the code that I have sent you. It would be a good learning for you if you try and do it by yourself. You just need to write two lines s

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

Thanks a lot Harmeet... Can u also get me one more functionality here that as soon as one agent acquires the job time and date he acquired also appears and untill he finishes the job by selecting as close which will be a drop down in next column to acquired time column. Once agent uses close from d

$$Excel-Macros$$ Re: Urgent Help needed : Excel Headers

Thankss it worked :-) On 4/9/09, Manoj S Negi wrote: > > Hi Mahreen, > > Follow the below mentioned procedure for the same. > 1. go to the file menu > 2. select page setup > 3. click on sheet tab > 4. there is option "Rows to repeat at top" click on that and give the range > of required field > 5

$$Excel-Macros$$ Re: Urgent Help needed : Excel Headers

Dear The following codewill put a Left headerin each worksheetin the w

$$Excel-Macros$$ Re: Urgent Help needed : Excel Headers

Hi Mahreen, Follow the below mentioned procedure for the same. 1. go to the file menu 2. select page setup 3. click on sheet tab 4. there is option "Rows to repeat at top" click on that and give the range of required field 5. than come back by click on ok and print it. *Unfeigned Regards Manoj

$$Excel-Macros$$ Re: urgent help req.

Thanks Aindril !!! its working --- On Sat, 4/4/09, Aindril De wrote: From: Aindril De Subject: $$Excel-Macros$$ Re: urgent help req. To: excel-macros@googlegroups.com Date: Saturday, 4 April, 2009, 9:33 AM Hi Sashank   if u enter the value in cell A1 and want to see the decimal

$$Excel-Macros$$ Re: urgent help req.

Hi Sashank if u enter the value in cell A1 and want to see the decimal value in A2 then just type =A1/100 in the cell A2. Regards, Andy On Sat, Apr 4, 2009 at 1:46 AM, shashank bhosle < catchshashankbho...@yahoo.co.in> wrote: > HI All, > I am having a Excel file where i need to imput the Nume

$$Excel-Macros$$ Re: urgent help req.

Hi Puneet, If there is no requirement of calculation in blank cells, just remove them. Or probably try out exporting the data to access and work. Regards Hari Kumar _ From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of PUNEET NASA S

$$Excel-Macros$$ Re: Urgent Help need to count values

Dear Ashish, Thank U so much. The marco is working fine in module. But, It don't update automatically. Everytime we will edit it and press enter. But if we have lots of data then it is not possible to edit & press enter everytime. For that we has checked Tools Menu - Options - Calculations - Au

$$Excel-Macros$$ Re: Urgent Help need to count values

Hi Kori, It happens sometimes just close the file and open it again. If it works then good else place the macro in a module, rather than putting it in elsewhere. Regards Ashish Jain Analyst and Demand-Co-ordinator, CSC Australia Microsoft Office Specialist Technical Trainer - Excel and VBA 0-

$$Excel-Macros$$ Re: Urgent Help need to count values

Dear Ashish, Thanks for the reply. When I go to below mentioned site. There is macro program. I had gone by step by step. but I am not getting the answer. There is an #Name error has occured. Please help me & attached the same file. Thanks & Regards, Lavprasad Kori MIS Executive - Water Hindus

$$Excel-Macros$$ Re: Urgent Help need to count values

-- Hi LavPrasad, Here is the solution to your query: http://www.excelitems.com/2009/02/count-5-consecutive-zeroes.html Regards Ashish Jain Analyst and Demand-Co-ordinator, CSC Australia Microsoft Office Specialist Technical Train

$$Excel-Macros$$ Re: urgent help needed

Hi Pavithrak, Not sre what markers are required. i had updated three radio buttons but not sure of the code which you require the below link has the option of adding the code. *http://www.functionx.com/excel2003/articles/radiobuttons.htm* regards Hari kumar On Wed, Feb 18, 2009 at 8:56 AM, pavithr