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 cell I
Dear Smitha,
Please find see attached sheet with example of below formula.
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Tue, Nov 15, 2011 at 12:13
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
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!BMATCH('Indirect
Example 3'!$A$4,Sheet4!$A:$A,0)) from Formula :Define Name*
Step 3: Select
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 rajanverma1...@gmail.comwrote:
HI,
You can change Cell Format as you required like dd.mm or mm.dd
On Tue, Nov 15, 2011
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,
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, Nov
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 noorain.ans...@gmail.comwrote:
Dear Suyog,
Please see attached sheet.
--
Thanks regards,
Noorain Ansari
Dear Chhajer,
Please try...
=Text(A1,)
On Tue, Nov 15, 2011 at 3:19 PM, chhajersand...@gmail.com 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.
Thanks for quick reply.
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: NOORAIN ANSARI noorain.ans...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Tue, 15 Nov 2011 15:36:41
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
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 want to
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
neerajchauhan...@gmail.comwrote:
Dear Experts,
How can I make
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:
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
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:
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
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$$
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 =
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
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 -
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,
Right click sheet tabview codeinsert 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
Case Else
End
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
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.
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 dguille...@gmail.com wrote:
Sam,
one
two
Don Guillett
SalesAid Software
dguille...@gmail.com
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
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
=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 suyog.kulka...@yahoo.comwrote:
Hello Noorain,
Thanks for quick response but I've added two problems in same excel.
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 could
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 goo...@finndj.dk wrote:
Hi Don
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
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 Aselect number to fill in Text and color
Totally buy that Don.
Cheers,
Sam
On Wed, Nov 16, 2011 at 12:50 AM, dguillett1 dguille...@gmail.com 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
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
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
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
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..??
On
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
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
Thanks Noorain.
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: NOORAIN ANSARI noorain.ans...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Wed, 16 Nov 2011 11:58:18
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
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://excelmacroworld.blogspot.com/
41 matches
Mail list logo