$$Excel-Macros$$ Re: Advanced Filter

Brilliant Haseeb, Thanks. Could you please explain. How it works??? Akhilesh -- FORUM RULES (925+ 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

Re: $$Excel-Macros$$ Time between " "

Cells(I, 15).Value = "hour=" & & Format(Hour(Cells(I, 6).Value),"00") &":" & Format(Minute(Cells(I,6)), "00") & Regards Sam On Fri, Oct 28, 2011 at 6:20 AM, Eduardo Cereja wrote: > Dear Paul, thanks a lot for the expalnation. Really good. > But using the code that you wrote the result

Re: $$Excel-Macros$$ access query to run into excel

Dear Sara, Please try through below link http://quickvba.blogspot.com/2008/04/query-access-from-excel.html http://www.excelvbamacros.com/p/access.html On Fri, Oct 28, 2011 at 4:46 AM, Sara Lee wrote: > hey > > is there a macro to run access query inside excel 2007. and excel data > should refr

Re: $$Excel-Macros$$ Auto Reference

Also, Another one to avoid OFFSET volatile, In E2 & copy down. =MAX(B2:INDEX(2:2,MATCH("z",$1:$1)-1)) HTH Haseeb -- FORUM RULES (925+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem

$$Excel-Macros$$ Re: Find last number in a column with numbers

Hello Ken; Also, =MATCH(9E300,$B:$B) will give the last row number contains number. so you can define name range with this as length See the attached. Same data as Sam posted. HTH Haseeb -- FORUM RULES (925+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor t

Re: $$Excel-Macros$$ Find last number in a column with numbers

Hello Ken; Also, =MATCH(9E300,A:A) will give the last row number contains number. so you can define name range with this as length See the attached. Same data as Sam posted. HTH Haseeb -- FORUM RULES (925+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor th

$$Excel-Macros$$ Re: Advanced Filter

Hello Akhiles, Use Advanced Filter. In Sheet2, insert 3 blank rows above the heading, then use this formula in A2 =ISNA(MATCH($A5,Sheet1!$A:$A,0)) Then select Sheet2 data, use Advanced Filter. In Advanced Filter, Select Copy to another location List Range: Select Sheet2 data. Criteria Range

Re: $$Excel-Macros$$ Time between " "

Dear Paul, thanks a lot for the expalnation. Really good. But using the code that you wrote the result is: hour="9" and not equal hour="09:06" I tried this way: Cells(I, 15).Value = "hour=" & & Hour(Cells(I, 6).Value) &":" &Minute(Cells(I,6))& but results in: hour="9:6" inspite of h

$$Excel-Macros$$ access query to run into excel

hey is there a macro to run access query inside excel 2007. and excel data should refresh with any change in access query data. -- FORUM RULES (925+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Pr

Re: $$Excel-Macros$$ Find last number in a column with numbers

Here's how you create the named range =OFFSET(Sheet1!$B$1,1,,MAX((LEN(TRIM(Sheet1!$B$1:$B$200))>0)*(ROW(Sheet1!$B$1:$B$200)))-1,1) Check the attachment Regards, Sam Mathai Chacko (GL) On Fri, Oct 28, 2011 at 12:46 AM, dguillett1 wrote: > > Attach your file with a copy of this msg > > > Don G

$$Excel-Macros$$ Re: To send mail from excel.

Attachment... On Thu, Oct 27, 2011 at 11:34 PM, kurikkal padinjarappalla < padinjarappa...@gmail.com> wrote: > > Hi group, > > Hope somebody can help me out by modifying the macro of below attached > sheet which Mr. Ashish had posted earlier to send mails from excel: > > My requir

$$Excel-Macros$$ To send mail from excel.

Hi group, Hope somebody can help me out by modifying the macro of below attached sheet which Mr. Ashish had posted earlier to send mails from excel: My requirement is that the body column should be copied to the mail without changing its cell format like below, Hi Ashish, how r u And is it

$$Excel-Macros$$ Want to learn Match and Offset - formulas

Hi All, Can anyone tell me the simplified / easiest way to learn Index, Match and Offset - formulas or arrays, with some example. Thanks in advance. -- Indrajit Snai talk2indra...@gmail.com Disclaimer: This electronic message and any files transmitted with it are confidential and intended sole

Re: $$Excel-Macros$$ Require some free MIS template.....

Thanks Noorain. On Thu, Oct 27, 2011 at 8:22 AM, NOORAIN ANSARI wrote: > Dear Indrajit, > > Please find attached Template,Hope it will be help to u. > > -- > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/* > *http://noorain-ansar

Re: $$Excel-Macros$$ Find last number in a column with numbers

Attach your file with a copy of this msg Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: Ken Sent: Thursday, October 27, 2011 1:54 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Find last number in a column with numbers I have two columns of num

Re: $$Excel-Macros$$ Auto Reference

Put this in a REGULAR module and then use =don(1) Function don(r As Long) Application.Volatile lc = Cells(r, Columns.Count).End(xlToLeft).Column don = Cells(Rows.Count, lc).End(xlUp) End Function Don Guillett SalesAid Software dguille...@gmail.com From: Paul Schreiner Sent: Thursday, October 27

$$Excel-Macros$$ Find last number in a column with numbers

I have two columns of numbers. Column A is sequential dates. Column B is data gathered from time to time and entered in the appropriate date row as related to Column A. Column B has lots of blank rows without data. Reason: I do not gather data each day. All the rows below the last entry in Co

Re: $$Excel-Macros$$ Lookup

Public Function MultiResultLookedUp(varLookupValue, rngRange As Range) As String Dim lngLoop As Long Dim varArray varArray = rngRange For lngLoop = LBound(varArray, 1) To UBound(varArray, 1) If varArray(lngLoop, 1) = varLookupValue Then If InStr(1, "/" & MultiResultLookedUp & "/", "/" & varAr

Re: $$Excel-Macros$$ Urgent help needed

Did you try my solution?? Don Guillett SalesAid Software dguille...@gmail.com From: Anil Bhange Sent: Thursday, October 27, 2011 11:49 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Urgent help needed Hi Noorain, Thanks for the help, but it is not working at my end due

$$Excel-Macros$$ Lookup

Dear All, Below mentioned Macro provided by SAM, but I am facing trouble please see the attached file & provide the further enhancement in this macro. Your cooperate will highly appreciate.

Re: $$Excel-Macros$$ Urgent help needed

Thanks Sam , Paul and Don, I totally agree with you guys but it is not possible to moderate each message. As an immediate action, I have modified the message footer to add forum rules. Now every message will carry below text at bottom. I hope this helps. Let me know if it is helpful or any other

Re: $$Excel-Macros$$ Download Word Macro Tutorial

2011/10/24 NOORAIN ANSARI > Dear Pankaj, > > PFA > > On Mon, Oct 24, 2011 at 6:01 AM, pankaj gmail account < > pankaji...@gmail.com> wrote: > >> This link is also not working. >> >> Pankaj >> >> On Sun, Oct 23, 2011 at 8:01 PM, ashish koul wrote: >> >>> http://www.susandoreydesigns.com/softwa

RE: $$Excel-Macros$$ Urgent help needed... (apologies)

Thanks guys... For suggesting the same... will take care next time Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sam Mathai Chacko Sent: Thursday, October 27, 2011 08:45 PM To: excel-macro

RE: $$Excel-Macros$$ Urgent help needed

Hi Noorain, Thanks for the help, but it is not working at my end due to different sheet name (I believe), can we make it flexible (as it need to run in any worksheet). Also i need my output as like below.. I am ok to repeat the heading of data And one more thing can macro ask me the range which

Re: $$Excel-Macros$$ calculate multiple value in one cell

Thanks SAM. On Thu, Oct 27, 2011 at 9:49 PM, Sam Mathai Chacko wrote: > Bravo Noorain > > Rgds, > Sam > > > On Thu, Oct 27, 2011 at 1:23 PM, NOORAIN ANSARI > wrote: > >> Dear Anjul, >> >> Please see attached sheet, hope it will help to u... >> >> >> Step 1 Select Cell B1 2 Formula-Define Name-Re

Re: $$Excel-Macros$$ calculate multiple value in one cell

And here's the VBA version Function EVALUATER(rngCell As Range) EVALUATER = Application.EVALUATE("=" & rngCell.Value) End Function Regards, Sam Mathai Chacko (GL) On Thu, Oct 27, 2011 at 9:49 PM, Sam Mathai Chacko wrote: > Bravo Noorain > > Rgds, > Sam > > > On Thu, Oct 27, 2011 at 1:23

Re: $$Excel-Macros$$ calculate multiple value in one cell

Bravo Noorain Rgds, Sam On Thu, Oct 27, 2011 at 1:23 PM, NOORAIN ANSARI wrote: > Dear Anjul, > > Please see attached sheet, hope it will help to u... > > > Step 1 Select Cell B1 2 Formula-Define Name-Refers > to-type-=Evaluate($A2) 3 Give Name Range 4 Use Name Range in B1 Cell to > Output >

Re: $$Excel-Macros$$ Auto Reference

You could use named ranges, but what I've done in the past is to search the column headings for the heading for the "Max" column and set that column number in a variable to use in the formula. The issue you have there is that someone could choose to rename the column. But you have nearly the same

RE: $$Excel-Macros$$ Auto Reference

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Deepak Rawat Sent: Friday, January 21, 2011 7:02 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Auto Reference My problem is, I want max amount in the last column but whenever i inse

Re: $$Excel-Macros$$ Internet Explorer

Use this instead. You don't have to add the library in this case. Sub FillInternetForm() Dim objIE As Object Dim theForm As Object Set objIE = CreateObject("InternetExplorer.Application") objIE.Navigate "http://www.oanda.com/currency/converter/"; objIE.Visible = True Do

Re: $$Excel-Macros$$ Urgent help needed

Seconding Don and Paul on that. Another point that comes to the table is the lack of proper Subject Titles that clearly and concisely describes the problem/objective. I know that this is hinted in the forum rules, but do we not need to moderate this? Regards, Sam On Thu, Oct 27, 2011 at 7:39 PM,

Re: $$Excel-Macros$$ Internet Explorer

Dear Airen, Please add Microsoft HTML Liberary then run your code. Press Alt+F11 Tools-References-Check Microsoft HTML Liberary then press F5 Coding is correct On Thu, Oct 27, 2011 at 8:14 PM, airen wrote: > Hi Experts, > Please help me with this code > > Sub FillInternetForm() > Dim objI

$$Excel-Macros$$ Internet Explorer

Hi Experts, Please help me with this code Sub FillInternetForm() Dim objIE As Object Dim theForm As HTMLFormElement Set objIE = CreateObject("InternetExplorer.Application") objIE.Navigate "http://www.oanda.com/currency/converter/"; objIE.Visible = True Do While objIE.busy

Re: $$Excel-Macros$$ Urgent help needed

I agree with Don. The first thing I do is delete all requests that do not describe the problem in the subject line. Posting Tips: Subjects like "Urgent Help Needed" convey no valueable information. the problem isn't urgent for ME, and if the poster didn't need help, he/she wouldn't be posting.

Re: $$Excel-Macros$$ Time between " "

First of all, you need to understand that to Excel, "time" is simply a fraction of a day. So, 9:00am is really 9/24 of a day, or .375 9:06:24 is 0.379 of a day... when you SEE the cell as a time:  9:06 AM, it is a display format. You're DISPLAYING the number as a time. you could en

Re: $$Excel-Macros$$ Urgent help needed

Anil, Please do NOT use urgent in your request as most who would help may even put that request last on their list or ignore the request. Try this code, assuming Master Sheet does NOT exist. === Option Explicit Sub ConsodilateSheetsSAS() Dim dlr As Long Dim i As Long Application.ScreenUpdati

$$Excel-Macros$$ Time between " "

Hi, I´m using the code below. Cells(i,6) has hour data, 09:06 for example. I need to transfer this value to another cell , but between "09:06". The code below result in: hour="0,4048611" however i want hour="09:06" Coud anyone help me with this simple problem? Best regards Sub xml() Set

Re: $$Excel-Macros$$ Advanced Filter

try consolidate pivot table option.. http://tipsindeed.com/excel/data-consolidation-in-excel-made-easy-using-pivot-tables.html On Thu, Oct 27, 2011 at 4:40 PM, airen wrote: > > > Hi Noorain, > Thanks for your reply. Provided solution wont work, I dont want empty > rows in between. Is there any

Re: $$Excel-Macros$$ Advanced Filter

Hi Noorain, Thanks for your reply. Provided solution wont work, I dont want empty rows in between. Is there any VBA code?? Thanks -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks a

Re: $$Excel-Macros$$ Advanced Filter

Dear Airen, Please see attached sheet, hope it help to u. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Thu, Oct 27, 2011 at 1:47 PM, airen wrote:

$$Excel-Macros$$ Advanced Filter

Hi Experts, I have some records in "sheet 1" and some in "sheet 2". Now I want all those records which are in "sheet 2" but not in "sheet 1" and result to be saved in "sheet 2" Thanks Akhilesh Airen -- -- Some import

$$Excel-Macros$$ Advanced Filter

Hi Experts, I have some records in "sheet 1" and some in "sheet 2". Now I want all those records which are in "sheet 2" but not in "sheet 1" and result to be saved in "sheet 2" Thanks Akhilesh Airen -- -- Some import

Re: $$Excel-Macros$$ calculate multiple value in one cell

Dear Anjul, Please see attached sheet, hope it will help to u... Step 1 Select Cell B1 2 Formula-Define Name-Refers to-type-=Evaluate($A2) 3 Give Name Range 4 Use Name Range in B1 Cell to Output -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*

$$Excel-Macros$$ calculate multiple value in one cell

Hi, I have multiple value in one cell for example. *A1* 1*7+5 12*57+54 12+854 14+47*1 I want result below type by formula & VBA. *B1* 12 738 866 61 Regards, Anjul -- -- Some important links for excel users: 1. Foll