Hi Ayush!
You really deserve that title...
Regards,
Seema
On Tue, Oct 5, 2010 at 9:26 AM, Aindril De aind...@gmail.com wrote:
Hey Ayush!! You haven't responded to Neil's email
Where is the Treat Man!!!? [?][?]
Cheers,
Andy
On Mon, Oct 4, 2010 at 9:17 PM, krishna mummina
Dear Mr. Ayush Jain
One Word Name You : - *Matrix EXCEL *
Congratulations Ayush Jain. Really Very proud of you man.
Regards
Sumit Vyas
On 10/5/10, Aindril De aind...@gmail.com wrote:
Hey Ayush!! You haven't responded to Neil's email
Where is the Treat Man!!!? [?][?]
Dear Vijay
Very Good explain by you
Thanks
On 10/5/10, P.VIJAYKUMAR vijay.4...@gmail.com wrote:
Dear Ankit,
There is no Direct formula to convert numbers into text.But there are some
add-ins available in the websites. just google for text to numbers converter
in excel add-in.
Once
Thank you sir for deteil knowledge but again same problem *how we can use
add-in? plz tell me *
**
Thnanks Regards
Ankit
On Tue, Oct 5, 2010 at 8:30 AM, P.VIJAYKUMAR vijay.4...@gmail.com wrote:
Dear Ankit,
There is no Direct formula to convert numbers into text.But there are some
add-ins
Hi group.
I'm by no means a programmer. I'm trying to knock together a (what
should be) simple spreadsheet in Microsoft Excel for a calculation I
have to do on a regular basis. I'm hoping that some kind people within
this group will be able to help me with some formulas and questions.
If anyone
Dear Ankit ,
There is also an add-in called Ultimate add-in which contains a lot of other
features like finding and removing duplicates, transposing cell contents
between two cells etc, along with text to numbers conversion feature.
But,unfortunately some features of them are not working.But it
Dear Ankit,
To use the add-in select the number you want to convert into text.then go to
the add-ins in the Menu bar and select the text to numbers button.
Automaticaaly the number you selected turns into text. But, you dont't have
the original number.If you want to have the number and also the
Hello Ankit,
I did not understand you question properly. Why do use mail merge .You can
create single sheet work book as you salary ship and give password to it
and also mail the password to the concerned person through a text file
attached along with the salary sheet.
Regards,
P.VIJAY KUMAR
you can attach your excel salary sheet with salary slip through vlookup and
copy that slip on mail.
sending you a sample sheet (EMP CODE IS KEY )
WRITE ONLY EMP. CODE THE WHOLE DETAIL U CAN EXTRACT.
On Tue, Oct 5, 2010 at 12:40 PM, P.VIJAYKUMAR vijay.4...@gmail.com wrote:
Hello Ankit,
I did
Dear Mr.Ayush,
You are doing wonderful service here... Thank you so much.
Congratulations for MVP... I'm very happy to here in this group.
Regards,
Maries
On Tue, Oct 5, 2010 at 9:15 AM, SUMIT VYAS svyas0...@gmail.com wrote:
Dear Mr. Ayush Jain
One Word Name You : - *Matrix EXCEL *
Thanks.. Its working
--
--
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 @
Hi,
For every unique value of col A - C and col F, then the number is increased by
1 from col G unless there is already a number for that combo in col H, then it
gets increased by 1 from that number in col H
I think I understand the first part of the sentence, but the meaning of the
So, what was the problem?
was it a Before_right-click event?
I had suggested to disable the events as a diagnostic to check to see if that
was the problem.
NOT as a proposed solution!
Because when you exit excel and open it again, the problem will return.
Or was it something else?
paul
Hi Ayush,
You got the deserved
Regards,
Tulasi Rao
On Tue, Oct 5, 2010 at 10:40 AM, seema mba seema.mba2...@gmail.com wrote:
Hi Ayush!
You really deserve that title...
Regards,
Seema
On Tue, Oct 5, 2010 at 9:26 AM, Aindril De aind...@gmail.com wrote:
Hey Ayush!! You haven't
I agree.
Your description SEEMS to imply that if you're identifying records as a
combination of A-C and F.
Then, the first time a combination is encountered, increment the value in G and
place the result in H.
That portion of the statement:
unless there is already a number for that combo in
Hi,
I want to check the following things from the charaters
1)Character is capital letter or not
2)Character is bold or not
3)Character is italic or not
4)Character is underlined or not
Am also searching solution for these things. But i didnt fine any
solution. I dont want to convert. I just
Hi
My string is surha12hj
Here i want to take each and every character and i need to take only
charaters which is from A-Z or a-z.. Can any one help on to this.
--
--
Some important links for excel users:
1. Follow
The easiest way to do this is to record a macro in which you
Change a character to Capital, Bold, Italics and Underlined.
Then look at the macro as it is recorded.
The next thing is:
are you looking at the complete cell contents? or
a portion of the cell?
for instance:
to check for capital
what do you want to do with them?
are they in a cell or from a userform?
- Original Message
From: sivam sivamma...@gmail.com
To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com
Sent: Tue, October 5, 2010 8:39:34 AM
Subject: $$Excel-Macros$$ Analysing
Hi
My string is
Dear Group,
I am very happy to announce that Dilip and Paul are the top poster for
the month of September'10. They are the joint winners with 22 post
each. They both are all time poster of the group as well.
I really appreciate their consistency and quality of solutions
provided to this group.
Dear Group,
Thank you so much. I am quite happy to hear all the wishes in last 2
days.
It’s the greatest achievement of my life that I have been awarded as
MVP for contribution to the greater Excel Community.
The whole credit goes to my readers of blogs and Excel group members.
It was not
Hi guys,
I have to compare two trial balances every month. Presently, I compare them
using a vlook up formula and the account codes against which there is a NA
error I add them to the old trial balance.
I need a VBA code to automate the identification of the new codes and
addition to the rows in
As I said, record a macro in which you change the case/font of single
characters within a string and see how VBA sets the font in a string.
Here's what I came up with:
Option Explicit
Sub ChkString()
Dim NumChars, C, ChkStr
Range(A2:Z65000).ClearContents
Range(A2).Value = Char
Try:
Sub AddTags()
Dim ChkStr, ChkChar, OutStr, C
ChkStr = Range(A1).Value
OutStr =
For C = 1 To Len(ChkStr)
ChkChar = Mid(ChkStr, C, 1)
If (IsNumeric(ChkChar)) Then
OutStr = OutStr N ChkChar
ElseIf ((ChkChar = UCase(ChkChar)) _
Good. Keep going..
On Tue, Oct 5, 2010 at 4:09 PM, Tulasi Rao tulasir...@gmail.com wrote:
Hi Ayush,
You got the deserved
Regards,
Tulasi Rao
On Tue, Oct 5, 2010 at 10:40 AM, seema mba seema.mba2...@gmail.comwrote:
Hi Ayush!
You really deserve that title...
Regards,
funny!
Luckily, I haven't had any of my editors convert the
characters to smileys!
It would make it VERY distracting.. although cheerful!
Paul
- Original Message
From: ta...@tinusz.hu ta...@tinusz.hu
To: excel-macros@googlegroups.com
Sent: Tue, October 5, 2010 10:17:47 AM
Thank you for your help
But Sir I am using 2003 excel i m working on networking PC thus I think
the add-in did not install properly.
On Tue, Oct 5, 2010 at 12:35 PM, P.VIJAYKUMAR vijay.4...@gmail.com wrote:
Dear Ankit,
To use the add-in select the number you want to convert into
Hi,
Try this out. The formula on the right autopopulated for me, but it
may not for you.
Sub Macro1()
' David
Range(D3).Select
Do Until ActiveCell.Value =
NewAccount = ActiveCell.Value
OldAccount = ActiveCell.Offset(0, -3).Value
If NewAccount = OldAccount Then
But Sir there are more than hundred employee than how we can make only
single sheet
On Tue, Oct 5, 2010 at 1:04 PM, prabhakar jain prabhakar.kj...@gmail.comwrote:
you can attach your excel salary sheet with salary slip through vlookup and
copy that slip on mail.
sending you a sample sheet
Hi Everyone ,
I have rows of data with which I'd like to forecast the next 2 periods of
data for. What is the formula to do this. I'd like to do this in excel
all on one row as shown below:
monthJan Feb March April May June July Aug Sep(current Month)
Next remaing month
Hi Ayush, my heartiest congratulation
On Tue, Oct 5, 2010 at 4:55 PM, Srinivasan Ethirajalu
srinivasan.ethiraj...@gmail.com wrote:
Good. Keep going..
On Tue, Oct 5, 2010 at 4:09 PM, Tulasi Rao tulasir...@gmail.com wrote:
Hi Ayush,
You got the deserved
Regards,
Tulasi Rao
I'm not sure you're going to get much help here.
if you were to say that you have a numeric sequence
and would like help predicting the next number in the series.
Then, there MIGHT be a solution. Because there may be a relationship between
the numbers in the series:
10 20 30 40 50... the next
I've inherited a workbook with a macro code that when executed
modifies each worksheet's footers. Below is the code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = Range(inpQuoteNum).Address Or Target.Address
= Range(inpGrpName).Address Then
Dim lf As
Dear Team,
I attach sample excell sheet. In this regard i need consolitate all sheet
datas in single sheet. Here one heading Row is common for all sheet datas.
Because i have big excell file i won't copy and paste in single sheet. Any
ideas about this query (Macro or Any Formula). Please help
Dear Team,
I need help with attached file. In this one column Relay type, we select
any one item (in the combo box), its display all the corresponding details
below the combo box with the title. Please sortout my problem.
Thanks in Advance.
-
Regards,
Mohamed Idhrees. S.
--
Have you tried dataconsolodate... ?
On Oct 5, 11:50 am, Idhrees Mohamed idhrees...@gmail.com wrote:
Dear Team,
I attach sample excell sheet. In this regard i need consolitate all sheet
datas in single sheet. Here one heading Row is common for all sheet datas.
Because i have big excell file i
Hi Peter,
Sure soon I will send you that consolidation macro.
Regards,
Deepak Rai
On Mon, Oct 4, 2010 at 11:08 PM, Peter Konijn peter@gmail.com wrote:
Hi,
It works, thanks a lot for your support.
I am still curious for the macro of Deepak Rai.
Regards Peter
2010/10/3
I need a formula than can balance input data automatically. Ive been
working on this for quite sometime but unfortunately I cannot seem to
crack the secret. Let say for exampe I have 5 Teams, Team A has 4
members, Team B has 5 members, Team C has 6 members, Team D has 7
members and Team E has 9
Hi experts,
how to eleminate zeros while selective range for average
function.Please find the attachement here fro your reference.
Regards,
Rao
--
--
Some important links for excel users:
1. Follow us on TWITTER for
hi Pankaj,
Can you please tell what formula you are looking for.
Could you please express your query in brief.
Thanks,
Raj
On Tue, Oct 5, 2010 at 8:23 PM, Pankaj Kumar rajputpanka...@gmail.comwrote:
Hi, Experts Its urgent basis i need u r help, i have a Name list A-Z, I
have
Hi,
You can try this:
Sub Consolidate()
'10/5/2010 by David
Dim ws As Worksheet
For Each ws In Worksheets
Sheets(ws.Name).Select
If ActiveSheet.Name = Table 1 Then
Sheets.Add
Sheets(ActiveSheet.Name).Name = Consolidate
Sheets(ws.Name).Select
End If
Hello Guys,
Check it out.
http://www.vbaunlocker.info/*
*
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN
hi
check the attachment see if it helps
On Wed, Oct 6, 2010 at 5:14 AM, NRao Mynampati ml.narasimha...@gmail.comwrote:
Hi experts,
how to eleminate zeros while selective range for average
function.Please find the attachement here fro your reference.
Regards,
Rao
--
Really thanks Paul.. Its working fine...
--
--
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 @
Dear Ankit,
Here is a code that might help you. It is didvided into prts depending upon
your requirement copy and pate the required part in Visual basic.
'' Main Function *'
Function SpellNumbers(ByVal MyNumber)
Dim Rupees, Paise, Temp
Dim DecimalPlace, Count
Hello Ankit ,
There are also add-ins which will be able to install in 2003.Download
Ultimate add-in. There are two versions of That New one will be in 2007 but
the old one can be installed in old versions also.For installing add-ins in
old versions of Excel the process is different.The add-ins
Dear
No Proper work
On 10/5/10, Paul Schreiner schreiner_p...@att.net wrote:
funny!
Luckily, I haven't had any of my editors convert the
characters to smileys!
It would make it VERY distracting.. although cheerful!
Paul
- Original Message
From: ta...@tinusz.hu
Please help
Pankaj
On Sun, Sep 19, 2010 at 5:25 PM, pankaj gmail account
pankaji...@gmail.comwrote:
Hi to the forum,
Please help me it is very urgent for me
i have a text file which is (|) delimited in which it contains all
countries files, what i want to do is to create country wise
48 matches
Mail list logo