$$Excel-Macros$$ regarding date changing method

Dear Members, In excel 2003 I want to put the value in the cell (A1) as 15.11. But while changing(i.e. press enter or tab) the cell I want to convert the figure as 15.11.2011 and so on. Thanking you in Advance Regards, Sanjib -- - -- FORUM RULES (934+ members already BANNED for viola

Re: $$Excel-Macros$$ regarding date changing method

HI, You can change Cell Format as you required like dd.mm or mm.dd On Tue, Nov 15, 2011 at 1:40 PM, Sanjib Chatterjee < chatterjee.kolk...@gmail.com> wrote: > > Dear Members, > > In excel 2003 I want to put the value in the cell (A1) as 15.11. But > while changing(i.e. press enter or tab) > the

Re: $$Excel-Macros$$ Required Progres bar / Status bar while macro runinng....

You can use UserForm.SHow 0 .. On Mon, Nov 14, 2011 at 6:47 PM, dguillett1 wrote: > Attach your file with a reply to this msg. > > Don Guillett > SalesAid Software > dguille...@gmail.com > > *From:* maulik desai > *Sent:* Sunday, November 13, 2011 10:31 AM > *To:* excel-macros@googlegroups.c

$$Excel-Macros$$ Need help on Access VBA automating outlook

Hi Group members, I have one access tool which is automating outlook. Earlier it was working fine on all the systems in our team but now our office version is migrated on office 2010. Now when this code is running, it is giving error on some systems in our team. I am not able to find any solution

Re: $$Excel-Macros$$ Indirect formula

Dear Smitha, Please find & see attached sheet with example of below formula. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Tue, Nov 15, 2011 at 12:

RE: $$Excel-Macros$$ Indirect formula

Thanks Noorain Regards Smitha From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Tuesday, November 15, 2011 2:49 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Indirect formula Dear Smitha, Please find

Re: $$Excel-Macros$$ 10 Ways to Use Magical INDIRECT Function

Dear CG Kumar, Step 1:- Retrive Camera from Excel Option-Customize-All Commands-add Camera in Customize access toolbar then drag it on excel sheet. Step 2:provide name range of formula * =INDIRECT("Sheet4!B"&MATCH('Indirect Example 3'!$A$4,Sheet4!$A:$A,0)) from Formula :Define Name* Step 3: Selec

Re: $$Excel-Macros$$ regarding date changing method

Dear Ranjan Verma, But I want I only put 15.11 in a cell, it will convert into 15.11.2011 Thanking you in advance Sanjib On Tue, Nov 15, 2011 at 2:12 PM, rajan verma wrote: > HI, > You can change Cell Format as you required like dd.mm or mm.dd > > On Tue, Nov 15, 2011 at 1:40 PM, Sanjib Cha

Re: $$Excel-Macros$$ Query on dd-mm & mm-yy format

Dear Suyog, Please see attached sheet. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Tue, Nov 15, 2011 at 10:32 AM, Suyog Kulkarni wrote: > Hello

$$Excel-Macros$$ Convert Date to month

Dear all, I have a date written as 01/04/2011, 03/05/2011; I want a function in next column to show only April and May respectively. Thanking you in advance. Sandeep Chhajer. Sent on my BlackBerryŽ from Vodafone -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accur

Re: $$Excel-Macros$$ Convert Date to month

Hi Sandeep, We do not need a formula to do the same. Simple select the column/cell that has your date and change the format to a custom format delete everything in the "Type:" box and fill "" to display the full month name or "mmm" to display the month in a short form. Cheers, Andy On Tue, N

Re: $$Excel-Macros$$ Query on dd-mm & mm-yy format

Hello Noorain, Thanks for quick response but I've added two problems in same excel. Please review & advice. Suyog On Tue, Nov 15, 2011 at 3:14 PM, NOORAIN ANSARI wrote: > Dear Suyog, > > Please see attached sheet. > > > > -- > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogs

Re: $$Excel-Macros$$ Convert Date to month

Dear Chhajer, Please try... =Text(A1,"") On Tue, Nov 15, 2011 at 3:19 PM, wrote: > Dear all, > > I have a date written as 01/04/2011, 03/05/2011; I want a function in next > column to show only April and May respectively. > > Thanking you in advance. > > Sandeep Chhajer. > Sent on my BlackB

Re: $$Excel-Macros$$ Convert Date to month

Thanks for quick reply. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: NOORAIN ANSARI Sender: excel-macros@googlegroups.com Date: Tue, 15 Nov 2011 15:36:41 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Convert Date to month D

Re: $$Excel-Macros$$ regarding date changing method

Dear Mambers, any body please help. regards, Sanjib On Tue, Nov 15, 2011 at 1:40 PM, Sanjib Chatterjee < chatterjee.kolk...@gmail.com> wrote: > > Dear Members, > > In excel 2003 I want to put the value in the cell (A1) as 15.11. But > while changing(i.e. press enter or tab) > the cell I wan

Re: $$Excel-Macros$$ Help Required

Hi Neeraj, You can use the Consolidate function of Excel to achieve the same. Please follow the link below for the steps: http://support.microsoft.com/kb/214270 Cheers, Andy On Tue, Nov 15, 2011 at 4:00 PM, Neeraj Chauhan wrote: > Dear Experts, > > How can I make the qty against particular

RE: $$Excel-Macros$$ Help Required

Neeraj, In Excel 2007, there is only consolidate function. Consolidate by position and category is not available Regards Smitha From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Aindril De Sent: Tuesday, November 15, 2011 4:09 PM To: excel-macros@

Re: $$Excel-Macros$$ Need help on Access VBA automating outlook

hi kavita, you should add outlook reference in your excel workbook, which contains this code open visual basic editor (press Alt+f11) go on tool menu click on reference... option Microsoft Outlook 12.0 object library Divaker 9582060233 On Tue, Nov 15, 2011 at 11:46 AM, kavita ahuja wrote: > Hi

RE: $$Excel-Macros$$ Convert Date to month

Hi, You may define custome date as mmm in A2 column and give reference to the date column that you want to have as month. Regards, Hitesh Dhare (M) +919824004308 NWS-Gujarat Email id: hitesh.dh...@idea.adityabirla.com "Every Problem Is An Opportunity" -Original Message- From: excel

$$Excel-Macros$$ Help me

Hi Gurus, Is this possible to do data validation from one workbook to another workbook ? Can you give me one example? Thanks -- FORUM RULES (934+ 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$$ get all the datas or selected datas in different work sheets in to one sheet

Please explain the logic of your request “I want col a & col J from which_sheets. Please be very specific. Don Guillett SalesAid Software dguille...@gmail.com From: smitha.kumari Sent: Tuesday, November 15, 2011 3:20 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$

Re: $$Excel-Macros$$ regarding date changing method

Dear Sajib, Please try it and see attached sheet.. *Private Sub Worksheet_SelectionChange(ByVal Target As Range) On Error Resume Next If ActiveCell.Column = 1 And IsNumeric(ActiveCell.Offset(-1, 0).Value) = True And Not IsEmpty(ActiveCell.Offset(-1, 0)) Then ActiveCell.Offset(-1, 0).Value = A

Re: $$Excel-Macros$$ Import PDF into Excel

http://tinyurl.com/7owxkgt Don Guillett SalesAid Software dguille...@gmail.com From: Cab Boose Sent: Sunday, November 13, 2011 1:25 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Import PDF into Excel Hi I would like to use the 'File-Open' command in Excel to bring in a pdf

RE: $$Excel-Macros$$ Help me

Hi Vijayajith, Data validations can be created from one workbook to another workbook. Example: Attached are the two workbook 1. Source_Book.xlsx 2. My_Book.xlsx My list is available in Source_Book - sheet1 - range("A1:A5") and my validation is in workbook - My_Book.xlsx - Sheet1 -

$$Excel-Macros$$ Conditional formatting of entire row using VBA

Hi Can anyone help me with the VBA code for conditional formatting in Excel. I have af worksheet of 1000 rows with 5 colums. I have data in colum B;E and would like Excel to format the rows in a colour depending of what I write in colum A. I have 5 different text imput I can chose for each row,

Re: $$Excel-Macros$$ Conditional formatting of entire row using VBA

Right click sheet tab>view code>insert this Private Sub Worksheet_Change(ByVal Target As Range) If Target.Count > 1 Or Target.Column <> 1 Then Exit Sub Select Case LCase(Target) Case Is = "one": x = 1 Case Is = "one": x = 1 Case Is = "two": x = 6 Case Is = "three": x = 3 Case Is = "four": x = 4 C

Re: $$Excel-Macros$$ Conditional formatting of entire row using VBA

Here's how you do it. Select your entire row. Assuming your top left cell in the entire selection is A1 (will be any one cell in the first column depending on where you started your selection) Go to conditional format, and in the options 'Use formula to determine which cells to format', write =$A1

Re: $$Excel-Macros$$ Conditional formatting of entire row using VBA

Sam, > "one" > "two" Don Guillett SalesAid Software dguille...@gmail.com From: Sam Mathai Chacko Sent: Tuesday, November 15, 2011 10:21 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Conditional formatting of entire row using VBA Here's how you do it. Select your entire row

Re: $$Excel-Macros$$ Conditional formatting of entire row using VBA

Yes Don. I was just showing how it is done for one conditional. I had it done for One to Five in the attachment I had posted. Regards, Sam On Tue, Nov 15, 2011 at 10:07 PM, dguillett1 wrote: > Sam, > > "one" > > "two" > > Don Guillett > SalesAid Software > dguille...@gmail.com > > *From:* S

Re: $$Excel-Macros$$ Conditional formatting of entire row using VBA

Sam, I’m sorry.I opened in xl2003duh Don Guillett SalesAid Software dguille...@gmail.com From: Sam Mathai Chacko Sent: Tuesday, November 15, 2011 10:51 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Conditional formatting of entire row using VBA Yes

Re: $$Excel-Macros$$ Conditional formatting of entire row using VBA

FJO, if you are using Excel 2003 or less, then I am afraid the solution I posted will not be very useful, as it requires more than 3 conditionals, which only Excel 2007+ supports. So in that case, Don's VBA code should suit you fine. But if you are in Excel 2007 or 2010, you could use multiple con

Re: $$Excel-Macros$$ Query on dd-mm & mm-yy format

=IF(IFERROR(DATE(YEAR(G23),MONTH(G23),DAY(G23))=G23,0),MONTH(G23)&"-"&IF(DAY(G23)=1,0,DAY(G23)),G23) Regards, Sam Mathai Chacko On Tue, Nov 15, 2011 at 3:28 PM, Suyog Kulkarni wrote: > Hello Noorain, > > Thanks for quick response but I've added two problems in same excel. > Please review & advi

Re: $$Excel-Macros$$ Conditional formatting of entire row using VBA

Hi Don Guillett Thanks for your answer. It works perfect in the example. I then hoped I could change a few things and the it would still work, but I can not, and I can not see why. Instead of writing "One", "Two" and so on in Colum A, I would like to change this for different status, examples cou

Re: $$Excel-Macros$$ Conditional formatting of entire row using VBA

Don's code should be pasted in the sheet code module of the corresponding sheet that you are working on. Please check. By the way, you wouldn't need VBA for the desired feature if you are using Excel 2007 or greater. Sam On Wed, Nov 16, 2011 at 12:03 AM, FJO wrote: > Hi Don Guillett > > Thanks

Re: $$Excel-Macros$$ Conditional formatting of entire row using VBA

Hi Sam I am aware of the possibilities in office 2007 and later. But this sheet will be used by multiple users, someone still in office 2003. Therefore I will save it in the old office format. I knew where to put Don's code, and that worked, but I then wanted to change the words the conditional f

Re: $$Excel-Macros$$ Conditional formatting of entire row using VBA

Sam, I am one of those that does NOT like a lot of CF or even a lot of data validation. So, why not take a lot of the work away from the user and not clutter up the file with cf and dv. Let me know what you think of this idea to just double click col A>select number to fill in Text and color row

Re: $$Excel-Macros$$ Conditional formatting of entire row using VBA

Totally buy that Don. Cheers, Sam On Wed, Nov 16, 2011 at 12:50 AM, dguillett1 wrote: > Sam, I am one of those that does NOT like a lot of CF or even a lot of > data validation. So, why not take a lot of the work away from the user and > not clutter up the file with cf and dv. Let me know wha

$$Excel-Macros$$ How do i print all files [any file type (.pdf,.doc,.tiff)] in a folder using vba macros

Hello, Could you please guide me on how do i print all files [any file type (.pdf,.doc,.tiff)] in a folder using vba macros. The folder path is pre-defined. Thanks -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please

Re: $$Excel-Macros$$ Email Macro required for mail Boday

Thanks you so much sam for your prompt reply... Just want some modification & changes in your code 1.) Macro code should not pick the chennel name from K Column ( i have just created table from K to M for Understanding perpose),My actual data is from Column A to Column G. And Acual chennel name i

Re: $$Excel-Macros$$ Re: Email Macro required for mail Boday

Hi deepu, Thanks you so much for your reply I have tried to paste the code in module but it not work properly request you to kindly provide me the excel sheet with your macro code but before you send me the file required small changes do not use K & M column for Chennel name & email address that

Re: $$Excel-Macros$$ Email Macro required for mail Boday

Hi Deepak sir, I have pasted the required format in Sheet 2 & yes i am using Outlook 2007 to send mails... On Mon, Nov 14, 2011 at 10:37 AM, Deepak Pal Singh < deepaktheind...@gmail.com> wrote: > Can you provide the format of your data.. Also want to know do you outlook > to send emails..?? > > >

$$Excel-Macros$$ Pivot report with button

Dear all, I have to make many pivot report from same data...like one is LR wise... Other is Destination wise...Truck wise etc. What I want to assign a button for every report. Like if I click on button1 it will give me LR wise report if I click button 2 it will show me as Destination wise and s

$$Excel-Macros$$ date format changes

Dear All, How can i change 01/25/2011 to 25-Jan-2011 with a formula.. i have tried changing it with text to column (date option)... also done format cell option..but could not work... Regards, Amit Desai Disclaimer: This message and its attachments contain conf

Re: $$Excel-Macros$$ Pivot report with button

Thanks Noorain. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: NOORAIN ANSARI Sender: excel-macros@googlegroups.com Date: Wed, 16 Nov 2011 11:58:18 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Pivot report with button Dear

Re: $$Excel-Macros$$ date format changes

Dear Amit, Please try this formula. =TEXT(A5,"dd-mmm-yy") in vba, You can use Function Date_format(rng As Range) Date_format = VBA.Format(rng, "dd-mmm-yy") End Function -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://n