RE: $$Excel-Macros$$ Table - extract some data

Hi See if it helps, I have used name range with Range intersection , From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: Tuesday, August 16, 2011 8:08 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Table - extract some d

$$Excel-Macros$$ User Defined formula in Excel

Hi, Is there any way to defined a user defined formula in excel which will work like default functions e.g. Sum, Average etc. Suppose I want to insert a formula to solve the equation y=ax+b So I will just give the value of a, b and x so it will return the required value of Y and this function wi

Re: $$Excel-Macros$$ UDF Function for conditoin formetting

On 8/16/11, Excel VBASQL wrote: > I can do this email me at excelvba...@gmail.com > > On Tue, Aug 16, 2011 at 11:02 AM, ICWAI Help wrote: > >> Please provide me UDF functino for below requirement >> >> example:) >> >> if the cell value is 4 then including active cell next 4 cell in a row >> should

Re: $$Excel-Macros$$ What is done?

ok, got it, thnx On Wed, Aug 17, 2011 at 5:16 AM, XLS S wrote: > hey All, > > please look into the attachment and say how to use table function with array > (table is a function or what ?) > > cell F11 = {=TABLE(,E2)} what is this > > .

$$Excel-Macros$$ What is done?

hey All, please look into the attachment and say how to use table function with array (table is a function or what ?) cell F11 = {=TABLE(,E2)} what is this .. --

Re: $$Excel-Macros$$ UDF Function for conditoin formetting

Please find the attached file and give me the solution :) if the perticuler cell value is 4 then next 4 coloumn cells in same row shoudl be highleted . On Tue, Aug 16, 2011 at 11:42 PM, dguillett1 wrote: > I did this VERY recently in another formum. Was it you? > Right click sheet tab>view cod

Re: $$Excel-Macros$$ How to use Multiple criteria in DSUM function...

Hey Sharma, Please find the attachment On Tue, Aug 16, 2011 at 12:53 PM, B Sharma wrote: > Hello to Excel Experts and other users of this group. > > I've been looking everywhere   about how to put several criteria in > different cell ranges in: > > DSUM(database, field, criteria). > > I

Re: FW: $$Excel-Macros$$ Workbooks Consolidation Macro

hey Vikas, try to use batch file open notepad...paste below code then save as copy.bat Copy *Comman file name*.xls output.xls exit On Tue, Aug 16, 2011 at 5:25 PM, vikas gupta wrote: > > Dear Sir, > Sir I have a query that by using this macro fil

Re: $$Excel-Macros$$ AutoHide

Very good venkat.. On Tue, Aug 16, 2011 at 5:03 PM, Venkat CV wrote: > Hi Sajid, > > Look AttachedSee if it helps... > > Best Regards, > Venkat > Chennai > On Tue, Aug 16, 2011 at 4:03 PM, SAJID MEMON wrote: >> >> Hi all Experts, >> >> I have a little doubt but may be cha

Re: $$Excel-Macros$$ re: required phone book in excel

Hey Harsh, Please find the below link http://office.microsoft.com/en-us/templates/CT010144671.aspx On Tue, Aug 16, 2011 at 1:37 PM, harsh shah wrote: > dear all, > > anybody having phone book software in excel ?? > i.e. name contact details phone numbers up to 3 or 4 numbers > and important

Re: $$Excel-Macros$$ UDF Function for conditoin formetting

I did this VERY recently in another formum. Was it you? Right click sheet tab>view code>insert this Private Sub Worksheet_Change(ByVal Target As Range) Dim tr As Long tr = Target.Row Rows(tr).Borders(xlEdgeBottom).LineStyle = xlNone If Target.Column <> 1 Or Not IsNumeric(Target) Or _ Len(Applicati

Re: $$Excel-Macros$$ UDF Function for conditoin formetting

I can do this email me at excelvba...@gmail.com On Tue, Aug 16, 2011 at 11:02 AM, ICWAI Help wrote: > Please provide me UDF functino for below requirement > > example:) > > if the cell value is 4 then including active cell next 4 cell in a row > should be higleted with color. > ex > if > a1 is 4

$$Excel-Macros$$ UDF Function for conditoin formetting

Please provide me UDF functino for below requirement example:) if the cell value is 4 then including active cell next 4 cell in a row should be higleted with color. ex if a1 is 4 then a1 ,b1 ,c 1, d 1, f 1 should be higleted. Thansk, Rakesh. -- -

Re: $$Excel-Macros$$ Table - extract some data

I would restructure your table to make it simpler but this works. From: x x Sent: Tuesday, August 16, 2011 7:31 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Table - extract some data Folks, please give me a hint about table attached. I'd like to find a way to extract exact an

$$Excel-Macros$$ Table - extract some data

Folks, please give me a hint about table attached. I'd like to find a way to extract exact and wished value from table but of course regarding pre-existing required conditions. For instance, if someone choose diameter 40, left diameter 10 and delta 60 excel should get in some empty cell the val

Re: $$Excel-Macros$$ Update Data source range & converting "0" to "-"

I can do this email me at excelvba...@gmail.com On Tue, Aug 16, 2011 at 6:00 AM, Amit Desai (MERU) wrote: > Dear All, > > ** ** > > Still waiting a solution for below issue… > > ** ** > > I have created several pivot tables & want to update the data source > range for all the pivot table

Re: FW: $$Excel-Macros$$ Workbooks Consolidation Macro

I can help email me at excelvba...@gmail.com On Tue, Aug 16, 2011 at 6:55 AM, vikas gupta wrote: > > Dear Sir, > Sir I have a query that by using this macro file I am able to merge > different files into single excel but after merging the data is not under > single column heading, Pls. suggest h

$$Excel-Macros$$ Fwd: Job

- Original message From:""Ma Foi Management Consultants Ltd.""< paramita.b...@mafoirandstad.com> Date: 16 Aug 11 17:41:48 Subject: WFM-opening at kolkata To: For Internal Use of Employer (Please don't delete or modify while replying to this email)Monster Resume ID: 33564079 P

Re: Fwd: FW: $$Excel-Macros$$ Workbooks Consolidation Macro

Your source files should all be structured the same. If not, you will have to program. Attach samples From: vikas gupta Sent: Tuesday, August 16, 2011 6:55 AM To: excel-macros@googlegroups.com Cc: pankaj chawla ; tech_pankajcha...@rediffmail.com Subject: Fwd: FW: $$Excel-Macros$$ Workbooks C

Re: $$Excel-Macros$$ AutoHide

Name your shape “LockShape” and use this assigned to a button or another shape Sub HideUnhideLockShape() Shapes("LockShape").Visible = Not _ Shapes("LockShape").Visible End Sub From: SAJID MEMON Sent: Tuesday, August 16, 2011 5:33 AM To: Excel Group Subject: $$Excel-Macros$$ AutoHide Hi all E

Fwd: FW: $$Excel-Macros$$ Workbooks Consolidation Macro

Dear Sir, Sir I have a query that by using this macro file I am able to merge different files into single excel but after merging the data is not under single column heading, Pls. suggest how can I merge files having similar column headers in all files, so that I can easily sort data as per my requ

$$Excel-Macros$$ Fwd: Job

- Original message From:""Crome Search""< shailend...@cromesearch.com > Date: 16 Aug 11 17:04:36 Subject: Urgent Opening with Visteon ( MNC ) for Chennai Location To: For Internal Use of Employer (Please don't delete or modify while replying to this email)Monster Resume ID: 335640

RE: $$Excel-Macros$$ Update Data source range & converting "0" to "-"

Dear All, Still waiting a solution for below issue... I have created several pivot tables & want to update the data source range for all the pivot tables all together. (We do have option as refresh all for applying the preset pivot criteria in all pivots.) Best Regards, Amit Desai Assistant Mana

$$Excel-Macros$$ AutoHide

Hi all Experts, I have a little doubt but may be challanging. I have enclosed my file. plz refer this and give me solution. awaiting your reply yours sajid memon -- -- Som

RE: $$Excel-Macros$$ From Word to Excel

Can you please send the word document which provoked the error (the one which is opened) ? apparently, there are some merged cells in it. Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Shrinivas Shevde Envoyé : mardi 16 août 2011

Re: $$Excel-Macros$$ From Word to Excel

Dear Daniel Very very thanks for kind help There is some problem at following line For j = 3 To myTable.Columns(i).Cells.Count Run Time ERROR 5992 Can not access indivsual columns in this collection because the table has mixed cell width Please Help Shrinivas On Sat, Aug 13, 2011 at 4:10 PM, D

Re: $$Excel-Macros$$ How to use Multiple criteria in DSUM function...

*Hi Sharma,* * * *See if Helps* * * *http://www.mrexcel.com/forum/showthread.php?t=58539* On Tue, Aug 16, 2011 at 12:53 PM, B Sharma wrote: > Hello to Excel Experts and other users of this group. > > I've been looking everywhere about ho

Re: $$Excel-Macros$$ Notes : Help

hi chandar i tried it its working fine also ur code is password protected .can u unlock it and send it again On Tue, Aug 16, 2011 at 12:43 PM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hi Ashish, > > Please find attached file and kindly do the needful. Thanks in advance. > > On T

Re: $$Excel-Macros$$ Export of Personal Macro Book

Welcome On Tue, Aug 16, 2011 at 11:55 AM, Amit Desai (MERU) wrote: > This one helped thanks… > > ** ** > > Best Regards, > > Amit Desai > > ** ** > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Venkat CV > *Sent:* Tues

$$Excel-Macros$$ How to use Multiple criteria in DSUM function...

Hello to Excel Experts and other users of this group. I've been looking everywhere about how to put several criteria in different cell ranges in: DSUM(database, field, criteria). I have a very large database and using Dsum and I am using different different criteria in different different col

Re: $$Excel-Macros$$ Rajan Verma : Most Helpful Member - July'11

Congrats to my lovely friend.. Hey Rajan... carry on your social work dude. On Aug 5, 11:08 pm, Manish wrote: > CongratulationsRajan... :) > > - > Manish > > On Aug 5, 9:37 pm, neil johnson wrote: > > > > > > > > > CongratulationRajan. > > > On Fri, Aug 5, 2011 at 8:57 AM, Haseeb