$$Excel-Macros$$ MACRO FOR DATA SORT

Dear Experts, Kindly advise macro to sort data by dt of openingMacro shd run if the range of data is changed Thanks in advance Regards, Prashant -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help,

$$Excel-Macros$$ labels for Y-axis is not get printed..

Dear Friends, I am unable to find the solution for this silly problem, when I am printing the chart for S_curve from system the Y-axis labels go missing? Could u please tell me what will be the problem from other system its quite easy and no trouble bearing thing,Why

Re: $$Excel-Macros$$ To create a serial number based on some conditions using macro.

Hi Sub kTest() Dim r As Range, s As String s = [c1].Text Set r = Range(c2:c Range(d Rows.Count).End(3).Row) With r .Cells(1).Offset(-1) = 0 .FormulaR1C1 =

$$Excel-Macros$$ Macro for data sorting

Dear Experts, Please ignore previous mail , correct file attached here , please help on below Kindly advise macro to sort data by dt of openingMacro shd run if the range of data is changed Thanks in advance Regards, Prashant -- FORUM RULES (986+ members already BANNED for violation)

$$Excel-Macros$$ Please help

Dear Team Please go through the attached excel sheet and help me in the calculation of * discount* (Column - D) based on the *discount criteria *(Column G:I) Regards Rajender Soni -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread

Re: $$Excel-Macros$$ Highlight the Words

Hi Rajan, Thanks for your reply, its working fine for the Query I mentioned, but there is a slight change my Query was not clear actually we can’t fix the length of the characters I have tried to give the examples this time, please do the needful at the earliest. Example:

$$Excel-Macros$$ Highlight the Words

Hi Rajan, Thanks for your reply, its working fine for the Query I mentioned, but there is a slight change my Query was not clear actually we can’t fix the length of the characters I have tried to give the examples this time, please do the needful at the earliest. Example:

Re: $$Excel-Macros$$ labels for Y-axis is not get printed..

Dear Muneer, Please Share sample sheet with group. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Tue, May 8, 2012 at 12:29 PM, Mohammed Muneer mmun...@ccc.com.qa wrote: ** ** Dear Friends, ** ** I am unable to find

$$Excel-Macros$$ Ranking formula problem

Hello Experts i have a data where i want to rank in order of 1 to the last number on a different sheet. Because i dont want it dynamically, i dont need to use sort, but rather a formula. in the sheet attached, i have in the data sheet where i have ranked the data in the order at which the data

Re: $$Excel-Macros$$ Macro for data sorting

Dear Prashant, Please use below code.. *Sub Data_sorting()* *Sheet2.Activate* *Cells.Select* *Selection.Sort Key1:=Range(E2), Order1:=xlAscending, Header:=xlYes, _* *OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _* *DataOption1:=xlSortNormal* *End Sub* See

Re: $$Excel-Macros$$ Please help

Hi, PFA On Tue, May 8, 2012 at 12:43 PM, Soni.Rajender soni.rajen...@gmail.comwrote: Dear Team Please go through the attached excel sheet and help me in the calculation of* discount* (Column - D) based on the *discount criteria *(Column G:I) Regards Rajender Soni -- FORUM RULES (986+

Re: $$Excel-Macros$$ Please help

Dear Rajendra, Waheed solution is nice, you can also use...vlookup with approximate match =VLOOKUP(B2,$G$3:$I$5,3,*1*) On Tue, May 8, 2012 at 3:03 PM, Shaik Waheed waheedb...@gmail.com wrote: Hi, PFA On Tue, May 8, 2012 at 12:43 PM, Soni.Rajender soni.rajen...@gmail.comwrote: Dear Team

Re: $$Excel-Macros$$ Macro for data sorting

many thanx noorain On Tue, May 8, 2012 at 1:12 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Prashant, Please use below code.. *Sub Data_sorting()* *Sheet2.Activate* *Cells.Select* *Selection.Sort Key1:=Range(E2), Order1:=xlAscending, Header:=xlYes, _* *OrderCustom:=1,

Re: $$Excel-Macros$$ Ranking formula problem

Thanks guys, i have been able to write the formula. On Tue, May 8, 2012 at 8:52 AM, hilary lomotey resp...@gmail.com wrote: Hello Experts i have a data where i want to rank in order of 1 to the last number on a different sheet. Because i dont want it dynamically, i dont need to use sort,

Re: $$Excel-Macros$$ Need macro to verify part numbers between 2 sheets

Hi All, I wish to seek your assistance in getting the output as mentioned in the attached excel cell: for Eg: If the Frequency is High and the Probability is also High I need to get an output of 1 like wise if Frequency is High and Probability is Medium, I should get an output of 2. The other

Re: $$Excel-Macros$$ Need Help on Formulas

Hi Try =LOOKUP(2,1/(({High;High;High;Medium;Medium;Medium;Low;Low;Low}=F5)*({High;Medium;Low;High;Medium;Low;High;Medium;Low}=G5)),{1;2;1;1;2;3;1;3;3}) replace F5 and G5 with Frequency and Probability respectively. Kris ExcelFox http://www.excelfox.com/forum/forum.php -- FORUM RULES (986+

Re: $$Excel-Macros$$ Macro To Transpose Selected Row Data To Column Format

Hi Try this Sub kTest() Dim ka, k(), i As Long, c As Long, n As Long, Hdr, x Dim wks As Worksheet, Flds Hdr = Array(NAME, Specialty_name, Office_name, Address_1, Address_2, _ Address, Phone_number_1, Fax_number) ka =

$$Excel-Macros$$ Strikethrough the figures in Excel.....

Dear Experts, If I type *'523* (value with apostrophy) in a cell when I press Enter ,the value should become Strikethrough like 523. Pl. help is there any way? If macro is possible can also work. Regards,, Dhananjay -- FORUM RULES (986+ members already BANNED for violation) 1) Use

Re: $$Excel-Macros$$ Macro To Transpose Selected Row Data To Column Format

Kris, You are amazing and gracious for your help and very quick repsonse. Thank you millions! John On Tue, May 8, 2012 at 10:09 AM, Krishna Kumar krishnak...@gmail.comwrote: Hi Try this Sub kTest() Dim ka, k(), i As Long, c As Long, n As Long, Hdr, x Dim wks As Worksheet,

Re: $$Excel-Macros$$ Ranking formula problem

Thanks Don really simple formula, trying it out now. On Tue, May 8, 2012 at 2:12 PM, dguillett1 dguille...@gmail.com wrote: could have put 1,2,3 in col a and this in col b and copied across and down =INDEX(data!A:A,MATCH($A21,data!$O:$O,0)) Don Guillett Microsoft MVP Excel SalesAid

Re: $$Excel-Macros$$ Macro To Transpose Selected Row Data To Column Format

John You are welcome. Thanks for the feedback Kris ExcelFox http://www.excelfox.com/forum/forum.php -- 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

Re: $$Excel-Macros$$ Macro To Transpose Selected Row Data To Column Format

Replace ReDim k(1 To UBound(ka, 1) * (UBound(Hdr) + 1) + UBound(Hdr) + 1, 1 To 1) with ReDim k(1 To 1, 1 To 1) Kris ExcelFox http://www.excelfox.com/forum/forum.php -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles,

Re: $$Excel-Macros$$ Count sum color cell, cells have conditional formatting

Thx Asa Rossoff ,all this I know, also the links Please Rajan you help !!! ... Chilexcel 2012/5/7 Asa Rossoff a...@lovetour.info: Chil, Also see Bob Phillip's method @ http://www.xldynamic.com/source/xld.CFConditions.html -Original Message- From: Asa Rossoff

Re: $$Excel-Macros$$ Strikethrough the figures in Excel.....

Right click sheet tabview codeinsert thismodify range to suit Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Target, Range(a1:b21)) Is Nothing Then Exit Sub If VarType(Target) = 8 And IsNumeric(Left(Target, 1)) Then With Target.Font .FontStyle = Bold .Strikethrough = True

Re: $$Excel-Macros$$ Macro To Transpose Selected Row Data To Column Format

Absolutely fantastic! Thank you for your generous help. John On Tue, May 8, 2012 at 11:07 AM, Krishna Kumar krishnak...@gmail.comwrote: Replace ReDim k(1 To UBound(ka, 1) * (UBound(Hdr) + 1) + UBound(Hdr) + 1, 1 To 1) with ReDim k(1 To 1, 1 To 1) Kris ExcelFox

Re: $$Excel-Macros$$ Count sum color cell, cells have conditional formatting

http://www.xldynamic.com/source/xld.ColourCounter.html Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: ChilExcel Sent: Monday, May 07, 2012 6:01 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Count sum color cell,

Re: $$Excel-Macros$$ Count sum color cell, cells have conditional formatting

Thx Don Guillett ,all this I know, also the links 2012/5/8 dguillett1 dguille...@gmail.com: http://www.xldynamic.com/source/xld.ColourCounter.html Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: ChilExcel Sent: Monday, May

$$Excel-Macros$$ Date Problem

Hello Pls i want to get the month of today such as May but if i use this formula TEXT(MONTH(TODAY()),mmm) its evaluates to Jan, however if i evaluate only MONTH(TODAY()) is gets the correct month which is 5, so why am i getting Jan, when i add the text fucntion. i need it to be dynamic, thats

Re: $$Excel-Macros$$ Date Problem

Just Use =TEXT(TODAY(),mmm) Regards, Sam Mathai Chacko On Tue, May 8, 2012 at 11:02 AM, hilary lomotey resp...@gmail.com wrote: Hello Pls i want to get the month of today such as May but if i use this formula TEXT(MONTH(TODAY()),mmm) its evaluates to Jan, however if i evaluate only

Re: $$Excel-Macros$$ Date Problem

Thanks Sam for the quick response. Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Sam Mathai Chacko samde...@gmail.com Sender: excel-macros@googlegroups.com Date: Tue, 8 May 2012 11:20:37 To: excel-macros@googlegroups.com Reply-To:

Re: $$Excel-Macros$$ Date Problem

Another approach.. * =CHOOSE(MONTH(TODAY()),Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec) * -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Tue, May 8, 2012 at 11:32 PM, hilary lomotey resp...@gmail.com wrote: Hello Pls i want to get the

Re: $$Excel-Macros$$ Date Problem

Thanks for this as well Noorain. But can you explain why excel was returning Jan when I tried ♍Ɣ earlier formula? Just for ♍Ɣ information. Thnks Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: NOORAIN ANSARI noorain.ans...@gmail.com Sender:

Re: $$Excel-Macros$$ Date Problem

Because today is the 5th month. And the value of 5 is actually equivalent to 5 days starting from day zero. In other words, it is just the 5th of January 1900. And the month of 5th January 1900 is Jan of course. Regards, Sam Mathai Chacko On Tue, May 8, 2012 at 11:33 AM, resp...@gmail.com

RE: $$Excel-Macros$$ Table data fit the page size..(auto)

I see you already have it fit to page when printed - Do you mean you want to have the table forced into the shape of the page to completely fill the page? If so, I think you will need a macro, and it could be a bit tricky. You currently have a macro adjusting the margins in the

Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 2 Messages in 2 Topics

Please remove me from this group Sent from my iPhone On May 8, 2012, at 6:23 PM, excel-macros@googlegroups.com wrote: Today's Topic Summary Group: http://groups.google.com/group/excel-macros/topics Table data fit the page size..(auto) [1 Update] To create a serial number based on some

RE: $$Excel-Macros$$ Date Problem

hilary, Instead of TEXT(MONTH(TODAY()),mmm), I think you were aiming for TEXT(TODAY(),mmm). You could also use =TODAY() with a cell format of mmm to have it displayed as Jan/Feb/etc. but still hold a dateserial as the underlying value of the cell. Asa From:

RE: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 2 Messages in 2 Topics

To unsubscribe from this group, mailto:excel-macros+unsubscr...@googlegroups.com send an empty message to excel-macros+unsubscr...@googlegroups.com. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Gaurav Parmar Sent: Tuesday, May 08, 2012 4:33 PM To:

RE: $$Excel-Macros$$ Fwd: Need help on data

Hello Lokesh, You may want to try Debra Dalgleish and Dave Petersen's method detailed here: http://contextures.com/exceldataentryupdateform.html Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Lokesh Loki Sent: Tuesday, May 08, 2012 7:30 AM To:

Re: $$Excel-Macros$$ Fwd: Need help on data

Hi Lokesh I do not think you will get a reply from this group to to your question as it is. What you are asking for is more in the nature of application design and that is not a quick and simple answer to a question. This group exists to help people who are having problems with VBA in Excel.

RE: $$Excel-Macros$$ Count sum color cell, cells have conditional formatting

Hi Chil, Did you try to use those functions, and if so, please post your effort and what trouble you are having. Asa -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ChilExcel Sent: Tuesday, May 08, 2012 8:08 AM To:

$$Excel-Macros$$ office stock-help

Hi, PFA the attachment. Office stock consumption statement is attached where I need the help on solving the explained below: .. I need the closing stock of the relevant items from the other work sheet 'closing st n Utlzn-Apr 2012' in the column 'Qty' of the work sheet 'May 2012' if the

RE: $$Excel-Macros$$ Table data fit the page size..(auto)

Ya, but it doesn't zoom to the margin, and fit all the four sides. Regards, Muneer, CC I see you already have it fit to page when printed - Do you mean you want to have the table forced into the shape of the page to completely fill the page? If so, I think you

Re: $$Excel-Macros$$ office stock-help

HI, Try Vlookup for bring closing datas... =VLOOKUP(D2,'Closing St n Utlzn-Apr 2012'!$A$2:$C$65,3,FALSE) Regards, MARIES. On Tue, May 8, 2012 at 9:31 PM, Smitha S R sperdwo...@gmail.com wrote: Hi, PFA the attachment. Office stock consumption statement is attached where I need the help

Re: $$Excel-Macros$$ office stock-help

Hi, PFA the statement with the formula as mentioned in the below mail. But if the particulars is selected Purchase /Issue other than Opening Stock , the qty is not changing. Please help. On Wed, May 9, 2012 at 10:53 AM, Maries talk2mar...@gmail.com wrote: HI, Try Vlookup for bring closing