HI Ankit,
Find the attachment.
On Tue, Oct 25, 2011 at 9:42 AM, Ankit Agrawal
ankit.agrawal...@gmail.comwrote:
Dear Expert,
Plz solve out attached query.
Regards,
Ankit
--
--
Some important links for
Dear Ankit,
Please try below formula...
=LIQ/EE/INV/1112/SUMPRODUCT(--($C$5:C5=C5))
=LIQ/EE/INV/1112/COUNTIF($C$5:C5,C5)
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/*
Dear Don,
can you share your workbook with Group.
On Tue, Oct 25, 2011 at 1:40 AM, Don donf...@gmail.com wrote:
I have a report that is run daily. Every day the end user answers
among other things, what was yesterdays weather. They answer by
selecting the appropriate picture and clicking
Dear Members,
Please see the attachment. I am unable to do any operation with this figure
in the excel file. (i.e. Addition, multiplication, division etc)
please help
regards,
Sanjib
--
--
Some
Hi,
There are white spaces before number, remove those spaces and then you can
use functions.
Regards,
Swapnil.
On Tue, Oct 25, 2011 at 1:30 PM, Sanjib Chatterjee
chatterjee.kolk...@gmail.com wrote:
Dear Members,
Please see the attachment. I am unable to do any operation with this
Dear Swapnil Palande,
how to remove the space. What function do i use?
PLease help
ragards,
sanjib
On Tue, Oct 25, 2011 at 1:36 PM, Swapnil Palande
palande.swapni...@gmail.com wrote:
Hi,
There are white spaces before number, remove those spaces and then you can
use functions.
Dear Sanjeet,
Please try below formula and see attached sheet.
=TRIM(SUBSTITUTE(A2,CHAR(160),CHAR(32)))
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On
Dear Sanjib,
Replaces each nonbreaking space character (Unicode value of 160) with a
space character (ASCII value of 32) by using the SUBSTITUTE function, and
then removes the leading and multiple embedded spaces from the string
BD 122 (BD 112)
--
Thanks regards,
Noorain Ansari
How would I do that? I do not see a way to attach it to this post and
unfortunately it is not on a web-server only an internal secured data
server.
Don
On Oct 25, 2:30 am, NOORAIN ANSARI noorain.ans...@gmail.com wrote:
Dear Don,
can you share your workbook with Group.
On Tue, Oct 25,
I have this in my personal.xls file assigned to a custom button
Select your range and fire it
Sub fixmynums()
Application.ScreenUpdating = False
On Error Resume Next
For Each C In Selection
If Trim(Len(C)) 0 And C.HasFormula = False Then
C.NumberFormat = General
C.Value = CDbl(C)
I should like to be able to select the contents of a TEXT BOX control on a Form.
I have moved the focus to the TEXT BOX using the .SETFOCUS method. The box
shows the insertion point at the end of any text in the field. However, it
would be nice to automatically select (from a VBA macro) the
Perhaps you can attach a file(s)
1. can be solved with a loop where the file names are listed in a2:a22
Cash Disbursement Schedule.xls
etc
sub openfilesinlist()
mymonth=OCTOBER 'or an inputbox asking for the month or in a cell...
for each myfile in range(a2:a22)
Workbooks.Open Filename:= _
Private Sub TextBox1_MouseDown(ByVal Button As Integer, ByVal Shift As
Integer, ByVal X As Single, ByVal Y As Single)
Me.TextBox1.SelStart = 0
Me.TextBox1.SelLength = Len(Me.TextBox1.Text)
End Sub
On Tue, Oct 25, 2011 at 8:00 PM, Chris Boxall ch...@boxall.info wrote:
I should like to
Excel Teachers, I need to format 09/14/2011 0938 into 9/14/11 (or a real
date format). Please see attached spreadsheet.
Thank you for your help.
John
--
--
Some important links for excel users:
1. Follow us on
=DATEVALUE(TEXT((LEFT(A2,11)),MM/DD/))
OR
=DATEVALUE(LEFT(TRIM(A2),10))
rEGARDS,
Sam Mathai Chacko
On Tue, Oct 25, 2011 at 9:22 PM, John A. Smith johnasmit...@gmail.comwrote:
Excel Teachers, I need to format 09/14/2011 0938 into 9/14/11 (or a real
date format). Please see attached
Excellent! Thank you for your quick response and your continued teachings.
John
On Tue, Oct 25, 2011 at 11:56 AM, Sam Mathai Chacko samde...@gmail.comwrote:
=DATEVALUE(TEXT((LEFT(A2,11)),MM/DD/))
OR
=DATEVALUE(LEFT(TRIM(A2),10))
rEGARDS,
Sam Mathai Chacko
On Tue, Oct 25, 2011 at
With a bit modification to Noorain's formula, you can make it a little more
smaller
*=--SUBSTITUTE(A2,CHAR(160),)*
Regards,
Sam Mathai Chacko
On Tue, Oct 25, 2011 at 7:32 PM, dguillett1 dguille...@gmail.com wrote:
I have this in my personal.xls file assigned to a custom button
Select your
My macro needs to know when the user changes sheet.
I have located the Workbook_SheetActivate event but I'm confused as where I
place this.
If I place it in a code module in my macro it does not get executed.
If I place it in ThisWorkBook of my macro it does get executed when I change
Chris, first can you explain what you want to achieve with the sheet change
event. We can then decide on what kind of event and the level of the event
required. For example, if you just want to know whether the users switched
from your workbook to another workbook, you don't need a sheet event,
chg c2 to this
=VALUE(TEXT((LEFT(A2,11)),MM/DD/))
or
=VALUE(LEFT(A2,11))
Don Guillett
SalesAid Software
dguille...@gmail.com
From: John A. Smith
Sent: Tuesday, October 25, 2011 10:52 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need to Format Date By Formula
Excel
Hello Zeunasc,
You can also do it through Find/Replace command.
Select the column, press Ctrl+H to bring Find/Replace command.
Find What : *(hitcnt**
Replace All with blank.
Again;
Find What : *0x**
Replace All with blank.
Note: There is a * after each Find item.
HTH
Haseeb
--
To attach a file, go to your google mail, and check for this message, and
while doing a reply, you can attach a file as you would normally.
Sam
On Tue, Oct 25, 2011 at 5:18 PM, Don donf...@gmail.com wrote:
How would I do that? I do not see a way to attach it to this post and
unfortunately it
excel 2007 not support VBA coding so save ur in excel 2003 or xlsb
On Mon, Oct 24, 2011 at 5:44 PM, Aamir Shahzad aamirshahza...@gmail.comwrote:
Dear Noorain,
when I am saving your file it shows the attached error. please suggest.
Regards,
Aamir Shahzad
On Mon, Oct 24, 2011 at 5:03 PM,
Haseeb, why u use int or mod function ? pleas tell me
On Wed, Oct 26, 2011 at 12:35 AM, Haseeb Avarakkan
haseeb.avarak...@gmail.com wrote:
Hello Murali;
You can also use INDEX with INT MOD
see the attached
HTH
Haseeb
--
xlstime, that is the most hilarious statement I have ever seen. You might
want to reiterate.
Excel 2007 has the macro enabled file and the non-macro file apart from a
few other formats. To use VBA, you'll have to save the file as a macro
enabled file, and the extension is .xlsm
Any file saved in
Sorry Sam you are completely ,
i mean excel 2007 (Excel workbook not support vba) so save ur file in excel
2003 or excel macro enable 2007 format
On Mon, Oct 24, 2011 at 5:44 PM, Aamir Shahzad
aamirshahza...@gmail.comwrote:
Dear Noorain,
when I am saving your file it
Sirs,
Don Guillet did reply to my query re HELP: SHORTEN MY MACRO USING
LOOP. I want to thank him but i don't know how to reply.
How i should i reply to him or the group? Thank you.
--
--
Some important links for
Dear all,
I wrote the code in creating pivot table for my source of data.
However, when run the code, it prompts with the message.
Run-time error '438':
Object doesnt support this property or method
Below please find the code also.
Sub CreatePivotTable()
Dim
Hi,
It will be easy to solve issue if you provide sample data.
In your code you have not defined DataField, without data field it will show
you blank pivot.
Share sample data so that group can provide you correct code.
Regards,
Swapnil.
On Wed, Oct 26, 2011 at 10:07 AM, Chan Darwin
29 matches
Mail list logo