Re: $$Excel-Macros$$ help regarding date formula

*ok sir *Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Thu, Jul 7, 2011 at 11:44 AM, L.K. Modi wrote: > THANKS A LOT MY PROBLEM IS SOLVED NOW BY THESE VALUABLE MEMBERS > > > REGARDS > LKMODI > > On Thu, Jul 7, 2011

$$Excel-Macros$$ Help on Chart

Hello Team, I am preparing chart basis certain data. However wanted to check some way to prepare the chart only on the data which reflect in the excel sheet post i do a filter. So as soon as I change the filter the chart should change. Do let me know if that can be done. Cheers Atul -- ---

Re: $$Excel-Macros$$ help regarding date formula

THANKS A LOT MY PROBLEM IS SOLVED NOW BY THESE VALUABLE MEMBERS REGARDS LKMODI On Thu, Jul 7, 2011 at 10:25 AM, L.K. Modi wrote: > Dear Members, > > Me attaching a sheet which relates to Excise duty payment.The result should > be 5 of the next of the month of Invoice.We are currently doing it

Re: $$Excel-Macros$$ Converting Text Case By VBA

*dear friends plz check the attached file for changing the text case of selected range *Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Thu, Jul 7, 2011 at 10:23 AM, anandydr wrote: > Dear STDEV(i), > > As you say te

Re: $$Excel-Macros$$ Maill Merge in Two Excel Sheet

*HI VASANT thanks a lot code is working fine in my main data file... this is what i needed u had saved my time and efforts.. thnks again *Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Thu, Jul 7, 2011 at 12:42

Re: $$Excel-Macros$$ Re: Query

* *Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Wed, Jul 6, 2011 at 6:05 PM, ankur wrote: > *hi ashish sir > may this help u ... > *Have A Nice Time & Enjoy Life > > Regards: > CMA Ankur Pandey > (Someone Different

Re: $$Excel-Macros$$ Need formula for Current Date Access

* my pleasure *Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Wed, Jul 6, 2011 at 7:04 PM, Idhrees Mohamed wrote: > Dear Ankur, > > Its working fine. Thank you very much. > > Regards, > Idhrees. > > On Tue, Jul 5, 201

Re: $$Excel-Macros$$ help regarding date formula

* hi L K modi use this formula in d4 =EOMONTH(C4,0)+5 *Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Thu, Jul 7, 2011 at 11:29 AM, Rajan_Verma wrote: > *Use this in D4* > > *=DATE(YEAR(C4),MONTH(C4)+1,5)* > > * * >

RE: $$Excel-Macros$$ help regarding date formula

Use this in D4 =DATE(YEAR(C4),MONTH(C4)+1,5) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of L.K. Modi Sent: Thursday, July 07, 2011 10:26 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ help regarding date formula Dear Members, Me

Re: $$Excel-Macros$$ help regarding date formula

use this=DATE(YEAR(C4),MONTH(C4),5) On Thu, Jul 7, 2011 at 10:25 AM, L.K. Modi wrote: > Dear Members, > > Me attaching a sheet which relates to Excise duty payment.The result should > be 5 of the next of the month of Invoice.We are currently doing it > manually. But is there any formula b

RE: $$Excel-Macros$$ Query

You can use Vlookup formula as shown in attachment. Regards, Modh From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kal xcel Sent: Wednesday, July 06, 2011 4:56 PM To: excel-macros@googlegroups.com Cc: Dave Bonallack; NOORAIN ANSARI; Ashish Koul Subject: $$

$$Excel-Macros$$ help regarding date formula

Dear Members, Me attaching a sheet which relates to Excise duty payment.The result should be 5 of the next of the month of Invoice.We are currently doing it manually. But is there any formula by which we can do that fast and in less time. Hope you wil surely help me. Regards LKModi --

Re: $$Excel-Macros$$ Converting Text Case By VBA

Dear STDEV(i), As you say text case can be converted to Proper Case using VBA but wont be using Application.Function/Worksheet Function give faster results as compared to this other method? Warm regards, Anand Kumar On Jul 7, 6:02 am, "STDEV(i)" wrote: > Converting text case to ProperCase in VB

Re: $$Excel-Macros$$ Query

=*LOOKUP* (D16,{3001,5001,6001,7001,8001,9001,15001,25001,40001},{30,40,45,50,60,110,130,150,200}) or.. =*VLOOKUP*(D16,$A$1:$B$9,2,TRUE) the above VLookUp fungtion refers to a table *tabel A1:B9* * 3001 30 * * 5001 40 * * 6001 45 * * 7001 50* * 8001 60* * 9001 110* *15001 130* *2500

Re: $$Excel-Macros$$ and the Microsoft MVP award goes to Ashish Koul :)

OH Ashish, I havent gone throuh the mail. btw congrats buddy :) Thanks On Mon, Jul 4, 2011 at 10:07 PM, seraj alam wrote: > Hi Ashish, > > Many many congrats... > > > With best wishesh, > Seraj Alam > > > > > On Mon, Jul 4, 2011 at 9:40 PM, Hari wrote: > >> Thanks for getting the award. Even

Re: $$Excel-Macros$$ Converting Text Case By VBA

Converting text case to ProperCase in VBA alt: Instead of using Application.Function / WorksheetFunction) we can also use VBA function: *StrConv *function StrConv(" ", vbProperCase) Example in sub procedur Sub ConvertProperCase() Application.ScreenUpdating = False Dim Cell As

RE: $$Excel-Macros$$ Convert HTML file to Excel

See if it Help. Sub Compile() On Error GoTo Err_Clear: Application.ScreenUpdating = False Application.DisplayAlerts = False Dim Fso As New Scripting.FileSystemObject Dim Path As String Application.FileDialog(msoFileDialogFolderPicker).Title = "Select Folder to Pick Downloaded Bills" Application.

RE: $$Excel-Macros$$ Vlookup Query-2

See if it help From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Jai Sent: Wednesday, July 06, 2011 4:37 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Vlookup Query-2 Hello Experts I Have a one Qurery Please Check the attachment

RE: $$Excel-Macros$$ Vlookup Regarding Query Please Help

"*" Character will find the value which start with Following Characters. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ankur Sent: Wednesday, July 06, 2011 4:07 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Vlookup Regarding Query P

RE: $$Excel-Macros$$

Try this Sub PrintPerpage() Dim rng As Range Dim cell As Range Set rng = Sheets("OD_New").Range("N5:N23") For Each cell In rng Range("G4").Value = cell.Value Range("G5").Value = cell.Offset(0, 1).Value ActiveWindow.SelectedSheets.PrintOut Copies:=1

RE: $$Excel-Macros$$ Two lookup value with sumproduct.

Hi See if it help. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ICWAI Help Sent: Tuesday, July 05, 2011 7:54 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Two lookup value with sumproduct. Hello Ashsih, COULD YOU PLEASE EXPLAI

RE: $$Excel-Macros$$ Help for Excel query

Use =max(A1:C1) in D1 -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of satish Sent: Wednesday, July 06, 2011 2:32 AM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Help for Excel query Hi, I want to compare Colum A , B anc

RE: $$Excel-Macros$$ marco to find common value

Try this =IF(ISERROR(VLOOKUP(B2,A:A,1,0)),"Common","Double") From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of HARI NAIR Sent: Wednesday, July 06, 2011 10:49 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ marco to find common value I

RE: $$Excel-Macros$$ select row which have specified data

Please see the attached File. Sub pasteData() Dim rng As Range Dim cell As Range Set rng = Sheets("Sheet1").Range("A3:A" & Sheets("Sheet1").UsedRange.Rows.Count) For Each cell In rng If cell.Value = ActiveSheet.Range("B1").Value Then ActiveSheet.Range("C2:C11").Copy Sheets("Sheet

Re: $$Excel-Macros$$ Convert HTML file to Excel

Hi Pls find the code and the file attached. The html files stored in the folder 'Folder' will be used for the report. Sub Test() Dim Fs As New FileSystemObject, Fl As File Dim Fld As Folder, FolderPath As String Dim WkBk As Workbook, DtWkBk As Workbook Set WkBk = Workbooks.Add NoShts = WkBk.Works

$$Excel-Macros$$ Printing Word and Excel documents via VBA

Hi there i have 2 questions Firstly how do i attach a file to these posts? i cant see anywhere to show people my problem? Secondly: i have a word document which needs excel pages putting in it - i need a macro to: print page 1 of c:\xx\document1.doc print page1 of sheet1 of c:\yy\excelwkbk1.xls

Re: $$Excel-Macros$$ Need formula for Current Date Access

Dear Ankur, Its working fine. Thank you very much. Regards, Idhrees. On Tue, Jul 5, 2011 at 3:46 PM, ankur wrote: > *You can create a form, by using the IIF function in Control Source > property...Of the field which required > > =IIf([Valid date]=Date(),"valid","expired") > > one sample fil

Re: $$Excel-Macros$$ marco to find common value

I want common numbers of both column should shown in column C while clicking a button. I have used the following formula, but it take very long time to process each time I opened the file. Thanks =INDEX($A$2:$A$1642,SMALL(IF(COUNTIF($B$2:$B$1642,$A$2:$A$1642),ROW($A$2:$A$1642)-MIN(ROW($A$2:$A$

$$Excel-Macros$$ Fwd: Openings for VBA dev in Gurgaon

Hi Group, Pls find a job opening for VBA in Gurgaon. *Dear Vasant, *Hi, Trust you are doing good. This is Harmeet here from DynPro India Pvt. Ltd. About DynPro India Pvt. Ltd.: Established in 1996, DynPro Inc was formed by a management team with unrivalled experience in IT recruitment, E-Co

Re: $$Excel-Macros$$ Maill Merge in Two Excel Sheet

The macro is functioning as per my expectation. Please set the calculation to automatic in your workbook if you hv not done so. R u getting any error. If so what is the error. Goto into the debug mode and check if the values in empcode is changing. On Wed, Jul 6, 2011 at 5:16 PM, ankur wrote:

Re: $$Excel-Macros$$ Sum based on conditional formatting

Hi L K Modi, your query is not clear. Please elaborate. Kalyan On Wed, Jul 6, 2011 at 5:06 PM, ankur wrote: > *HI LK MODI > USED SUM BASED ON "COLOUR OF CELL" , MAY THIS HELP YOU > USE THIS UDF, U CAN SEE THE CODE IN MODULE > > > =ColorFunction($B$30,$B$2:$B$27,TRUE) > WHERE B30 CELL IS HAVIN

$$Excel-Macros$$ Query

Dear Experts, For this chart 3001-5000 = 30 5001-6000 = 40 6001-7000 = 45 7001-8000 = 50 8001-9000 = 50 9001-15000 = 110 15001-25000 = 130 25001-4 = 150 40001>= =200 I use this formula: =IF(AND(D16>=3001,D16<=5000),30,IF(AND(D16>=5001,D16<=6000),40,IF(AND(D16>=6001,D16<=7000),45,IF

Re: $$Excel-Macros$$ Sum based on conditional formatting

use conditional format with formula =indirect("B" & row())<>"" pls find file attached. cells containg amounts out of those some > cells are coloured. > > Is there any way to coloured only those coloured cells. One way i have by > filter on the basis of colour but everytime to use that is hectic s

Re: $$Excel-Macros$$ Vlookup Query-2

Dear Jai, Please find solution of 2nd Query... =VLOOKUP("*"&C6&"*",Sheet1!B4:C10,2,0) See attached sheet. -- Thanks & regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* On Wed, Jul 6, 2011 at 4:37 PM, Jai wrote: > Hello Experts > > I Have a on

Re: $$Excel-Macros$$ Re: Query

*hi ashish sir may this help u ... *Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Wed, Jul 6, 2011 at 5:30 PM, ashish koul wrote: > > > On Wed, Jul 6, 2011 at 4:56 PM, Kal xcel wrote: > >> Dear Experts, >> >> For t

$$Excel-Macros$$ Re: Query

On Wed, Jul 6, 2011 at 4:56 PM, Kal xcel wrote: > Dear Experts, > > For this chart > > 3001-5000 = 30 > 5001-6000 = 40 > 6001-7000 = 45 > 7001-8000 = 50 > 8001-9000 = 50 > 9001-15000 = 110 > 15001-25000 = 130 > 25001-4 = 150 > 40001>= =200 > > I use this formula: > > > > =IF(AND(D16>=

RE: $$Excel-Macros$$ Vlookup Query-2

Hello, Can you explain a bit more ? Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Jai Envoyé : mercredi 6 juillet 2011 13:07 À : excel-macros@googlegroups.com Objet : $$Excel-Macros$$ Vlookup Query-2 Hello Experts I

Re: $$Excel-Macros$$ Sum based on conditional formatting

http://akoul.blogspot.com/search/label/Function%20To%20Sum%20cells%20on%20the%20basis%20of%20font%20color http://akoul.blogspot.com/search/label/Function%20To%20Count%20cells%20on%20the%20basis%20of%20font%20color On Wed, Jul 6, 2011 at 5:06 PM, ankur wrote: > *HI LK MODI > USED SUM BASED ON

Re: $$Excel-Macros$$ Maill Merge in Two Excel Sheet

*HI VASANT THNKS FOR UR EFFORTS EmpCode = ThisWorkbook.Worksheets("Sheet2").Cells(x, 1)..this code is not working U R GETTING IN RIGHT DIRECTION, NOW I NEED... THE STAFF NO OF NEXT EMPLOYEE GET CHANGED AND THE RESULT GET PASTED IN SHEET2MEANS AUTO CHANGING OF DATA VALIDATION HAPPEN

Re: $$Excel-Macros$$ Sum based on conditional formatting

*HI LK MODI USED SUM BASED ON "COLOUR OF CELL" , MAY THIS HELP YOU USE THIS UDF, U CAN SEE THE CODE IN MODULE =ColorFunction($B$30,$B$2:$B$27,TRUE) WHERE B30 CELL IS HAVING COLOUR OF THE CONDITIONAL FORMATING FILE IS ATTACHED FOR UR REFERENCE *Have A Nice Time & Enjoy Life Regards: CMA Ankur P

$$Excel-Macros$$ Vlookup Query-2

Hello Experts I Have a one Qurery Please Check the attachment -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN gro

Re: $$Excel-Macros$$ Vlookup Regarding Query Please Help

THIS Realy Good Formula Thaks On Wed, Jul 6, 2011 at 3:49 PM, NOORAIN ANSARI wrote: > Dear Jai, > > Please try it without helping column.. > > =VLOOKUP(B7&"*",Sheet1!B7:C12,2,) > > > Thanks & regards, > Noorain Ansari > *http://noorain-ansari.blogspot.com/* >

Re: $$Excel-Macros$$ Vlookup Regarding Query Please Help

It's great...!!! *--- кαяαηη* On Wed, Jul 6, 2011 at 3:49 PM, NOORAIN ANSARI wrote: > Dear Jai, > > Please try it without helping column.. > > =VLOOKUP(B7&"*",Sheet1!B7:C12,2,) > > > Thanks & regards, > Noorain Ansari > *http://noorain-ansari.blogspot.com/*

Re: $$Excel-Macros$$ Vlookup Regarding Query Please Help

Very intelligent solution by Noorain.. Jai, I am giving another solution =VLOOKUP(IF(FIND(B17,Sheet1!B5,1),"*"&B17&"*",0),Sheet1!$B$5:$C$10,2,0) Try this, it will search "RAM" or "ROH" in total string and show result. "RAM or "ROH" could be anywhere in the string. On Wed, Jul 6, 201

Re: $$Excel-Macros$$ Vlookup Regarding Query Please Help

Thanks of Lot Sir On Wed, Jul 6, 2011 at 3:42 PM, ankur wrote: > *hi jai > find the attached filethis has slight modification of venkatesan > solution...the repeat of name is taken care , as u required tell me it > helps? > *Have A Nice Time & Enjoy Life > > Regards: > CMA Ankur Pa

$$Excel-Macros$$ Sum based on conditional formatting

Dear Members I have a query regarding conditional formating: 1. I have a sheet in which some cells containg amounts out of those some cells are coloured. Is there any way to coloured only those coloured cells. One way i have by filter on the basis of colour but everytime to use that is hectic so

Re: $$Excel-Macros$$ Maill Merge in Two Excel Sheet

Hi Ankur, Not sure, whether i understood your query completly... Pls find this code This code takes the staff no. from Sheet2 and puts in "A2" in the 'gents report" sheet. It then picks up the result from "C2" cell of the same sheet and puts into the income tax column for the corresponding staff

Re: $$Excel-Macros$$ Vlookup Regarding Query Please Help

hi Noorain Ansari very good formula.can u explain me what "*" had make difference in this formula. use of "*" in formula had done what magic..i will also use this in other formulas in future Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best bu

Re: $$Excel-Macros$$ Vlookup Regarding Query Please Help

Dear Jai, Please try it without helping column.. =VLOOKUP(B7&"*",Sheet1!B7:C12,2,) Thanks & regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* On Wed, Jul 6, 2011 at 2:19 PM, Jai wrote: > -- > > ---

Re: $$Excel-Macros$$ Vlookup Regarding Query Please Help

*hi jai find the attached filethis has slight modification of venkatesan solution...the repeat of name is taken care , as u required tell me it helps? *Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Wed, Jul 6,

Re: $$Excel-Macros$$ Vlookup Regarding Query Please Help

Hi Jai, Look Attached below.. On Wed, Jul 6, 2011 at 2:19 PM, Jai wrote: > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailyti

$$Excel-Macros$$ Vlookup Regarding Query Please Help

-- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutor

Re: $$Excel-Macros$$ Need a Macro

Thanks a lot Ashish but this doesn't do what i need. I want the available quantity and amount against negative and zero values. In other words I want to set off those negatives and nulls with the positives. Thanks & regards, AJ On Wed, Jul 6, 2011 at 12:39 PM, ashish koul wrote: > Option Comp

Re: $$Excel-Macros$$ Maill Merge in Two Excel Sheet

Hi Ankur, Glad to help you. Pls send me your file...let me try :) On Wed, Jul 6, 2011 at 12:34 PM, ankur wrote: > hi vasant > thnks for such nice code >  i have similar problem also...but i need some modification > this code produce many workbook...cant  it be possible to create a single > workb

Re: $$Excel-Macros$$ Maill Merge in Two Excel Sheet

Hi Ankur, Glad to help you. Pls send me your file...let me try :) On Wed, Jul 6, 2011 at 12:34 PM, ankur wrote: > hi vasant > thnks for such nice code >  i have similar problem also...but i need some modification > this code produce many workbook...cant  it be possible to create a single > wor

Re: $$Excel-Macros$$ Need a Macro

Option Compare Text Sub test() Dim i, j, w As Long w = Sheets(1).Range("a65356").End(xlUp).Row For i = 2 To w If Range("e" & i).Value = 0 And Range("f" & i).Value < 0 Then Range("h" & i).Value = Range("d" & i).Value Range("d" & i).Value = "" Range("i" & i).Value = Range("e" & i).Value Range("e

Re: $$Excel-Macros$$ Maill Merge in Two Excel Sheet

*hi vasant thnks for such nice code i have similar problem also...but i need some modification this code produce many workbook...cant it be possible to create a single workbook with different sheets for each employee ? another query i have asked one query earlier about data validation requi