Cheerz
Thanks for acknowledgment..
Rgds//Vabs
-Original Message-
From: Jayaprakash S
Sender: excel-macros@googlegroups.com
Date: Fri, 21 Sep 2012 15:17:30
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: Data Filled every 15 Min.
Thanks so much Vabs f
Hi,
I wants to highlight those cells whose content is repeated in cells in the
select range.
As we highlight duplicate cell based on cell value, I want to highlight based
on cell content.
Thanks & Rgds.
-Original Message-
From: Prince Dubey
Sender: excel-macros@googlegroups.com
Date:
It workz for the given case but if more txt is der den formula wil run for
milez :p
I'm figuring formula dat wl work for all cases.
Rgds
-Original Message-
From: "Rajan_Verma"
Sender: excel-macros@googlegroups.com
Date: Sat, 15 Sep 2012 22:38:16
To:
Reply-To: excel-macros@googlegrou
At present there is no such predefined function to give cumulative value as
desired by you. I'll try to tweak n find solution.
Good Night ...
Cheerz n Thanks
Rgds//Vabz
-Original Message-
From: shashank bhosle
Sender: excel-macros@googlegroups.com
Date: Tue, 11 Sep 2012 01:56:56
To: e
Hi
This function works for me,
hi you can try dis VBA function
Function astrix(ByVal Txt As String, Optional Ref As Boolean = False) As String
Dim X As Long, CellVal As String
For X = 1 To Len(Txt) - 4
If Mid(Txt, X, 1) = "-" Then
Mid(Txt, X, 1) = "-"
Else
Mid(Txt, X, 1) = "*
First use Substitue fn to subst "-" with "" and then use Right function.
Rgds
Vabs
-Original Message-
From: maksood alam <786maks...@gmail.com>
Sender: excel-macros@googlegroups.com
Date: Fri, 7 Sep 2012 20:33:28
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ s
Congrats Noorain..
Rgds
Vaibhav
-Original Message-
From: Ayush Jain
Sender: excel-macros@googlegroups.com
Date: Sun, 2 Sep 2012 10:32:31
To: excel-macros
Reply-To: excel-macros@googlegroups.com
Cc: NOORAIN ANSARI
Subject: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member August 2012
Dear Amit,
Send me your sample extracted data and format in which you want day.
Rgds
Vaibhav
-Original Message-
From: "Amit Desai (MERU)"
Sender: excel-macros@googlegroups.com
Date: Thu, 30 Aug 2012 09:25:16
To: 'in.vaib...@googlemail.com';
Reply-To: excel-macros@googlegroups.com
Subj
Hi All
I have a tracker with almost 10 condition to be tasted. All condition is shown
as header, for case 1 when first event is completed then date of completion is
put under 1st header and under status for case 1 value to be reflected is
description of header 1.
When second event is completed
Yes Don ayush is correct I use your ideas to solve many problems at many other
forum n sites.
This is great forum for newbies n expert.
You all are stars n made this forum unique.
Thanks to all.
-Original Message-
From: Ayush Jain
Sender: excel-macros@googlegroups.com
Date: Sun, 1 J
Definitely agreed.
-Original Message-
From: Ayush Jain
Sender: excel-macros@googlegroups.com
Date: Mon, 18 Jun 2012 23:41:44
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: MIS executive
Vaibhav,
Allowing job posts is not only moderation but an invitatio
Hi Ayush,
Why can't we have separate team of moderator like other sites.
-Original Message-
From: Ayush Jain
Sender: excel-macros@googlegroups.com
Date: Mon, 18 Jun 2012 23:02:07
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: MIS executive
Hello All,
T
Hi,
What you want to import, provide with details.
-Original Message-
From: Hari
Sender: excel-macros@googlegroups.com
Date: Sat, 2 Jun 2012 22:35:23
To:
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Tally import
Hi,
Can someone tell the procedures of importing tra
Congrats Don n Thanks a lot for sharing.
-Original Message-
From: Ayush Jain
Sender: excel-macros@googlegroups.com
Date: Sat, 14 Apr 2012 09:36:16
To: excel-macros
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Most helpful Member - March 12- Don Guillett
Dear members
Go to control panel and change date format in regional setings.
-Original Message-
From: .•:*¨¨*:•. .•:V.Kiran Kumar :•. .•:*
¨¨*:•. vadnalaki...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Sun, 12 Feb 2012 22:25:06
To:
Reply-To: excel-macros@googlegroups.com
Subjec
Use formula
=text(ref,"Mmmm")
Where ref is cell reference.
BR//
-Original Message-
From: Rajesh K R
Sender: excel-macros@googlegroups.com
Date: Sun, 8 May 2011 16:48:36
To: excel-macros
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ get name of months from date
Hi E
Hi
Send attachment
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Umar Abeer
Sender: excel-macros@googlegroups.com
Date: Sun, 26 Dec 2010 10:56:20
To:
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Automation of copy paste exercise
Dear All,
I a
Yes,
Send your data sheet with ur requirements.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Rajesh K R
Sender: excel-macros@googlegroups.com
Date: Sat, 18 Dec 2010 17:24:19
To: excel-macros
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Create a new
Hi,
Copy data in separate sheet,
Then select all data in that coloumn,
Now select blank cells, by pressing ctr + G (i.e. Goto) then select Blank Cells
and Delete all Rows.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Rajasekhar Praharaju
Sender: excel-macros@googlegr
Hi,
Add line;
On error resume next
Rgds
Vaibhav J
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Raj Mahapatra
Sender: excel-macros@googlegroups.com
Date: Fri, 10 Dec 2010 10:02:19
To:
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Vlookup in Macro
Pl send your excel sheet.
Rgds
Vaibhav J
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Dick
Sender: excel-macros@googlegroups.com
Date: Sat, 4 Dec 2010 18:41:13
To: MS EXCEL AND VBA MACROS
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Sort
I have a
Hi,
You can use verypdf to convert pdf to excel
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Skanda
Sender: excel-macros@googlegroups.com
Date: Tue, 30 Nov 2010 11:29:26
To:
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Convert PDF to excel
hi All
Hi,
If possible send that file and how do u send email through Outlook, OL express
or through CDO.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Rahul Kamal Gandhi
Date: Tue, 30 Nov 2010 12:57:55
To: in.vaib...@googlemail.com
Cc: excel-macros@googlegroups.com
Subject:
Hi Again,
I can generate in PDF for that u will require to have Office 2007, but password
protection is not possible at present.
Is it OK.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Ankit Agrawal
Date: Mon, 29 Nov 2010 11:42:43
To:
Cc:
Subject: Re: $$Excel-Macros
Dear Yogesh,
Pl state your requirement in terms if action to be performed on receipt of
email.
Also mention which version of Excel you are using.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Yogesh Kudva
Sender: excel-macros@googlegroups.com
Date: Sat, 27 Nov 2010 21:
Dear Ankit,
Thanks for your appreciation, Is your query solved. If not then what type of
error is occurring.
You need to create payslips folder in C drive. And all files are stored in that
folder.
Pl note folder name is Payslips and not payslip.
The location and name of folder can be also cha
Dear Ankit,
File is saved in C:/Payslip folder.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Ankit Agrawal
Date: Sat, 27 Nov 2010 08:37:47
To: in.vaib...@googlemail.com
Cc:
Subject: Re: $$Excel-Macros$$ Salary sending problem
Namste Vaibhav ji,
*Unbelievable task. *
Thanks Ashish
Sent on my BlackBerry® from Vodafone
-Original Message-
From: "OpenExcel.com"
Sender: excel-macros@googlegroups.com
Date: Thu, 25 Nov 2010 05:40:23
To: MS EXCEL AND VBA MACROS
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Speed up Excel Start Up (FA
Hi
You have to clean up all your sheets. i.e. Re-Set excel last cells by deleting
un used cells.
Delete all un used coloumn and un used row.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Sundarvelan N
Sender: excel-macros@googlegroups.com
Date: Thu, 25 Nov 2010 12:54:02
Dear Ankit,
For sending email through excel following is basic requirement:
If you want to send email directly without help of any application viz. Outlook,
You shoud have SMTP server running on your workstation;
Or else you shoul use help of Macro to send it to Outlook.
At present I am not acc
Hi,
Why VBA code, use PDF to Word converter. Just Google it on internet it can
covert multiple files in once shot also.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: ashish koul
Sender: excel-macros@googlegroups.com
Date: Fri, 19 Nov 2010 03:38:02
To:
Reply-To: excel-
Hi,
Write this formula in cell B5 and copy down wherever you require;
=if(value(left(right(E5,3),1))=6,"800"&right(E5,3),"ABC-"&right(E5,3))
Sent on my BlackBerry® from Vodafone
-Original Message-
From: ratu elissa
Sender: excel-macros@googlegroups.com
Date: Sun, 14 Nov 2010 16:52:36
Can u explain logic of using ABC
Sent on my BlackBerry® from Vodafone
-Original Message-
From: ratu elissa
Sender: excel-macros@googlegroups.com
Date: Sun, 14 Nov 2010 16:52:36
To:
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ 3 last digit
Please Help Me
How to cr
Hi Bhavya,
Try usinf sumif function instead, it will help you get the sum.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: bhavya khanna
Sender: excel-macros@googlegroups.com
Date: Sun, 14 Nov 2010 12:55:47
To: ;
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-M
Hi,
Write following formula beside date column, i.e. In cell C4:
=text(B4,"mmm")
Now copy this formula in all rows of coloumn C, You will get Month name like
Aug in cell C4.
Now you can use sum if.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: janet dickson
Sender:
Hi,
Soln possible using pivot since result contains multiple data.
Rgds.
Vaibhavj
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Priya Jose
Sender: excel-macros@googlegroups.com
Date: Sun, 17 Oct 2010 15:52:52
To:
Reply-To: excel-macros@googlegroups.com
Subject: $$Exce
Congrats Ayush
Rgds
Vaibhav
www.excel.blog.com
Sent on my BlackBerry® from Vodafone
-Original Message-
From: "Vijay Kr. Aggarwal"
Sender: excel-macros@googlegroups.com
Date: Sun, 3 Oct 2010 04:22:40
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Ayush Jain -
PFA
Vaibhav J
www.excel.blog.com
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Pankaj Kumar
Sender: excel-macros@googlegroups.com
Date: Thu, 30 Sep 2010 21:15:12
To: excel-macros
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Hi
Hi, exper it urgent i
PFA
sheet with formula
Vaibhav J
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Pankaj Kumar
Sender: excel-macros@googlegroups.com
Date: Thu, 30 Sep 2010 18:28:53
To: excel-macros
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Urgent Querry
Hi, All E
39 matches
Mail list logo
