Re: $$Excel-Macros$$ Stock position - Reg

Hi, Find the attachment... On Sun, Apr 15, 2012 at 10:27 AM, jmothilal wrote: > > PURCHASE / SALES ITEM QTY STOCK > P LG DVD WRITER 1 1 > P LG DVD WRITER 5 6 > S LG DVD WRITER 1 5 > P LG DVD WRITER 1 6 > P LG DVD WRITER 10 16 > S LG DVD WRITER 4 12 > > > > -- FORUM RULES (986+ members alread

RE: $$Excel-Macros$$ Sorting cells

Hi Kenrock, If I understand you correctly, you could get a sort to work by copying column A, paste-special, Values (Select Col.A/Ctrl-C/Alt-E,S,V,Enter), then perform your sort. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of kenrock Sent: Saturd

RE: $$Excel-Macros$$ Most helpful Member - March 12- Don Guillett

Congratulations Don! Well deserved, glad to see you get this recognition. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ayush Jain Sent: Saturday, April 14, 2012 1:36 AM To: excel-macros Subject: $$Excel-Macros$$ Most helpful Member - March 12-

Re: $$Excel-Macros$$ Most helpful Member - March 12- Don Guillett

Congrats Don, On Sat, Apr 14, 2012 at 1:49 PM, pankaj gmail account wrote: > Congrats > > Pankaj Michael > On Sat, Apr 14, 2012 at 10:55 PM, NOORAIN ANSARI > wrote: > >> Congrats Don, >> >> -- >> Thanks & regards, >> Noorain Ansari >> *http://noorainansari.com/* >> *http://excelmacroworld.blogs

RE: $$Excel-Macros$$ Fwd: If data in One then another cell to be unlock

Mr. Don Congrats, Well done! Keep it up Regards, Muneer, CC... -- 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 Problem, and Need Advice wil

RE: $$Excel-Macros$$ Hash Hash appearing in formula

Press Shift + Ctrl + ~ Rajan From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of hilary lomotey Sent: Apr/Sat/2012 06:16 To: excel-macros Subject: $$Excel-Macros$$ Hash Hash appearing in formula Hello Experts Attached is a call report i have creat

RE: $$Excel-Macros$$ If date in One then another cell to be unlock

You need to paste it in worksheet code module. Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Abdulgani Shaikh Sent: Apr/Sat/2012 02:03 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ If date in One then another cell to be unlo

RE: $$Excel-Macros$$ Program written, compiles, but odd runtime error in setting a range pointer

Hi, Every range reference is independent. It's not like human lanugage where context is assumed intelligently. The only context assumed with range and sheet references is ActiveWorkbook and ActiveSheet. It doesn't use other range references as context (i.e. the context of the Sheets(...)... as

Re: $$Excel-Macros$$ Program written, compiles, but odd runtime error in setting a range pointer

Ramping up my ignorance to the next level I guess. I only have one workbook and it is active so is the workbook part not needed? Changing to this worked but I thought that issue was resolved last night by the removal of the period in front of cells. But that means the cells associated with the ac

RE: $$Excel-Macros$$ Program written, compiles, but odd runtime error in setting a range pointer

Not illegal, but -- You didn't qualify Sheets or either instance of Cells in your problem line of code. That line, as written, requires two things to be true to work correctly: 1. The active workbook is the workbook that hold the named sheet. You could avoice that with ThisWorkbook.She

$$Excel-Macros$$ Program written, compiles, but odd runtime error in setting a range pointer

Program has already by error time successfully called 3 procedures doing all the initialization work across 3 different sheets. But then... application defined or object defined error This has already successfully executed With Sheets(RawData) Set tmprange = .Range(.Cells(2, BarOp

$$Excel-Macros$$ Scroll Bar charts with Name ranges

Hi Group, Attached is the sample excel sheet with graph which shows the performance of the employees for two units. Now the problem is that I need to update the data range every time say once in a month (in this attached sheet it is a year). What I need is I want to link the scroll bar with the

Re: $$Excel-Macros$$ Most helpful Member - March 12- Don Guillett

Congrats Don, -- Thanks & regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/* On Sat, Apr 14, 2012 at 2:06 PM, Ayush Jain wrote: > Dear members, > > Don Guillett has been selected as 'Most Helpful Member' for the mon

Re: $$Excel-Macros$$ Fwd: If data in One then another cell to be unlock

On your protection, why not just leave unprotected... On your macros, see attached (Sent direct to OP) ‘--- Option Explicit Sub AddSheetSAS() ActiveWorkbook.Save Dim i As Long Dim s, k As String s = InputBox("Please Enter INITIALs of Employee as Sheet Name to be added") For i = 1 To Workshe

Re: $$Excel-Macros$$ Hash Hash appearing in formula

thank chief, it works On Sat, Apr 14, 2012 at 1:02 PM, Sam Mathai Chacko wrote: > Custom format the cell to "0" > > Regards, > Sam > > > On Sat, Apr 14, 2012 at 6:16 PM, hilary lomotey wrote: > >> Hello Experts >> >> Attached is a call report i have created. Where you can choose a >> department

Re: $$Excel-Macros$$ Hash Hash appearing in formula

Custom format the cell to "0" Regards, Sam On Sat, Apr 14, 2012 at 6:16 PM, hilary lomotey wrote: > Hello Experts > > Attached is a call report i have created. Where you can choose a > department from the drop down and see the call report for that dept. The > problem am facing is that some of

Re: $$Excel-Macros$$ If date in One then another cell to be unlock

Provide your file with examples. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: ITP Abdulgani Shaikh Sent: Saturday, April 14, 2012 1:49 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ If date in One then another cell to be unlock Dear Freinds,

Re: $$Excel-Macros$$ Quarter Classification

Hi Maries, Thanks for solving my problem. Nikhil On Sat, Apr 14, 2012 at 6:15 PM, dguillett1 wrote: > You need to provide a file. > > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille...@gmail.com > > *From:* Nikhil Shah > *Sent:* Saturday, April 14, 2012 2:38 AM > *To:* exc

$$Excel-Macros$$ Hash Hash appearing in formula

Hello Experts Attached is a call report i have created. Where you can choose a department from the drop down and see the call report for that dept. The problem am facing is that some of the words typed into the discussion details are very long so when you choose that particular client name it sho

Re: $$Excel-Macros$$ Quarter Classification

You need to provide a file. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Nikhil Shah Sent: Saturday, April 14, 2012 2:38 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Quarter Classification Dear Friends, I want to make the whole year classif

Re: $$Excel-Macros$$ If date in One then another cell to be unlock

Dear Freinds, Please help me on following issue My worksheet is protected, out of all cells, some cells are unprotected for entering data. If I am entering data in Cell C3 then Cell E3 should be auto unlock. and if there is no data in Cell C3 or zero in C3 then Cell E3 should be auto locked. Als

Re: $$Excel-Macros$$ Most helpful Member - March 12- Don Guillett

Donald, your presence here is a boon to many. From everyone who has benefited from your expertise, one way or the other, a big thanks. And congratulations. Regards, Sam Mathai Chacko On Sat, Apr 14, 2012 at 4:19 PM, wrote: > ** > Congrats Don n Thanks a lot for sharing. > --

Re: $$Excel-Macros$$ Most helpful Member - March 12- Don Guillett

Congrats Don n Thanks a lot for sharing. -Original Message- From: Ayush Jain Sender: excel-macros@googlegroups.com Date: Sat, 14 Apr 2012 09:36:16 To: excel-macros Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Most helpful Member - March 12- Don Guillett Dear members

Re: $$Excel-Macros$$ Most helpful Member - March 12- Don Guillett

Thumbs up big Papa Don On Sat, Apr 14, 2012 at 10:06 AM, Abdulgani Shaikh wrote: > Heartiest congratulations !!! > > > On Sat, Apr 14, 2012 at 2:13 PM, Rajan_Verma wrote: > >> Congrats DON >> >> ** ** >> >> Rajan. >> >> ** ** >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-m

Re: $$Excel-Macros$$ Sorting cells

Hi Rajan, I did ... and it doesn't work. If you sort B1:B4 using A-Z, the cells in column B remain the same ie B1 holds =A1, B2 holds =A2 etc. I want to see Bonn in B1 (actually =A3), London in B2 (actually =A1), Madrid in B3 and Paris in B4. Regards, kenrock On Friday, April 13, 2012 8:51:53

Re: $$Excel-Macros$$ If date in One then another cell to be unlock

I have pasted this in Excel, but it is not working, pl.find attached file, where i am wrong ? Regards On Sat, Apr 14, 2012 at 12:38 PM, Rajan_Verma wrote: > Hi, > > You can try this : > > ** ** > > Private Sub Worksheet_Change(ByVal Target As Range) > > ** ** > > If Target.Addres

Re: $$Excel-Macros$$ Most helpful Member - March 12- Don Guillett

Heartiest congratulations !!! On Sat, Apr 14, 2012 at 2:13 PM, Rajan_Verma wrote: > Congrats DON > > ** ** > > Rajan. > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Ayush Jain > *Sent:* Apr/Sat/2012 02:06 > *To:* excel-macros

$$Excel-Macros$$ Re: Remove Duplicates from the row()

Hi In S2, =SUM(IF(FREQUENCY(IF(S4:S17<>"",MATCH(S4:S17,S4:S17,0)),ROW(S4:S17)-ROW(S4)+1),1)) In E21 and copied across, =IF(COLUMNS($E21:E21)<=$S$2,INDEX($S$4:$S$17,MATCH(0,COUNTIF($D21:D21,$S$4:$S$17),0)),"") Both are array formulas. Confirmed with CTRL + SHIFT + ENTER Kris > > -- FORUM RUL

Re: $$Excel-Macros$$ Most helpful Member - March 12- Don Guillett

*Congrats DON... * On Sat, Apr 14, 2012 at 12:43 PM, Rajan_Verma wrote: > Congrats DON > > ** ** > > Rajan. > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Ayush Jain > *Sent:* Apr/Sat/2012 02:06 > *To:* excel-macros > *Subject:*

RE: $$Excel-Macros$$ Most helpful Member - March 12- Don Guillett

Congrats DON Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ayush Jain Sent: Apr/Sat/2012 02:06 To: excel-macros Subject: $$Excel-Macros$$ Most helpful Member - March 12- Don Guillett Dear members, Don Guillett has been selected as 'Mo

RE: $$Excel-Macros$$ Remove Duplicates from the row()

You can implement this : =IF(COUNTIF($D$21:D21,IF($S:$S>1,S4+1,S4))<1,IF($S:$S>1,S4+1,S4),"") Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Mohammed Muneer Sent: Apr/Sat/2012 01:28 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$

Re: $$Excel-Macros$$ Most helpful Member - March 12- Don Guillett

Heartiest congratulations Don .. cheers :) Regards, DILIPandey On 4/14/12, Ayush Jain wrote: > Dear members, > > Don Guillett has been selected as 'Most Helpful Member' for the month of > March'12 > He has been helping forum members from long time consistently and we are > proud to have him in t

Re: $$Excel-Macros$$ Most helpful Member - March 12- Don Guillett

DON ROCKS...!CONGRATS. On Sat, Apr 14, 2012 at 2:06 PM, Ayush Jain wrote: > Dear members, > > Don Guillett has been selected as 'Most Helpful Member' for the month of > March'12 > He has been helping forum members from long time consistently and we are > proud to have him

Re: $$Excel-Macros$$ Excel - Useful Web Links

Thanks a lot -- 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 Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question

Re: $$Excel-Macros$$ Quarter Classification

Hi, Previous one shows the next quarter. Try below for previous quarter month, =VLOOKUP(MONTH(TEXT(A1,"")&1),{1,"January";2,"January";3,"January";4,"April";5,"April";6,"April";7,"July";8,"July";9,"July";10,"October";11,"October";12,"October"},2,FALSE) Regards, MARIES. On Sat, Apr 14, 2012

Re: $$Excel-Macros$$ Quarter Classification

Hi, Try it, =VLOOKUP(MONTH(TEXT(A1,"")&1),{11,"January";12,"January";1,"January";2,"April";3,"April";4,"April";5,"July";6,"July";7,"July";8,"October";9,"October";10,"October"},2,FALSE) Regards, MARIES. On Sat, Apr 14, 2012 at 11:38 AM, Nikhil Shah wrote: > Dear Friends, > > I want to mak

RE: $$Excel-Macros$$ Ok I know I should be getting this by now but why does this assignment not work?

thank you :) I think I'll go sleep on it. May the weekend be good for all. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Domain Admin Sent: Saturday, April 14, 2012 12:42 AM To: excel-macros@googlegroups.com Subject: Re: $$Exc

Re: $$Excel-Macros$$ Ok I know I should be getting this by now but why does this assignment not work?

Thanks Rajan but that would not have made a difference. I already had this definition I did not show Const RawData As String = "RawData" I should have mentioned that I suppose. On Sat, Apr 14, 2012 at 12:25 AM, Rajan_Verma wrote: > Give sheet name in Inverted Commas ( “ “ ) > > > > Rajan.

Re: $$Excel-Macros$$ Ok I know I should be getting this by now but why does this assignment not work?

Ah, that example was the perfect explaination. Thanks as always and sorry about the rough day. Hope you have a great weekend. On Sat, Apr 14, 2012 at 12:38 AM, Asa Rossoff wrote: > Cells doesn't also become a member of whatever object is mentioned in a > surrounding With block, but since you pre

RE: $$Excel-Macros$$ Ok I know I should be getting this by now but why does this assignment not work?

Cells doesn't also become a member of whatever object is mentioned in a surrounding With block, but since you precede the Cells object with a leading period, that associates with the With block. With Abc .def(.ghi, .jkl) End with Translates to: Abc.def(Abc.ghi, Abc.jkl) Poetry inspired by a ro

$$Excel-Macros$$ PASTE LINK OPTION NOT SHOWING

for the last 15 days i am facing a peculiar problem realting to paste link fuction not showing whenever i am going to paste special icon or by right click option . in the paste special option its showing paste as text or paste as unicode text . No other option is there . Please help me out Than

$$Excel-Macros$$ Quarter Classification

Dear Friends, I want to make the whole year classified in to 4 quarters as January, April, July and October. As and when I give a date it should be grouping in to that particular quarter only,( the date may be random) and one more thing that the very next Quarter will be taken for the name p

Re: $$Excel-Macros$$ Ok I know I should be getting this by now but why does this assignment not work?

Ah you wax poetic. I get what you say, but I started out using the With version and just took away the With and End With and placed the sheets(rawdata) in front of .range. So why did the With version work? Why does it not have the same issue? When the With is outside the assignment then Cells

RE: $$Excel-Macros$$ Ok I know I should be getting this by now but why does this assignment not work?

The first cells has a leading period. which mean it is a member of the object you are WITH.. but today you are alone, are are not WITH any object, subject, friend, or foe. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of tangledweb Sent: Saturday, April 14

RE: $$Excel-Macros$$ Ok I know I should be getting this by now but why does this assignment not work?

Give sheet name in Inverted Commas ( " " ) Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of tangledweb Sent: Apr/Sat/2012 12:52 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Ok I know I should be getting this by now but why does this

$$Excel-Macros$$ Ok I know I should be getting this by now but why does this assignment not work?

This works With Sheets(RawData) Set tmprange = .Range(.Cells(2, BarOpen), .Cells(stoprawdata, EContango)) End With but this which seems equivalent to me does not work Set tmprange = Sheets(RawData).Range(.Cells(2, BarOpen), .Cells(stoprawdata, EContango)) which gives error

Re: $$Excel-Macros$$ Excel - Useful Web Links

Hi Varun, a lot of Thanks On Tue, Apr 10, 2012 at 9:13 AM, VARUN CHAWLA wrote: > > > On Sat, Apr 7, 2012 at 3:09 AM, Maries wrote: > >> Dear Friends, >> >> I have accumulate the my collection for Excel. Please update, If you >> anything more. >> >> I hope these links are very useful everyone.

RE: $$Excel-Macros$$ If date in One then another cell to be unlock

Hi, You can try this : Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$C$3" Then Me.Unprotect If Target.Value = 0 Or Len(Target.Value) = 0 Then Range("E3").Locked = False Else Range("E3").Locked = True End