$$Excel-Macros$$ Sum based on cell criteria

Pls suggest formula -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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

Re: $$Excel-Macros$$ Re: girls online click here http://4medicaltips.blogspot.com/2012/12/what-is-ankylosing-spondylitis.htm

Dear Ayush , Pl ban this user ASAP. Warm Regards, Gawli Anil On Thu, Jan 17, 2013 at 8:40 AM, Prince wrote: > Just Ban this user. > > On Thursday, January 17, 2013 2:41:34 AM UTC+5:30, mr.amer...@gmail.comwrote: >> >> girls online click here >> >> http://4medicaltips.blogspot.**com/2012/12/wh

Re: $$Excel-Macros$$ Getting Minimum no highlighted

Dear Amit Pl see the attached file. Is is OK? Warm Regards, Gawli Anil On Thu, Jan 17, 2013 at 11:23 AM, Amit Gandhi wrote: > Thanks Anil > > I am following all below steps, but unable to apply right min formula. Can > you please suggest what MIN formula to be applied based on attached sampl

Re: $$Excel-Macros$$ Need formula

On Thu, Jan 17, 2013 at 12:21 PM, Deepak Rawat wrote: > Dear Anoop, > > I need as i given table. > > regards, > Deepak rawat > > > On Thu, Jan 17, 2013 at 11:43 AM, Anoop K Sharma > wrote: >> >> Hi Deepak, >> >> PFA. You need to refresh the pivot on first sheet. >> >> Regards, >> Anoop >> Sr. Dev

Re: $$Excel-Macros$$ Help in extracting data

Dear Chaya , If u dont want the screen undating then after Sub proc_ExtractDates() write Application.DisplayAlerts = False Application.ScreenUpdating = False Then their will be no screen changing warm Regards, Gawli Anil On Thu, Jan 17, 2013 at 12:23 PM, Anoop K Sharma wrote: > I have restricte

Re: $$Excel-Macros$$ Need formula

Use the updated file. You can move pivot anywhere in the workbook. There is no change in your table formatting. On Thu, Jan 17, 2013 at 12:21 PM, Deepak Rawat wrote: > Dear Anoop, > > I need as i given table. > > regards, > Deepak rawat > > > On Thu, Jan 17, 2013 at 11:43 AM, Anoop K Sharma >

Re: $$Excel-Macros$$ Help in extracting data

I have restricted the flickering of screen. Use below the updated one. Paste the below code in the module. Press alt + F8 and run macro proc_ExtractDates. Remember you are getting output on worksheet named as "Sheet5". If it doesn't exist then make a new worksheet with this name. Sub proc_Extra

Re: $$Excel-Macros$$ Need formula

Dear Anoop, I need as i given table. regards, Deepak rawat On Thu, Jan 17, 2013 at 11:43 AM, Anoop K Sharma wrote: > Hi Deepak, > > PFA. You need to refresh the pivot on first sheet. > > Regards, > Anoop > Sr. Developer > > > On Thu, Jan 17, 2013 at 11:16 AM, Deepak Rawat wrote: > >> HI, >> >>

Re: $$Excel-Macros$$ Help in extracting data

Paste the below code in the module. Press alt + F8 and run macro proc_ExtractDates. Remember you are getting output on worksheet named as "Sheet5". If it doesn't exist then make a new worksheet with this name. Sub proc_ExtractDates() Dim i As Integer Dim lRow As Long Dim fndVal As Va

Re: $$Excel-Macros$$ Help in extracting data

Dear Anoop sir, i have tried for the same for 100 sheets, which contains the same, there nothing value is coming. i mean is there any bound for number of sheet, like maximum of 6 or 7 sheet. what you have provided to me is excellent working but i try for 100 sheets , the data is missing.

Re: $$Excel-Macros$$ Need formula

Hi Deepak, PFA. You need to refresh the pivot on first sheet. Regards, Anoop Sr. Developer On Thu, Jan 17, 2013 at 11:16 AM, Deepak Rawat wrote: > HI, > > Could u suggest any formula to get summary from the data attached in > summary sheet. > > -- > Join official Facebook page of this forum @

Re: $$Excel-Macros$$ Help in extracting data

Dear Anoop, Awesome and unbelievable, it was more then expected. any way i did not check those value. once i check, i revert you back. thanks for helping me. thank you all. -Chaya On Thu, Jan 17, 2013 at 11:19 AM, Anoop K Sharma wrote: > Hi Chaya > > Here you go > Note:- You can

Re: $$Excel-Macros$$ Getting Minimum no highlighted

Thanks Anil I am following all below steps, but unable to apply right min formula. Can you please suggest what MIN formula to be applied based on attached sample file. Regards Amit On Thu, Jan 17, 2013 at 11:08 AM, अनिल नारायण गवली wrote: > Dear Amit, > > First select the desire coloum and cl

Re: $$Excel-Macros$$ Getting Minimum no highlighted

Thanks Amresh On Wed, Jan 16, 2013 at 6:33 PM, Amresh Maurya wrote: > PFA ATTACHED FILE. > > USE THIS CODE > Sub minmm() > Dim n As Integer > Range("B5:B5").Select > With Selection.Interior > .PatternColorIndex = xlAutomatic > .ThemeColor = xlThemeColorDark1 > .TintAndS

$$Excel-Macros$$ Need formula

HI, Could u suggest any formula to get summary from the data attached in summary sheet. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Pr

Re: $$Excel-Macros$$ Getting Minimum no highlighted

Dear Amit, First select the desire coloum and click on conditional formatting and there select a new rule and then click on format only cell that contain. there u'll find cellvalue,between,and two formula text box change the text box of between to lessthanequalto and then the next texbox write the

$$Excel-Macros$$ Re: data update.

Hi Midhun, Just Assign this macro to your update button. Public Sub GetRecords() Dim rngWeek As Range Dim rngTarget As Range Dim intRow As Integer With ThisWorkbook.Worksheets("Data") Set rngWeek = .Range("A2") Set rngTarget = .Range("A10").Cur

Re: $$Excel-Macros$$ data update.

Hi Midhun Thampan., PFA SOLVED FILE. Regards Amresh On Thu, Jan 17, 2013 at 10:17 AM, Midhun Thampan wrote: > hi all; > > this is an excel sheet in which when i select the specific week the > data should be updated in the databse below according to the week and > the measurement. > > so i wante

$$Excel-Macros$$ Re: Please Try this ,I assure you will be benefited

Nice and usefull Material will check and revert you with feedback. Regards Prince On Thursday, January 17, 2013 10:10:13 AM UTC+5:30, aju wrote: > > Please see the *Reconciliation Tool *attached herewith,Which is an * > EXCEL-ADDIN* created by me.Which very useful for Handling large excel > d

$$Excel-Macros$$ data update.

hi all; this is an excel sheet in which when i select the specific week the data should be updated in the databse below according to the week and the measurement. so i wanted a macro to do the same work as i click on update. So can anyone help me out in this. tried many formulas but did not wor

$$Excel-Macros$$ Re: girls online click here http://4medicaltips.blogspot.com/2012/12/what-is-ankylosing-spondylitis.htm

Just Ban this user. On Thursday, January 17, 2013 2:41:34 AM UTC+5:30, mr.amer...@gmail.com wrote: > > girls online click here > > > http://4medicaltips.blogspot.com/2012/12/what-is-ankylosing-spondylitis.html > -- Join official Facebook page of this forum @ https://www.facebook.com/discussexc

$$Excel-Macros$$ girls online click here http://4medicaltips.blogspot.com/2012/12/what-is-ankylosing-spondylitis.htm

girls online click here http://4medicaltips.blogspot.com/2012/12/what-is-ankylosing-spondylitis.html -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Hel

Re: $$Excel-Macros$$ HyperLinks to Sheets * * * *

YOU HAVE TO AMEND THE WORKSHEET NAME IN THE CODE TO SUIT UR WORKSHEET NAME On Wed, Jan 16, 2013 at 4:07 PM, Pankaj Singh wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (pankajpepsic...@gmail.com) Add cleanup > rule

Re: $$Excel-Macros$$ HyperLinks to Sheets * * *

Sub ReturnToD3() Worksheets("TEMPLATE (3)").Activate Range("A1").Select End Sub On Wed, Jan 16, 2013 at 3:33 PM, Pankaj Singh wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (pankajpepsic...@gmail.com) Add cleanup > rule

Re: $$Excel-Macros$$ HyperLinks to Sheets * *

How to get back in hyper liked sheet after clicking on hyper link..need code..plz. On Wed, Jan 16, 2013 at 9:00 PM, Hilary Lomotey wrote: > > > > > *BINGO- IT WORKING TO PERFECTION,* > * > * > *very grateful Ashish and Rajan > * > * > * > * > * > * > * > On Wed, Jan 16, 2013 at 3:18 PM, ashish k

Re: $$Excel-Macros$$ Any one help to solve the Test

help any one to solve the attached sheet of excel plz. On Tue, Jan 15, 2013 at 9:50 PM, Pankaj Singh wrote: > Dear Team, > > > Kidly help so sole the test sheet. > > > Thanks > pankaj kumar > > -- > Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULE

Re: $$Excel-Macros$$ HyperLinks to Sheets * *

*BINGO- IT WORKING TO PERFECTION,* * * *very grateful Ashish and Rajan * * * * * * * On Wed, Jan 16, 2013 at 3:18 PM, ashish koul wrote: > Sub CreateLinksToAllSheets() > Dim sh As Worksheet > Dim cell As Range, i As Long, j As Long > i = 1 > j = 1 > > For Each sh In ActiveWorkbook.Worksheets >

Re: $$Excel-Macros$$ HyperLinks to Sheets *

Try this Sub CreateLinksToAllSheets() Dim sh As Worksheet Dim cell As Range, i As Long, j As Long i = 1 j = 1 For Each sh In ActiveWorkbook.Worksheets If ActiveSheet.Name <> sh.Name Then Cells(j, i).Select ActiveCell.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:=

Re: $$Excel-Macros$$ HyperLinks to Sheets *

Thanks rajan Being a while, hope you are well .The idea is right but it doesnt actually help my course let me try and explain again if its gets to row 30 in the first column on the second column it should start from row 1 to 30 again in that order. Hope this explains well On Wed, Jan 16, 2013 at

Re: $$Excel-Macros$$ Required transpose Formula

Thanks a lot Noorin bahi On Wed, Jan 16, 2013 at 6:25 PM, NOORAIN ANSARI wrote: > Dear Amar, > > Please try it.. > > =INDEX($E$3:$E$65,SMALL(IF($D$3:$D$65=K$3,ROW($E$3:$E$65),""),ROW(B1))-2) > with ctrl+shift+enter > > see attached sheet for more clarity. > > > > -- > With Regards, > Noorain Ansa

Re: $$Excel-Macros$$ Getting Minimum no highlighted

PFA ATTACHED FILE. USE THIS CODE Sub minmm() Dim n As Integer Range("B5:B5").Select With Selection.Interior .PatternColorIndex = xlAutomatic .ThemeColor = xlThemeColorDark1 .TintAndShade = 0 .PatternTintAndShade = 0 End With n = 5 Sheet1.Cells(5, 14).Formula =

Re: $$Excel-Macros$$ HyperLinks to Sheets

Sub CreateLinksToAllSheets() Dim sh As Worksheet Dim cell As Range For Each sh In ActiveWorkbook.Worksheets If ActiveSheet.Name <> sh.Name Then ActiveCell.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _ "'" & sh.Name & "'" & "!A1", TextToDisplay:=sh.Name i

$$Excel-Macros$$ HyperLinks to Sheets

Hello Experts, The code below creates hyperlinks in a worksheets, what i require is a little modification to this. assuming i have about 100 sheets in a work book, this code will line up all the hyperlinks of the worksheet name in a single row (ie 100 rows), what i need is that at the end of every

$$Excel-Macros$$ Required transpose Formula

Hi All Pls Solution for above attached sheet.suggest any simple formula pls. Amar -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem

Re: $$Excel-Macros$$ Getting Minimum no highlighted

Thanks Anil But i am unable to do so? Can you show this in example file. Regards Amit On Wed, Jan 16, 2013 at 2:03 PM, अनिल नारायण गवली wrote: > Dear Amit, > > U can use conditional format for each col in that u can use format only > rows that contain lessthanequalto and in formula write =min

Re: $$Excel-Macros$$ Re: Countif Help !

Prince & Anil Thx, now working properly. Regards, Iqbal On 16 January 2013 16:38, Prince wrote: > Hi Shaikh, > > Just Paste these formula and enjoy. > > (I5 to I11) > > =COUNTIFS($C$2:$C$246,">=100") > =COUNTIFS($C$2:$C$246,">=90",$C$2:$C$246,"<=99") > =COUNTIFS($C$2:$C$246,">=80",$C$

$$Excel-Macros$$ Re: Countif Help !

Hi Shaikh, Just Paste these formula and enjoy. (I5 to I11) =COUNTIFS($C$2:$C$246,">=100") =COUNTIFS($C$2:$C$246,">=90",$C$2:$C$246,"<=99") =COUNTIFS($C$2:$C$246,">=80",$C$2:$C$246,"<=89") =COUNTIFS($C$2:$C$246,">=70",$C$2:$C$246,"<=79") =COUNTIFS($C$2:$C$246,">=60",$C$2:$C$246,"<=69")

Re: $$Excel-Macros$$ Need Formula

plz revert me how to use filter in column. On Wednesday, January 16, 2013 9:46:56 AM UTC+5:30, अनिल नारायण गवली wrote: > > Pl Find attached herewith with two formulae 1) Sumifs and 2) sumproduct. > > > Warm Regards, > Gawli Anil > > On Tue, Jan 15, 2013 at 8:39 PM, ashish koul > > wrote: > >

$$Excel-Macros$$ Countif Help !

Dear Friends, Help me as per attached file countif formula, I try but not get output properly. Regards, Iqbal -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help,

Re: $$Excel-Macros$$ Re: Reposition the cursor in an Excel macro

Swapnil, Thanks for your reply. I read your explanation twice and I think I understand what you are saying. I've inserted a new line at the top of sheet 2. I've made the minor modifications in the visual basic editor and all works, thank you very much. I'm just amazed that you can write such st

Re: $$Excel-Macros$$ Import External Data web query

hey sorry click on From Web not From Access sorry for inconvience caused..:( Warm Regards, Gawli anil On Wed, Jan 16, 2013 at 4:06 PM, अनिल नारायण गवली wrote: > first of all go to data tab > there u'll find from access > there enter the URL and import that content to any of the sheet and se

Re: $$Excel-Macros$$ Import External Data web query

first of all go to data tab there u'll find from access there enter the URL and import that content to any of the sheet and see where the opening and closing number is displayed. then do as i have given. Then goto connections and active the checkbox and give 1 minute to referesh. That's it i hav

$$Excel-Macros$$ Re: Need formula based on 3 condition

hello suyog, please try this :- =+IF((B2+12)>B4,(B7+B10),IF((B2+12)B4:B5,((B5-B2+12)*(B8/12) On Friday, January 11, 2013 3:18:13 PM UTC+5:30, Suyog Kulkarni wrote: > > Hello All, > > Please see attached excel, I'm confused how can I set IF statement based > on varying 3 condition for one c

Re: $$Excel-Macros$$ Getting Minimum no highlighted

Dear Amit, U can use conditional format for each col in that u can use format only rows that contain lessthanequalto and in formula write =min(range) and format cell color to desire color. Regards, Gawli Anil On Wed, Jan 16, 2013 at 1:24 PM, Amresh Maurya wrote: > Hello Amit, > > PFA file .Ki