RE: $$Excel-Macros$$ Help on Formula

Are you changing sheet name in E2 also? Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Shrinivas Shevde Sent: 01 September 2012 1:01 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros

Re: $$Excel-Macros$$ Help on Formula

Dear Rajan Very Very thanks for reply and its working fine.Liitle extension of problem If I name sheet as "Jan" its working if I name it as "Jan-12" then it is not working what may be the reason and what is the solution. Thanks once again. Regards Shrini On Sat, Sep 1, 2012 at 10:36 AM, Rajan_

RE: $$Excel-Macros$$ Help on Formula

=INDIRECT("'" & E2 & "'!B2") Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Shrinivas Shevde Sent: 01 September 2012 10:35 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help on Formula

Re: $$Excel-Macros$$ help for Conditional Lock and unlock cells

sh Singh To: excel-macros@googlegroups.com Sent: Mon, August 20, 2012 11:47:43 AM Subject: Re: $$Excel-Macros$$ help for Conditional Lock and unlock cells Dear Paul, First let me thanks you for prompt reply. i have tried  this ... Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Rang

Re: $$Excel-Macros$$ help for Conditional Lock and unlock cells

@googlegroups.com Subject: Re: $$Excel-Macros$$ help for Conditional Lock and unlock cells Dear Paul, First let me thanks you for prompt reply. i have tried this ... Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) If Range("a4:a10").Value = "" Then Ra

Re: $$Excel-Macros$$ help for Conditional Lock and unlock cells

Dear Paul, First let me thanks you for prompt reply. i have tried this ... Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) If Range("a4:a10").Value = "" Then Range("b4:B10").Locked = False Else Range("b4:b10").Locked = True End If End Sub But is not working sheet can be prot

Re: $$Excel-Macros$$ help for Conditional Lock and unlock cells

Hi Santosh, Please send a sample file. and more explain. it's confusing. Regards, Kuldeep Singh On Mon, Aug 20, 2012 at 8:37 PM, Santosh Kumar Singh wrote: > Hay looking for help .. > > ** ** > > *Column C* > > * D* > > open for entry > > a > > Locked > > d > > Locked*

Re: $$Excel-Macros$$ help for Conditional Lock and unlock cells

Your request is somewhat confusing. "locking" a cell does not necessarily mean "grayed out". In order to lock a cell, two things have to happen. 1) the "locked" property of the cell must be set. 2) the sheet has to be protected (with or without a password) For the cell to be "Grayed Out" means th

Re: $$Excel-Macros$$ Help with Formula Destination

Thanks Sam , it is useful for me also. prince On Monday, August 6, 2012 10:08:09 PM UTC+5:30, Sam Mathai Chacko wrote: > > =HYPERLINK("#"&CELL("address",Sheet3!A1),Sheet3!A1) > > Regards > > Sam Mathai Chacko > > On Mon, Aug 6, 2012 at 9:41 PM, ashish koul > > wrote: > >> =HYPERLINK("#'"&SUBSTITU

Re: $$Excel-Macros$$ Help with Formula Destination

Dear Kantilal, Sam & Ashish All your options work and are helpful. Appreciate your help and thanks a lot (Couldn't respond earlier as I was away) Thanks Ashish Pradhan On 07-08-2012 10:56, Kantilal Badale wrote: Try CTRL+[ ] from formula cell CA Kantilal Badale E-Hall, First Floor, B. J. M

Re: $$Excel-Macros$$ Help with Formula Destination

r(.Formula, "!") + 1, 256) Application.Goto reference:=Sheets(ms).Range(mc) End With End Sub Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Kantilal Badale Sent: Tuesday, August 07, 2012 12:26 AM To: excel-macros@googlegroups.com Subject: Re: $$Exce

Re: $$Excel-Macros$$ Help for formula (which formula give me exact numbers when I change month)

First Thanks very much Kantilal Sir,But I would like to which I desired output in sheet (Yellow color) Is it possible? On Mon, Aug 6, 2012 at 11:01 AM, Kantilal Badale wrote: > Hi, > > See if attached sheet is useful. > > U can Change month in value field to get the desired result > > Regards > >

Re: $$Excel-Macros$$ Help with Formula Destination

Try CTRL+[ ] from formula cell CA Kantilal Badale E-Hall, First Floor, B. J. Market, Jalgaon.(Maharashtra) 9822250393 On Mon, Aug 6, 2012 at 10:08 PM, Sam Mathai Chacko wrote: > =HYPERLINK("#"&CELL("address",Sheet3!A1),Sheet3!A1) > > Regards > > Sam Mathai Chacko > > > On Mon, Aug 6, 2012 at

Re: $$Excel-Macros$$ Help with Formula Destination

=HYPERLINK("#"&CELL("address",Sheet3!A1),Sheet3!A1) Regards Sam Mathai Chacko On Mon, Aug 6, 2012 at 9:41 PM, ashish koul wrote: > =HYPERLINK("#'"&SUBSTITUTE(CELL("address",Sheet2!A3),"!","'!"),Sheet2!A3) > > > > > On Mon, Aug 6, 2012 at 7:09 PM, Ashish Pradhan wrote: > >> >> Hello >> >> I hav

Re: $$Excel-Macros$$ Help with Formula Destination

=HYPERLINK("#'"&SUBSTITUTE(CELL("address",Sheet2!A3),"!","'!"),Sheet2!A3) On Mon, Aug 6, 2012 at 7:09 PM, Ashish Pradhan wrote: > > Hello > > I have many cells with formulae in them in Sheet "Main" > > For Example: > > ='Staff Bonus'!E67 > > Is there a simpler way to go to the Sheet "Staff Bon

Re: $$Excel-Macros$$ Help for formula (which formula give me exact numbers when I change month)

Hi ,, Use Ctrl Shift enter for Priti_Verma s formula... Thanks On Sat, Aug 4, 2012 at 1:17 PM, amar takale wrote: > Pls help me all experts.I attached file. > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like P

RE: $$Excel-Macros$$ Help for formula (which formula give me exact numbers when I change month)

Try this in C15:I15 as array =TRANSPOSE(OFFSET(INDEX($C$5:$N$5,1,MATCH(C14,$C$5:$N$5,0)),1,0,6,1)) Priti From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: 04 August 2012 1:18 To: excel-macros@googlegroups.com Subject: $$Excel-Macro

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

Re: $$Excel-Macros$$ Help needed to count and sum data between two fixed dates.

Dear Sanotsh, If you are using Excel 2007+, Attached sheet will also helpful for you. On Sat, Jul 21, 2012 at 4:38 PM, santosh subudhi < santoshkumar.subu...@gmail.com> wrote: > > Hi Group, > > Need another help to count and sum data between two fixed dates. > > > Regards > Santosh > santoshkuma

Re: $$Excel-Macros$$ Help for macros

Dear Mr Don, I need your help for transaction of data from one file to another. We have attached one excel file named Monthly Transaction Report June 2012 in our last mail with two sub files in that (1) New joining date wise, which is our data file of employees and (2) Transaction report. Wat

Re: $$Excel-Macros$$ Help needed to count and sum data between two fixed dates.

Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: santosh subudhi Sent: Saturday, July 21, 2012 6:08 AM To: excel-macros Subject: $$Excel-Macros$$ Help needed to count and sum data between two fixed dates. Hi Group, Need another help to count and sum data

Re: $$Excel-Macros$$ Help for macros

When you ask for help: Provide a meaningful subject line Provide a file with before/after examples and the logic of why/where Tell us what you want where and why. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: dharmesh rav Sent: Saturday, July 21, 2012 1:19 A

Re: $$Excel-Macros$$ Help Me

“Please help me” is NOT a good subject line. Please describe your problem in the body of your email and also attach file. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Manoj Kumar Sent: Friday, July 20, 2012 12:43 AM To: excel-macros@googlegroups.com Subje

Re: $$Excel-Macros$$ Help Me

Dear Manoj, Attachment is missing On Fri, Jul 20, 2012 at 11:13 AM, Manoj Kumar wrote: > Dear Expert, > > Please help me > > Query file attached with mail... > > Regard > Manoj > > -- > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. P

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 Me

[█ ▆ ▅ ▃ ▂★Great Noorain Sir★▂ ▃ ▅ ▆ █] Regards, Kuldeep Singh Phone.: +91-120-4763789, Extn.: 789 naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* On Mon, Jul 16, 2012 at 4:21 PM, Manoj Kumar wrote: > Dear K

Re: $$Excel-Macros$$ Help Me

Dear Kuldeep, thanks.. I need function witch I already provide by Noorain... On Mon, Jul 16, 2012 at 3:47 PM, Kuldeep Singh wrote: > > Hi, > > Use this > > Regards, > Kuldeep Singh > Info Edge India Limited (naukri.com) > naukrikuld...@gmail.com || www.naukri.com > *Please* *Consider the

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 Me

Happy to Help On Mon, Jul 16, 2012 at 3:41 PM, Manoj Kumar wrote: > Thanks Noorain Ji... > > > On Mon, Jul 16, 2012 at 3:39 PM, NOORAIN ANSARI > wrote: > >> Dear Manoj, >> >> Please try it. >> >> >> =INDEX(Data!$B$2:$I$13,MATCH(B$1,Data!$A$2:$A$13,0),MATCH($A2,Data!$B$1:$I$1,0)) >> >> >> -- >> T

Re: $$Excel-Macros$$ Help Me

Thanks Noorain Ji... On Mon, Jul 16, 2012 at 3:39 PM, NOORAIN ANSARI wrote: > Dear Manoj, > > Please try it. > > > =INDEX(Data!$B$2:$I$13,MATCH(B$1,Data!$A$2:$A$13,0),MATCH($A2,Data!$B$1:$I$1,0)) > > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspot.

Re: $$Excel-Macros$$ Help Me

Dear Manoj, Please try it. =INDEX(Data!$B$2:$I$13,MATCH(B$1,Data!$A$2:$A$13,0),MATCH($A2,Data!$B$1:$I$1,0)) -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Mon, Jul 16, 2012 at 3:26 PM, Manoj Kumar wrote: > Dear Expert, > > Please help me to ma

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 > Subject: $$Excel-Macros$

Re: $$Excel-Macros$$ help regarding range selection from worksheet

inash > *Sent:* Friday, July 06, 2012 10:32 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ help regarding range selection from > worksheet > > hi don thanks for your help > and sorry for i was not able to explain my requirement but can u plea

Re: $$Excel-Macros$$ help regarding range selection from worksheet

Microsoft Excel Developer > SalesAid Software > dguille...@gmail.com > > *From:* dguillett1 > *Sent:* Friday, July 06, 2012 9:49 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ help regarding range selection from > worksheet > > Had you

Re: $$Excel-Macros$$ help regarding range selection from worksheet

groups.com Subject: Re: $$Excel-Macros$$ help regarding range selection from worksheet Please find attached Excel sheet and run my macro for better understanding Regards, Avinash On Friday, July 6, 2012 7:22:45 PM UTC+5:30, Don Guillett wrote: If?? I understand what you want, right c

Re: $$Excel-Macros$$ help regarding range selection from worksheet

Row > Application.Goto Sheets(CStr(.Cells(i, 1))).Range(.Cells(i, 2)) > Next i > End With > End Sub > > Don Guillett > Microsoft Excel Developer > SalesAid Software > dguille...@gmail.com > > *From:* Avinash > *Sent:* Friday, July 06, 2012 9:20 AM > *T

Re: $$Excel-Macros$$ help regarding range selection from worksheet

Next i End With End Sub Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: dguillett1 Sent: Friday, July 06, 2012 9:49 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ help regarding range selection from worksheet Had you explained that you want

Re: $$Excel-Macros$$ help regarding range selection from worksheet

th End Sub Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Avinash Sent: Friday, July 06, 2012 9:20 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ help regarding range selection from worksheet Please find attached Excel sheet and run my

Re: $$Excel-Macros$$ help regarding range selection from worksheet

e(Target.Offset(, 1)) End Sub Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Avinash Sent: Friday, July 06, 2012 6:14 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ help regarding range selection from worksheet hi ashish there is little

Re: $$Excel-Macros$$ help regarding range selection from worksheet

Hi rajan it is not working i am getting this error "Subscript out of range" Regards, Avinash On Friday, July 6, 2012 6:16:27 PM UTC+5:30, Rajan_Verma wrote: > > Use this: > > > > Sub SelectRange() > > > > Dim WksSheet As Range > > Dim rngRange As Range > > Dim rngCell As Range

RE: $$Excel-Macros$$ help regarding range selection from worksheet

Use this: Sub SelectRange() Dim WksSheet As Range Dim rngRange As Range Dim rngCell As Range Set rngRange = Sheet1.Range("A1").CurrentRegion For Each rngCell In rngRange.Columns(1).Cells ThisWorkbook.Worksheets(rngCell.Value).Activate

Re: $$Excel-Macros$$ help regarding range selection from worksheet

Awesome Jhakaa.!!! Thank You So Much...!:) On Thursday, July 5, 2012 10:51:16 PM UTC+5:30, ashish wrote: > > try something like this > > > a2 = sheet name > b2 = cell adress > > > Sub test() > Sheets(Range("a2").Value).Range(Range("b2"

Re: $$Excel-Macros$$ help regarding range selection from worksheet

try something like this a2 = sheet name b2 = cell adress Sub test() Sheets(Range("a2").Value).Range(Range("b2").Value).Select End Sub On Thu, Jul 5, 2012 at 10:47 PM, Avinash wrote: > Hi all, > > i want help regarding range selection from worksheet. > > i have created 1 macro to select spe

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

Dear Manoj, Please use it.. SELECT Month, Store ID FROM [Acer All Data] WHERE ((Month)="apr'12")); -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Fri, Jun 29, 2012 at 7:11 PM, ╰» ℓαℓιт мσαнη wrote: > Hi Manoj, > > Try this > > select [store id] f

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

Hi Manoj, Try this select [store id] from [Acer All Data] group by [store id] select [store id] from [Apr'12] group by [store id] select [store id] from [Mar'12] group by [store id] select [store id] from [May'12] group by [store id] Regards, Lalit Mohan On Fri, Jun 29, 2012 at 3:14 PM, Manoj

Re: $$Excel-Macros$$ Help for Regarding Excel

Dear Rajiv, Please find below link with complete explanation of Insert-Name http://www.contextures.com/xlNames01.html if you have any query feel free to revert. -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Thu, Jun 14, 2012 at 10:31 PM, R@jiv

Re: $$Excel-Macros$$ help in matching data in excel sheet

> *Sent:* 19 May 2012 6:13 > *To:* excel-macros@googlegroups.com" > *Subject:* Re: $$Excel-Macros$$ help in matching data in excel sheet > > ** ** > > ** ** > > ** ** > > - > > i am having data of sale value derived from sales sheet for over >

RE: $$Excel-Macros$$ help in matching data in excel sheet

Sample file?? Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Cute Awesome Sent: 19 May 2012 6:13 To: excel-macros@googlegroups.com" Subject: Re: $$Excel-Macros$$ help in matching data in excel

Re: $$Excel-Macros$$ help in matching data in excel sheet

> - > > i am having data of sale value derived from sales sheet for over > 3200 pieces > > the same has been taken in two different excel sheet by two guys but when > we try to match sale value its not matching wheres pieces ref is matching. > how i can match sale value to remove the difference i.e

Re: $$Excel-Macros$$ help in matching data in excel sheet

Can you send the sample file Sent on my BlackBerry® from Vodafone -Original Message- From: Cute Awesome Sender: excel-macros@googlegroups.com Date: Sat, 19 May 2012 17:38:06 To: excel-macros@googlegroups.com\" Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ help in mat

Re: $$Excel-Macros$$ Help with PPT

Can you share the sample data Sent on my BlackBerry® from Vodafone -Original Message- From: "B.N.Chethan Kumar" Sender: excel-macros@googlegroups.com Date: Sat, 19 May 2012 15:35:26 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help with PPT Dear friends, Do we

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

Re: $$Excel-Macros$$ Help me to generate Report

I think you should use a pivot table for this. click anywhere in the list and then click insert/Pivot table and follow the prompts. On 15 May 2012 17:14, Ankit Agrawal wrote: > Deal All, > > I need your help on the same. > > Any Confusion plz let me know. > > Regards, > Ankit > > > On Fri, May

Re: $$Excel-Macros$$ Help me to generate Report

Deal All, I need your help on the same. Any Confusion plz let me know. Regards, Ankit On Fri, May 4, 2012 at 2:00 PM, Ankit Agrawal wrote: > Dear all, > > I have some data in one sheet and I have to generate report which format > is also on second sheet. How can we generate it. > > Thanks & R

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 needed - VBA

You can try this : Sub sauce_data_FRI_AMPM() Dim wbkNew As Workbook Set wbkNew = Workbooks.Open(Filename:="R:\Planning\Sauce Plan - New.xls", ReadOnly:=True) wbkNew.Worksheets("SaucePlan").Range("E6:H101").Copy Workbooks("LowRisk EPlan SAUCE week 19.xls").Worksheets("YourSheetName").Rang

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

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

Subject: Re: $$Excel-Macros$$ HELP REQUIRED IN MACRO FUNCTION Dear Sir, thanks for help. i am already woking with index/match fourmula. i want macro function to solve. On Fri, May 4, 2012 at 10:49 AM, Deepak Rawat wrote: Hi Pls find the attached. I used formula instead of Macro

Re: $$Excel-Macros$$ help Pls for creating graph,

Without too much looking it should be easy enough to fill in your source data cells using formulas for A,B,C, etc. and use ONE chart that changes with a change in name.. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: Harkesh Kumar Se

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

Dear Sir, thanks for help. i am already woking with index/match fourmula. i want macro function to solve. On Fri, May 4, 2012 at 10:49 AM, Deepak Rawat wrote: > Hi > > Pls find the attached. I used formula instead of Macro. > > Regards, > Deepak Rawat > > > On Thu, May 3, 2012 at 9:3

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

Dear Sir, grade calculated on weight age and weight age calculates as (obs total/total no)*10 (27/40)*10=6.75 then grade will be b2 On Thu, May 3, 2012 at 10:28 PM, Rajan_Verma wrote: > Hi > > Can you please more explain.Like where we need to match Grade Bucket > Criteria for C

RE: $$Excel-Macros$$ Help on Changing code on Color Macro

verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Jorge Marques Sent: 03 May 2012 16:09 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help on Changing code on Color Macro Yes Rajan you´re absolutely rig

Re: $$Excel-Macros$$ Help on Changing code on Color Macro

Yes Rajan you´re absolutely right, thank you very much, it was supposed to be the excel in the ppt, I was thinking, instead of putting Green on "Não" and Red "Sim" can´t we do the macro to put Green whenever the day is = Today() and only put Red if "Sim" and reset the counter? this way i don´t ha

Re: $$Excel-Macros$$ Help on Changing code on Color Macro

2012/5/3 Jorge Marques > Yes Rajan you´re absolutely right, thank you very much, it was supposed > to be the excel in the ppt, > > I was thinking, instead of putting Green on "Não" and Red "Sim" can´t we > do the macro to put Green whenever the day is = Today() and only put Red if > "Sim" and re

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

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 you change any of the other formulas the whole exercise has to be reworked. On 3 May 2012 13:49, Milin

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

Thanks David. It is working. Though I am still trying to understand algebra :) Just one more query : as data input value will change the formula will also change , right ? Regards, Milin On Thu, May 3, 2012 at 4:54 AM, David Grugeon wrote: > Hi Milin > > I attach a revised version with worki

RE: $$Excel-Macros$$ Help on Changing code on Color Macro

Did you attached Wrong file ? Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Jorge Marques Sent: 02 May 2012 15:36 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help on Changing code o

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

Dear David, Thanks for your response. Row 7 - "d oth all" is always a balancing number arrived on calculation. This is one of the place where it goes in circular reference The label for row 13 (G ESIC) is (a+b+c) x 4.75 % but the formula is b+c+d x 4.75%. Which should it be? - I have changed

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

In your spreadsheet d will always be a - all the other deductions therefore row 19 will always be zero. Is that what you wanted? If so you could replace all the row 19 formulas with 0 The label for row 13 (G ESIC) is (a+b+c) x 4.75 % but the formula is b+c+d x 4.75%. Which should it be? If r

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

;> Formula. >>> >>> ** ** >>> >>> *From:* excel-macros@googlegroups.com [mailto: >>> excel-macros@googlegroups.com] *On Behalf Of *Milin Sulakhi >>> *Sent:* Apr/Sat/2012 08:47 >>> *To:* excel-macros@googlegroups.com >>> *Subjec

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

, 2012 at 9:24 PM, Rajan_Verma wrote: > >> ** ** >> >> Formula. >> >> ** ** >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *Milin Sulakhi >> *Sent:* Apr/Sat/2012 08:47 >> *To:* excel-

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

roups.com] *On Behalf Of *Milin Sulakhi > *Sent:* Apr/Sat/2012 08:47 > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Help required on how to create iterative > formula > > ** ** > > Dear Rajan, > > ** ** > > But I will need to add formu

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

Formula. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Milin Sulakhi Sent: Apr/Sat/2012 08:47 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help required on how to create iterative formula Dear Rajan, But I will need to add

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

Dear Rajan, But I will need to add formula or values in cells marked Green in attached file. Right ? Regards, Milin On Sat, Apr 28, 2012 at 7:32 PM, Rajan_Verma wrote: > Set the Maximum Iteration to 1 then Calculate formula by F2 and Enter > > ** ** > > Rajan. > > ** ** > > *From:* exc

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

Set the Maximum Iteration to 1 then Calculate formula by F2 and Enter Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Milin Sulakhi Sent: Apr/Sat/2012 06:42 To: excel-macros@googlegroups.com; milinsula...@gmail.com Subject: $$Excel-Macros$$ Hel

Re: $$Excel-Macros$$ Help needed- Converting JPG format file to Excel file via VBA

Please download ; http://www.minipdf.com/ I tried it and it works fine ... Chilexcel 2012/4/20 Rajan_Verma > I think No, you can’t change. > > ** ** > > You can convert it in PDF and make it readable by One Adobe Tools [name I > don’t remember) , Please google it. > > ** ** > > Ra

RE: $$Excel-Macros$$ Help needed- Converting JPG format file to Excel file via VBA

I think No, you can't change. You can convert it in PDF and make it readable by One Adobe Tools [name I don't remember) , Please google it. Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Shekhar Sharma Sent: Apr/Fri/2012 02:32 To: excel-macro

Re: $$Excel-Macros$$ HELP to create popup alert in Excel

Hi Ketan, For reference check purpose please use the formula from Cell D9 to D17 as : =RANDBETWEEN(1.4,5) and then by using Alt+F11 and then in your sheet 1 update the code as: Dim Nifty, Titan As String Private Sub Worksheet_Calculate() Nifty = Range("D10").Value Titan = Range("D17").Value If

Re: $$Excel-Macros$$ Help on inputbox

Try this, Private Sub updatemonth() Sheets("Brand").Range("C1").Select If ActiveCell.Value = "" Then Do Until ActiveCell.Value = "Total" ActiveCell.Value = "Month i want" ActiveCell.Offset(1, 0).Select Loop Else MsgBox "No job to run" End If End Sub Regards Shekhar Sharma On Wed, Aug 31, 2011

Re: $$Excel-Macros$$ Help Please

2012/3/31 NOORAIN ANSARI > Very useful link Ashish, Thanks to sharing with group > > > On Fri, Mar 30, 2012 at 9:37 PM, ashish koul wrote: > >> http://www.rondebruin.nl/ribbon.htm#Examples >> >> >> >> >> On Fri, Mar 30, 2012 at 9:33 PM, Divaker Pandey wrote: >> >>> >>> >>> On Fri, Mar 30, 2012 at

Re: $$Excel-Macros$$ help

Thanks Don & Mahesh On Sat, Mar 31, 2012 at 11:44 PM, dguillett1 wrote: > Copy/paste this into a module in an file saved as .xlsM > > Sub deleterowsif() > For i = Cells(Rows.Count, 1).End(xlUp).Row To 2 Step -1 > If Len(Application.Trim(Cells(i, 2))) < 1 _ >Or Cells(i, 1) = Cells(1, 1) Th

Re: $$Excel-Macros$$ help

Copy/paste this into a module in an file saved as .xlsM Sub deleterowsif() For i = Cells(Rows.Count, 1).End(xlUp).Row To 2 Step -1 If Len(Application.Trim(Cells(i, 2))) < 1 _ Or Cells(i, 1) = Cells(1, 1) Then Rows(i).Delete Next i End Sub Don Guillett Microsoft MVP Excel SalesAid Software dgu

Re: $$Excel-Macros$$ help

Thanks a lot got it... On Sat, Mar 31, 2012 at 11:19 PM, Sam Mathai Chacko wrote: > Errr... not sure what you meant by that. Like I said, it just means that > all range of cells in Column D that are blank gets collected (set) in that > range variable. > > Sam > > > On Sat, Mar 31, 2012 at 11:11 P

Re: $$Excel-Macros$$ help

Errr... not sure what you meant by that. Like I said, it just means that all range of cells in Column D that are blank gets collected (set) in that range variable. Sam On Sat, Mar 31, 2012 at 11:11 PM, vijayajith VA wrote: > > Thanks sam > > means same range suppose a1(blank cell) wil

Re: $$Excel-Macros$$ help

Thanks sam means same range suppose a1(blank cell) will search for a1 in other workbook & get filled rite... On Sat, Mar 31, 2012 at 10:43 PM, Sam Mathai Chacko wrote: > It means that all blank cells from Column D are being set to that range > variable > > Regards, > Sam Mathai Chack

Re: $$Excel-Macros$$ help

It means that all blank cells from Column D are being set to that range variable Regards, Sam Mathai Chacko On Sat, Mar 31, 2012 at 10:38 PM, vijayajith VA wrote: > Hi, > > Set sourcerange = Columns("D").SpecialCells(xlCellTypeBlanks) > > Can any one explain above code? > what does it mean? >

Re: $$Excel-Macros$$ Help Please

Very useful link Ashish, Thanks to sharing with group On Fri, Mar 30, 2012 at 9:37 PM, ashish koul wrote: > http://www.rondebruin.nl/ribbon.htm#Examples > > > > > On Fri, Mar 30, 2012 at 9:33 PM, Divaker Pandey wrote: > >> >> >> On Fri, Mar 30, 2012 at 12:44 PM, Divaker Pandey wrote: >> >>> Plea

Re: $$Excel-Macros$$ Help Please

http://www.rondebruin.nl/ribbon.htm#Examples On Fri, Mar 30, 2012 at 9:33 PM, Divaker Pandey wrote: > > > On Fri, Mar 30, 2012 at 12:44 PM, Divaker Pandey wrote: > >> Please help, >> >> >> On Thu, Mar 29, 2012 at 4:31 PM, Divaker Pandey wrote: >> >>> thanks for reply noorain >>> >>> But I wan

Re: $$Excel-Macros$$ Help on Chart

Dear Dilip, Thanks for the reply. But I(My senior) wants both bar graphs not line graph. Regards Shrinivas On Sat, Mar 24, 2012 at 12:32 PM, Dilip Pandey wrote: > Hi Shrini, > > See the attached file and let me know if this helps somehow :) > > Regards, > DILIPandey > > On 3/24/12, Shrinivas S

<    1   2   3   4   5   6   7   8   9   10   >