Re: $$Excel-Macros$$ Problem assigning a function to a variable

Change 16 to 15 On 05-Jun-2016 3:50 AM, "Laura Wheaton-Werle" < la...@doublewcommunications.com> wrote: > I've created a simple VBA code that copies a line of code to a specified > range. > > Sub PowerOfOne_Report() > > ActiveWorkbook.Worksheets("PowerOfOne").Rows("3:3").Copy > Act

Re: $$Excel-Macros$$ Problem in Pivot Table

Perfect... Thanks! *With regards,**Pravin Gunjal* *Mobile: 77100 * *97250* On Mon, Apr 25, 2016 at 1:17 PM, Abhishek Jain wrote: > Try this: > >1. Right-click a cell in the pivot table >2. Click on PivotTable options >3. Click on the Data tab >4. In the Retain Items section,

Re: $$Excel-Macros$$ Problem in Pivot Table

Try this: 1. Right-click a cell in the pivot table 2. Click on PivotTable options 3. Click on the Data tab 4. In the Retain Items section, select None from the drop down list. 5. Click OK, then refresh the pivot table. On Mon, Apr 25, 2016 at 12:54 PM, Pravin Gunjal wrote: > Not

Re: $$Excel-Macros$$ Problem in Pivot Table

Not relevant.. *With regards,**Pravin Gunjal* *Mobile: 77100 * *97250* On Mon, Apr 25, 2016 at 12:41 PM, Satendra kumar wrote: > Hi, > > you can check name spelling or space. > > thanks > satendra > > On Mon, Apr 25, 2016 at 12:32 PM, Pravin Gunjal wrote: > >> Hi Friends, >> >> I got an er

Re: $$Excel-Macros$$ Problem in Pivot Table

Hi, you can check name spelling or space. thanks satendra On Mon, Apr 25, 2016 at 12:32 PM, Pravin Gunjal wrote: > Hi Friends, > > I got an error while arranging the data in pivot table. > > The list has only 34 names common in Data Sheet while when I click on Row > Lable Filter in Pivot Sheet

Re: $$Excel-Macros$$ problem in code fpr data copied from text to number format

Thank you Mr.Paul to suggest me best in coding. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Tue, Feb 3, 2015 at 5:50 PM, Paul Schreiner wrote: > The problem is: > When you insert a row in your ta

Re: $$Excel-Macros$$ problem in code fpr data copied from text to number format

The problem is: When you insert a row in your table, column "D" doesn't "inherit" the properties of the previous row, but instead reverts to the "General" format of the rest of the column. There's a couple ways of handling this. I tried both and they both seem to work: Select the entire colum

Re: $$Excel-Macros$$ Problem With Timer-inVBA

I have seen it ; look into code after going back home On Feb 2, 2015 3:58 PM, "Vaibhav Joshi" wrote: > Great, pl note i have replaced your code.. > > On Mon, Feb 2, 2015 at 3:53 PM, Soumyendu Paul > wrote: > >> Thanks Vaibhav it's working >> On Feb 2, 2015 12:23 PM, "Vaibhav Joshi" wrote: >> >

Re: $$Excel-Macros$$ Problem With Timer-inVBA

Great, pl note i have replaced your code.. On Mon, Feb 2, 2015 at 3:53 PM, Soumyendu Paul wrote: > Thanks Vaibhav it's working > On Feb 2, 2015 12:23 PM, "Vaibhav Joshi" wrote: > >> Hi Soumyendu.. >> >> check this.. >> >> Cheers!! >> >> On Mon, Feb 2, 2015 at 10:58 AM, Soumyendu Paul >> wrote:

Re: $$Excel-Macros$$ Problem With Timer-inVBA

Thanks Vaibhav it's working On Feb 2, 2015 12:23 PM, "Vaibhav Joshi" wrote: > Hi Soumyendu.. > > check this.. > > Cheers!! > > On Mon, Feb 2, 2015 at 10:58 AM, Soumyendu Paul > wrote: > >> Please help!! >> On Feb 2, 2015 7:21 AM, "Soumyendu Paul" wrote: >> >>> I have already shared file please

Re: $$Excel-Macros$$ Problem With Timer-inVBA

Hi Soumyendu.. check this.. Cheers!! On Mon, Feb 2, 2015 at 10:58 AM, Soumyendu Paul wrote: > Please help!! > On Feb 2, 2015 7:21 AM, "Soumyendu Paul" wrote: > >> I have already shared file please see attachment >> On Feb 2, 2015 3:27 AM, "Paul Schreiner" wrote: >> >>> Can you share the file

Re: $$Excel-Macros$$ Problem With Timer-inVBA

Please help!! On Feb 2, 2015 7:21 AM, "Soumyendu Paul" wrote: > I have already shared file please see attachment > On Feb 2, 2015 3:27 AM, "Paul Schreiner" wrote: > >> Can you share the file? >> How are you using/displaying a timer? >> >> you said you're using a selectionchange event, but what t

Re: $$Excel-Macros$$ Problem With Timer-inVBA

I have already shared file please see attachment On Feb 2, 2015 3:27 AM, "Paul Schreiner" wrote: > Can you share the file? > How are you using/displaying a timer? > > you said you're using a selectionchange event, but what type of timer are > you using? > > *Paul* > --

Re: $$Excel-Macros$$ Problem With Timer-inVBA

Can you share the file? How are you using/displaying a timer? you said you're using a selectionchange event, but what type of timer are you using? Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can

Re: $$Excel-Macros$$ Problem Autofilter Date Range

Change this line to FDate = Range("J1")x1 Ldate = Range("J2")x1 Cheers! ! On Jan 18, 2015 3:31 PM, "Ashish Bhalara" wrote: > Dear experts, > > I want automatic filtering of Date range in cell C11 but the below code is > not work for Date Field, the output is hide to all data. Please sugg

Re: $$Excel-Macros$$ Problem in calculating yield to maturity

Check this. http://www.tvmcalcs.com/calculators/apps/excel_bond_yields Dear Friends, I am new to excel and my query is very small. I have to calculate yield to maturity for a bond. I am calculating it using XIRR and yield function in excel. Values are different. XIRR =12.13% whereas Yield =

Re: $$Excel-Macros$$ Problem for copy and paste range in one sheet to other sheet

Cheers!! On Fri, Jul 18, 2014 at 9:09 PM, renuka chari wrote: > Thanks alot sir > > > On Friday, 18 July 2014 14:00:05 UTC+5:30, Vabz wrote: > >> Hi >> >> PFA >> >> Cheers!! >> >> >> On Fri, Jul 18, 2014 at 9:27 AM, renuka chari wrote: >> >>> Dear sir, >>> i was prepared a macro for a

Re: $$Excel-Macros$$ Problem for copy and paste range in one sheet to other sheet

Thanks alot sir On Friday, 18 July 2014 14:00:05 UTC+5:30, Vabz wrote: > > Hi > > PFA > > Cheers!! > > > On Fri, Jul 18, 2014 at 9:27 AM, renuka chari > wrote: > >> Dear sir, >> i was prepared a macro for autofilter the range based on column a1 in >> unique values and >> paste this rang

Re: $$Excel-Macros$$ Problem for copy and paste range in one sheet to other sheet

Hi PFA Cheers!! On Fri, Jul 18, 2014 at 9:27 AM, renuka chari wrote: > Dear sir, > i was prepared a macro for autofilter the range based on column a1 in > unique values and > paste this range into sheet2 side by side > in this i have succed in the autofilter the range data but failed to copy

Re: $$Excel-Macros$$ Problem for copy and paste range in one sheet to other sheet

Dear sir, i was prepared a macro for autofilter the range based on column a1 in unique values and paste this range into sheet2 side by side in this i have succed in the autofilter the range data but failed to copy this data into sheet2 side by side i think may be some logic was missing in secoun

Re: $$Excel-Macros$$ Problem for copy and paste range in one sheet to other sheet

What is error going on..Completely explain On Fri, Jul 18, 2014 at 2:00 AM, Renukachari Kasee wrote: > Dear Experts please help me in this regard. > > my macro was not working properly > > please help me...its urgent > > > > > > > > *(¨`•.•´¨) Always`•.¸(¨`•.•´¨) Keep(¨`•.•´¨)¸.•´ Smiling!!

Re: $$Excel-Macros$$ Problem with Advanced Filter

Dear Hilary, U have to release the earlier filter i.e clear filter criteria and then apply the fresh one. Warm Regards, Gawli Anil. On Thu, Feb 27, 2014 at 9:06 AM, mrExcel4u wrote: > Plz share your workbook > > Thanks & regards, > > www.MrExcel4U.com > > > On Thu, Feb 27, 2014 at 2:06 AM, Hil

Re: $$Excel-Macros$$ Problem with Advanced Filter

Plz share your workbook Thanks & regards, www.MrExcel4U.com On Thu, Feb 27, 2014 at 2:06 AM, Hilary Lomotey wrote: > i have written a macro to extract couple of data from another sheet with > advanced filter > > 'extracting equity statement > Sheet24.Range("Eq

Re: $$Excel-Macros$$ problem

Dear Sudhir, Welcome. Thanks & Regards, Ashish On Monday, 23 December 2013, SUDHIR VERMA wrote: > thankx Ashish > > > On 15 December 2013 19:10, Ashish Kumar > 'kumar.ashish...@gmail.com');> > > wrote: > >> Dear Sudhir, >> >> Go to file option then click on options tab then click on language

Re: $$Excel-Macros$$ problem

thankx Ashish On 15 December 2013 19:10, Ashish Kumar wrote: > Dear Sudhir, > > Go to file option then click on options tab then click on language button > then select your language english and save it. > > Thanks, > Ashish > > > On Saturday, 14 December 2013, SUDHIR VERMA wrote: > >> Dear All,

Re: $$Excel-Macros$$ problem

Dear Sudhir, Go to file option then click on options tab then click on language button then select your language english and save it. Thanks, Ashish On Saturday, 14 December 2013, SUDHIR VERMA wrote: > Dear All, > > i am suffer problem in excel, when i type any key then generate Urdu word. > pl

Re: $$Excel-Macros$$ Problem - Tag in Cell

Hi I didnt get you by that, pl share sample file. Thanks On Sat, Aug 3, 2013 at 12:06 PM, Anil Saxena wrote: > > Dear Expert, > > How can remove the Tag in a Cell, becouse I want delimited. > -- > > *Anil Saxena* > > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?

Re: $$Excel-Macros$$ Problem with searching through rows and their associated columns

can u share the sample file with us Regards Ashish On Thu, Jul 4, 2013 at 7:07 AM, Brian Yam wrote: > Dear All, > > I am new to VBA programming > I happen to need great and urgent help on a project that I am currently > working on > I would like to search through the worksheet, and find "N" or

Re: $$Excel-Macros$$ Problem in Line Graph

Hi, Thanks for you reply I tried that option too but I will not get graph when I do that and even I dont want to use this option as I am plotting multi graphs in different sheets. Regards, Chandra Shekar B On Thu, May 30, 2013 at 9:05 PM, xlstime wrote: > Hi Chander, > > Change Switch Row/Co

Re: $$Excel-Macros$$ Problem in Line Graph

Hi Chander, Change Switch Row/Column Right click in chart then go to select data then Switch Row/Column Hope it's fulfill your requirement . Enjoy Team XLS On Thu, May 30, 2013 at 8:02 PM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hi, > > I have issue

Re: $$Excel-Macros$$ Problem in file..?

Is it just this file which is slow or are all excel files slow? Is this file slow if you run it on another computer? What is the file extension? Xls, xlsb, xlsm,xlsb. What version of windows? Including whether it is 32 or 64 bit? What version of office? Also 32 or 64 How much memory does the com

Re: $$Excel-Macros$$ Problem in file..?

But my bad time..even I copied the data which contains formula and formats into new sheet. Same problem I face I copied the cell which contains only the data... Prabhu R On May 23, 2013 9:41 PM, "Bé Trần Văn" wrote: > Maybe because your spreadsheet data using multiple functions, or select >

Re: $$Excel-Macros$$ Problem in file..?

Maybe because your spreadsheet data using multiple functions, or select and delete the blank column on the right, select and delete the blank line underneath the sheet containing the data, if not all slow sluggish, the ultimate solution is a new file, open 1, copy each sheet and select Paste Specia

Re: $$Excel-Macros$$ Problem in file..?

are using formula in sheet?, i hope there are refrences of some other files that may be closed. it may reason you file taking more time to calculate. On Thu, May 23, 2013 at 8:05 PM, Divaker Pandey wrote: > are using formula in sheet?, i hope there are refrences of some other > files. > > > O

Re: $$Excel-Macros$$ Problem in file..?

are using formula in sheet?, i hope there are refrences of some other files. On Thu, May 23, 2013 at 5:49 PM, P.VIJAYKUMAR wrote: > Respected Prabhu, > > You are saying that the sheet is companies sheet.Is is password protected > or are any user rights restricted to used and to modify or make a

Re: $$Excel-Macros$$ Problem in file..?

Respected Prabhu, You are saying that the sheet is companies sheet.Is is password protected or are any user rights restricted to used and to modify or make any changes to the file.Check also for version based compatibility issues because earlier version had lower data input and processing capabili

Re: $$Excel-Macros$$ Problem in file..?

No david..that sheet contains no macros, even very less formula. Only the thing is some cells have formatted... Prabhu R On May 23, 2013 5:20 PM, "David Grugeon" wrote: > Also do you have macros which are run when changes are made to the sheets. > It may be possible to reorganise them so they r

Re: $$Excel-Macros$$ Problem in file..?

Also do you have macros which are run when changes are made to the sheets. It may be possible to reorganise them so they run faster or are not triggered so readily. Regards David Grugeon On 23 May 2013 21:47, David Grugeon wrote: > Try setting the calculation to Manual. Then see if Cut and

Re: $$Excel-Macros$$ Problem in file..?

Try setting the calculation to Manual. Then see if Cut and Paste still takes a lot of time. It could be that there are a lot of formulas having to be recalculated when there is a change to the worksheet. If this is identified as the cause you may be able to get a gain by redesigning hr worksheet

Re: $$Excel-Macros$$ Problem in file..?

thanks vijay, lemme try this too. but my doubt is if already "Use all the processors on this computer" option is selected. then..? Regards, Prabhu R On 23 May 2013 16:48, P.VIJAYKUMAR wrote: > Respected Prabhu, > > Please go to excel options button and from there go to the advanced tab > an

Re: $$Excel-Macros$$ Problem in file..?

Respected Prabhu, Please go to excel options button and from there go to the advanced tab and under that go to the formulas section.The third point will contain how many processors are used for excel calculations.check the radio button to use all the processors for calculations.This may boost up

Re: $$Excel-Macros$$ Problem in file..?

Hi Abhishek : thanks for the idea. i will try this one. David : i am unable attach the file, because it is violation in our office. On 23 May 2013 13:39, David Grugeon wrote: > Can't guess without seeing the file. Can you attach it? > > Regards > David Grugeon > > > > On 23 May 2013 16:49,

Re: $$Excel-Macros$$ Problem in file..?

Can't guess without seeing the file. Can you attach it? Regards David Grugeon On 23 May 2013 16:49, Prabhu Pinky wrote: > Hi experts, > I have one excel file. Size is below 1mb. Even though it is very slow > working in that file. If I do copy paste any single cell, it takes too much > time.

Re: $$Excel-Macros$$ Problem in file..?

Not sure if this is your case but: Press F5 > Special > Objects and if Excel finds anything, press Delete. Might help. On Thu, May 23, 2013 at 12:19 PM, Prabhu Pinky wrote: > Hi experts, > I have one excel file. Size is below 1mb. Even though it is very slow > working in that file. If I do copy

Re: $$Excel-Macros$$ Problem in conditional formatting *

Hi, I hope you are looking for the column "M". Please change the formula reference as "M:M" instead of "A". Regards, Saravanan R. On Wednesday, 13 February 2013 21:40:01 UTC+5:30, hilary lomotey wrote: > > > Hello > > > Pls see attached > > HTH > > > On Wed, Feb 13, 2013 at 12:44 PM, Ken

Re: $$Excel-Macros$$ Problem in conditional formatting *

Hello Pls see attached HTH On Wed, Feb 13, 2013 at 12:44 PM, Kenil Gala wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (keni...@yahoo.com) Add cleanup > rule

Re: $$Excel-Macros$$ Problem with excel

Hi Experts still waiting for solution Divaker On Tue, Jun 26, 2012 at 8:25 PM, Divaker Pandey wrote: > but it will lock modification in list through vba. > > Divker > > > On Tue, Jun 26, 2012 at 8:23 PM, NOORAIN ANSARI > wrote: > >> Hi Divaker, >> >> I have created a name range "List_Matters"

Re: $$Excel-Macros$$ Problem with excel

but it will lock modification in list through vba. Divker On Tue, Jun 26, 2012 at 8:23 PM, NOORAIN ANSARI wrote: > Hi Divaker, > > I have created a name range "List_Matters", > > We called it through below coding.. > > Sheet1.lstLookup.ListFillRange = "List_Matters" > > and in Property Boxt i ha

Re: $$Excel-Macros$$ Problem with excel

Hi Divaker, I have created a name range "List_Matters", We called it through below coding.. Sheet1.lstLookup.ListFillRange = "List_Matters" and in Property Boxt i have marked columnHeads as true. -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On T

Re: $$Excel-Macros$$ Problem with excel

Noorain, It will be helpful if you give me VBA code to add header column. I think listbox used header on the base of assigned range on ListFillRange properties. But it is not make sense to solve my query, because i have 72000 rows, and take selected rows form them. i could not want write it aga

Re: $$Excel-Macros$$ Problem with excel

Hi Lalit, I want to list out all company which string match in any column(available data) Divaker On Tue, Jun 26, 2012 at 8:03 PM, Divaker Pandey wrote: > Thanks Noorain, i want to list out all company details which match on > entered value in textbox. > > By the way how you added header in

Re: $$Excel-Macros$$ Problem with excel

Thanks Noorain, i want to list out all company details which match on entered value in textbox. By the way how you added header in listbox. Please tell me steps. Thanks. Divaker On Tue, Jun 26, 2012 at 7:28 PM, ╰» ℓαℓιт мσαнη wrote: > Hi Divaker, > > You query is not cleary mentioned can u pl

Re: $$Excel-Macros$$ Problem with excel

Hi Divaker, You query is not cleary mentioned can u please share a file with the full description so that we can help u as soon as possible Regards, Lalit Mohan On Tue, Jun 26, 2012 at 6:35 PM, Divaker Pandey wrote: > Hi Experts, > > Still waiting for your response. > > Divaker > > > On Tue, J

Re: $$Excel-Macros$$ Problem with excel

Hi Experts, Still waiting for your response. Divaker On Tue, Jun 26, 2012 at 5:10 PM, Divaker Pandey wrote: > Hi Noorain & Experts, > > Thanks for respond. please find attached file. > on tab sheet1 there is two activeX control > > 1. Textbox -txtLookup > 2. ListBox - lstLookup > > if user cha

Re: $$Excel-Macros$$ Problem with excel

Dear Divaker, Please share your Activelistbox with group. -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Tue, Jun 26, 2012 at 4:07 PM, Divaker Pandey wrote: > Hi Ayush, > > I want to add header column text in Activelistbox through vba. > > Can you

Re: $$Excel-Macros$$ problem with indirect function

thanks a lot Noorain this is what I was looking for Pawel From: NOORAIN ANSARI To: excel-macros@googlegroups.com Sent: Monday, May 28, 2012 9:19 AM Subject: Re: $$Excel-Macros$$ problem with indirect function On Mon, May 28, 2012 at 1:48 PM, NOORAIN

Re: $$Excel-Macros$$ problem with indirect function

On Mon, May 28, 2012 at 1:48 PM, NOORAIN ANSARI wrote: > Dear Pawel, > > Please try this one. > > =INDIRECT(ADDRESS(MATCH($B6,*INDIRECT(G$4&"!$B:$B")*,0),12,1,0,G$4),FALSE) > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspot.com > > > On M

Re: $$Excel-Macros$$ problem with indirect function

Dear Pawel, Please try this one. =INDIRECT(ADDRESS(MATCH($B6,*INDIRECT(G$4&"!$B:$B")*,0),12,1,0,G$4),FALSE) -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Mon, May 28, 2012 at 3:42 AM, pawel lupinski wrote: > Dear All, > I have prob

Re: $$Excel-Macros$$ problem with indirect function

u can use vlookup ... Regards, Anil Gawli On Mon, May 28, 2012 at 3:42 AM, pawel lupinski wrote: > Dear All, > I have problem with indirect function in this case is working fine (see > attachment), but if you can show me some extra features I'll be appreciated. > Regards, > Pawel > > -- > FORUM

Re: $$Excel-Macros$$ problem in copy paste

:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *yasir_shahjee > *Sent:* Thursday, May 03, 2012 1:03 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ problem in copy paste > > ** ** > > yes i have inst

RE: $$Excel-Macros$$ problem in copy paste

1:03 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ problem in copy paste yes i have installed On Tue, May 1, 2012 at 7:10 AM, Asa Rossoff wrote: Hi Yasir, Do you have Skype installed? See http://answers.microsoft.com/en-us/office/forum/office_2010-excel/text-loses -forma

Re: $$Excel-Macros$$ problem in copy paste

yes i have installed On Tue, May 1, 2012 at 7:10 AM, Asa Rossoff wrote: > Hi Yasir, > > Do you have Skype installed? > > ** ** > > See > http://answers.microsoft.com/en-us/office/forum/office_2010-excel/text-loses-formatting-when-i-use-cut-copy-paste/0371d013-1e5a-4d2b-874f-792d34d16c61?

RE: $$Excel-Macros$$ problem in copy paste

Hi Yasir, Do you have Skype installed? See http://answers.microsoft.com/en-us/office/forum/office_2010-excel/text-loses -formatting-when-i-use-cut-copy-paste/0371d013-1e5a-4d2b-874f-792d34d16c61?a uth=1 for more details and fix. Asa From: excel-macros@googlegroups.com [mailto:excel-mac

Re: $$Excel-Macros$$ Problem to filter in pivot table

Hi Ashish, In the pivot you can add one more entry of "Stock" in row as well > De-select "0" and then remove "Stock" from row again. I think this is what you are looking for. Regards Shekhar Sharma On Tue, Apr 24, 2012 at 10:04 AM, Ashish Bhalara wrote: > Dear expert, > > I need the filter in

Re: $$Excel-Macros$$ Problem with Format Change Upon Data Validation Change Event

ou used range instead of target for your select but I would write it like this Or even simpler by ‘dim AType As Range ‘set AType = Range("S8:AL8") If Not Intersect(Target,range(“s8:al8”) is nothing then Private Sub Worksheet_Change(ByVal Target As Excel.Range) Dim SAType As Range Set SAType = Ran

Re: $$Excel-Macros$$ Problem with Format Change Upon Data Validation Change Event

Why not simply use conditional format? Sam Mathai Chacko On Thu, Mar 29, 2012 at 8:22 PM, Tiffany wrote: > Hi - > > I'm a little new to VBA but have managed to put together a macro that half > achieves its intended purpose. > > Depending on what is chosen in a data validation cell (any cell in

Re: $$Excel-Macros$$ problem with setfocus

Thank you Noorain Bhai On Fri, Feb 17, 2012 at 2:59 PM, NOORAIN ANSARI wrote: > Dear Shankar, > > Please try it.. > > Private Sub TextBox2_Enter() > If TextBox1.Text = "" Then > MsgBox "Mandatory Field", vbQuestion + vbOKOnly, "Alert" > TextBox1.SetFocus > Else > TextBox2.SetFocus > End If > End

Re: $$Excel-Macros$$ Problem with Sumifs formula

Hi Kalyan, Try the below formula. =SUMPRODUCT((TRIM(A2:A37)=TRIM(F11))*(TRIM(B2:B37)=TRIM(G7))*(LEFT(TRIM(C2:C37),3)=LEFT(TRIM(G8),3))*(--MID(TRIM(C2:C37),FIND(" ",TRIM(C2:C37))+1,255)>=--MID(TRIM(G8),FIND(" ",TRIM(G8))+1,255))*(--MID(TRIM(C2:C37),FIND(" ",TRIM(C2:C37))+1,255)<=--MID(TRIM(G9),FIN

Re: $$Excel-Macros$$ Problem with Sumifs formula

Both are working perfectly. Thank u Viper Thanks a lot Noorain On Fri, Sep 16, 2011 at 5:48 PM, NOORAIN ANSARI wrote: > Dear Kalyan, > > Please see attached sheet.. > > =SUMIFS($E$2:$E$37,$A$2:$A$37,G11,$B$2:$B$37,H7,$C$2:$C$37,">="&INT(RIGHT(H8,LEN(H8)-FIND(" > ",H8,1))),$C$2:$C$37,"<="&INT(

Re: $$Excel-Macros$$ Problem with Sumifs formula

Dear Kalyan, Please see attached sheet.. =SUMIFS($E$2:$E$37,$A$2:$A$37,G11,$B$2:$B$37,H7,$C$2:$C$37,">="&INT(RIGHT(H8,LEN(H8)-FIND(" ",H8,1))),$C$2:$C$37,"<="&INT(RIGHT(H9,LEN(H9)-FIND(" ",H9,1 -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*

Re: $$Excel-Macros$$ Problem with Sumifs formula

Dear Kalyan why don't you use * =SUMPRODUCT(($A$2:$A$37=F11)*($B$2:$B$37=$G$7)*(--SUBSTITUTE(C2:C37,"MOC","")>=--SUBSTITUTE(G8,"MOC",""))*(--SUBSTITUTE(C2:C37,"MOC","")<=--SUBSTITUTE(G9,"MOC",""))*$D$2:$D$37) * pfa -- *Great day,* *viper * On Fri, Sep 16, 2011 at 4:11 PM, Kal xcel wrote:

Re: $$Excel-Macros$$ problem with cell width in a workbook

m:* Shankar Bheema > *Sent:* Wednesday, September 07, 2011 11:33 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ problem with cell width in a workbook > > good morning Noorain > > I tried with your example sheet. But it is fitting the cell width jus

Re: $$Excel-Macros$$ Problem extracting data from multiple columns

Why cant i attach to this On Sep 5, 3:04 pm, "dguillett1" wrote: > Post a file > > > > -Original Message- > From: Andy McGooner > Sent: Monday, September 05, 2011 7:56 AM > To: MS EXCEL AND VBA MACROS > > Cc: amcni...@jaguarlandrover.com > Subject: $$Excel-Macros$$ Problemextractingd

Re: $$Excel-Macros$$ problem with cell width in a workbook

NO can do. Cell width for the entire column must be the same. You can merge cells but NO one suggests that so maybe format to WRAP and raise the height of the row From: Shankar Bheema Sent: Wednesday, September 07, 2011 11:33 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros

Re: $$Excel-Macros$$ problem with duplication of data

I tried with this code. But it is not stopping the entry of the duplicate row with the same file number. file numbers may be given consequently 1,2,3 ., if we enter file number 1 for twice, it would fire msgbox that it already exists. pls provide solution On Wed, Sep 7, 2011 at 8:03 PM, m

Re: $$Excel-Macros$$ problem with cell width in a workbook

good morning Noorain I tried with your example sheet. But it is fitting the cell width just like the Format-->Autofit option in the excel. But what I need is, the particular cells containing the red font has to be fit to their text width and the following column width may left as they are. sup

Re: $$Excel-Macros$$ problem with duplication of data

thank you so much saber On Wed, Sep 7, 2011 at 8:03 PM, mohd saber wrote: > Hi Shankar, > > Please find the below updated data for the command file > > Private Sub CommandButton1_Click() > ActiveWorkbook.Sheets("Employee Details").Activate > Range("A1").Select > Do > >If IsEmpty(ActiveCell)

Re: $$Excel-Macros$$ problem with duplication of data

Hi Shankar, Please find the below updated data for the command file Private Sub CommandButton1_Click() ActiveWorkbook.Sheets("Employee Details").Activate Range("A1").Select Do If IsEmpty(ActiveCell) = False Then If activecell.value = txtfileno.value Then ActiveCell.Offset(0, 1) = txtname.Te

Re: $$Excel-Macros$$ problem with cell width in a workbook

I am not getting even after selection as you said. I noticed non of the control is allowing to work on the sheet what would be the prblem with my excel ? On Wed, Sep 7, 2011 at 6:31 PM, NOORAIN ANSARI wrote: > Dear Bheema, > > First of all you select a range when you want to apply it... > it wor

Re: $$Excel-Macros$$ problem with cell width in a workbook

Dear Bheema, First of all you select a range when you want to apply it... it work after selection... you select red font area then press it.. Hope it will work fine.. On Wed, Sep 7, 2011 at 6:24 PM, Shankar Bheema wrote: > I downloaded your file but unable to cli

Re: $$Excel-Macros$$ problem with cell width in a workbook

I downloaded your file but unable to click on the command button as I placed my cursor on the command button it is turning into 4 headed arrow and clicking is not possible. what to do ? On Tue, Sep 6, 2011 at 11:02 PM, NOORAIN ANSARI wrote: > Dear Bheema, > > Please try it and see attached sheet

Re: $$Excel-Macros$$ problem with cell width in a workbook

Dear Bheema, Please try it and see attached sheet Sub Autofit() If TypeName(Selection) = "Range" Then Selection.Columns.Autofit End If End Sub Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ans

Re: $$Excel-Macros$$ problem with cell width in a workbook

ros@googlegroups.com Subject: Re: $$Excel-Macros$$ problem with cell width in a workbook sure guruji, pls have a look at my attachment and provide me solution. I marked the cell data with Redcolor. Those are to be adjusted to their width and remaining to their respective widths. Kindly provide solution.

Re: $$Excel-Macros$$ problem with cell width in a workbook

sure guruji, pls have a look at my attachment and provide me solution. I marked the cell data with Redcolor. Those are to be adjusted to their width and remaining to their respective widths. Kindly provide solution. On Tue, Sep 6, 2011 at 7:06 PM, NOORAIN ANSARI wrote: > Dear Bheema, > > pleas

Re: $$Excel-Macros$$ problem with cell width in a workbook

Dear Bheema, please share attachement with any rough example.. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Tue, Sep 6, 2011 at 6:56 PM, Bh

Re: $$Excel-Macros$$ Problem extracting data from multiple columns

Post a file -Original Message- From: Andy McGooner Sent: Monday, September 05, 2011 7:56 AM To: MS EXCEL AND VBA MACROS Cc: amcni...@jaguarlandrover.com Subject: $$Excel-Macros$$ Problem extracting data from multiple columns Hi All, I have a spreadsheet that can have up to 5 data colu

Re: $$Excel-Macros$$ Problem with counters

PLease post a sample file with clear requirement. On Wed, Jul 13, 2011 at 1:44 PM, Juan Antonio Castillo Guerrero < castill...@gmail.com> wrote: > Hello group! > > I'm doing an Excel spreadsheet in which I posed the following problem, I > put a sample of what I have and a sample of what you need

Re: $$Excel-Macros$$ Problem regarding rank formula

Hi Rajesh, Find my solution in Column-J of attached excel. Hope that helps. --- *Sixthsense **:) Man of Extreme & Innovative Thoughts :)* On Sat, May 14, 2011 at 8:49 PM, Rajesh K R wrote: > Hi experts, > pls check the attached file and solve my issue regarding ranking the > rooms according th

Re: $$Excel-Macros$$ problem in if else function

> *Sub if_Save()* > *If Sheet2.Range("M5") = "" or **Sheet2.Range("M6") = "" or ** > Sheet1.Range("P5:P9").count > < 5** **Then* > *msgbox ("Pleaes FullFill Entry " & Vbcrlf & "Name Shoud Be Enter " & > Vbcrlf & " Code Should be Correct" & Vbcrlf &" Value Should be lesser then > 5", vbinformati

RE: $$Excel-Macros$$ problem in if else function

Hi, Sub if_Save() If Sheet2.Range("M5") = "" Then MsgBox ("Please enter Name") ElseIf Sheet2.Range("M6") = "" Then MsgBox ("Please enter Code") ElseIf Sheet1.Range("P5:P9").count < 5 Then MsgBox ("Please fill all the details") Else Call Test End If End Sub Regards. Daniel De : e

Re: $$Excel-Macros$$ Problem in pivot table

Hi Ashish, Thanks for your help. Regards, Alisha On Sat, Apr 16, 2011 at 9:49 AM, ashish koul wrote: > its because its showing subtotals . hide them thats it . keep the cursor on > vgood right click and unselect subtotal ,same for good etc. > > > > > On Fri, Apr 15, 2011 at 11:32 PM, alisha ma

Re: $$Excel-Macros$$ Problem in pivot table

plz put up all poor, avg, good, very good in one column then create pivot table On Fri, Apr 15, 2011 at 11:32 PM, alisha malhotra < alisha.malhotr...@gmail.com> wrote: > Hi Ashish, > > I have made the pivot table using the layout as yours layout. But my pivot > is little bit complicated.Why is th

Re: $$Excel-Macros$$ Problem in pivot table

its because its showing subtotals . hide them thats it . keep the cursor on vgood right click and unselect subtotal ,same for good etc. On Fri, Apr 15, 2011 at 11:32 PM, alisha malhotra < alisha.malhotr...@gmail.com> wrote: > Hi Ashish, > > I have made the pivot table using the layout as yours

Re: $$Excel-Macros$$ Problem in pivot table

Hi Ashish, I have made the pivot table using the layout as yours layout. But my pivot is little bit complicated.Why is that so happening?. Why did you use employee code in data instead of count of poor or count of avg etc.? I am sending you the attachment. Regards, Alisha On Fri, Apr 15, 2011 at

Re: $$Excel-Macros$$ Problem in pivot table

Like this??? On Thu, Apr 14, 2011 at 9:29 PM, alisha malhotra < alisha.malhotr...@gmail.com> wrote: > Hi, > > I want to create one pivot table. In this, *I want to calculate the number > of employees in Poor, Avg, good, and very good.* > But it is showing the same no. of employees in each catego

Re: $$Excel-Macros$$ Problem in pivot table

see if it helps On Thu, Apr 14, 2011 at 9:29 PM, alisha malhotra < alisha.malhotr...@gmail.com> wrote: > Hi, > > I want to create one pivot table. In this, *I want to calculate the number > of employees in Poor, Avg, good, and very good.* > But it is showing the same no. of employees in each cat

Re: $$Excel-Macros$$ Problem on picking series in chart

I you hide the data columns , Excel Will not show those columns in the chart Excel Only shows the chart of visible columns and the filtered data On Sun, Feb 27, 2011 at 10:33 PM, Dilip Pandey wrote: > Hi Gaurav, > > I hv tried opening the attached file but it appears to be corrupted, > please

Re: $$Excel-Macros$$ Problem on picking series in chart

Hi Gaurav, I hv tried opening the attached file but it appears to be corrupted, please share the xls version of this file so that Group members can view the same. Best Regards, DILIPandey On 2/26/11, Gaurav Ahuja wrote: > Hi All, > > I am trying to construct chart with series selected from a ta

Re: $$Excel-Macros$$ Problem with Sorting in row wise

try this Sub Macro1() Dim i As Long For i = 1 To Sheets(1).Range("a1").End(xlDown).Row ActiveWorkbook.Worksheets("Sheet1").Sort.SortFields.Clear Worksheets("Sheet1").Sort.SortFields.Add Key:=Range("b" & i & ":i" & i), _ SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlS

Re: $$Excel-Macros$$ Problem in excel

Here you go with pivot..! On Sun, Jan 30, 2011 at 1:55 PM, Jitender kumar wrote: > Dear Sir > > I have problem with excel file.Please provide the solution.(See attachment) > > Regards > > Jitender > > -- > > -- > Some

  1   2   >