Hi Noorain
On Tue, Aug 30, 2011 at 2:32 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Cab,
Question -1, you can use attached Add in to Compare two worksheets..
Question -2, You can group both sheets to same entry on same time.
Press ctrl+shift+Pg down..
Thanks for your
Dear Cab,
Actually it is Add-In file when you click on this, it will be Show in Add-in
Menu bar when you need it can be use..
--
Thanks regards,
Noorain Ansari
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Tue, Aug 30, 2011 at 12:10 PM, Cab Boose
Hi Noorain
Thanks for that. It does not show in the add-in at the moment. Have opened
Excel and then opened the file you sent.
Is there a process that I should foolw ?
Thankyou
Charlie
On Tue, Aug 30, 2011 at 7:43 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Cab,
Actually it is
Dear Cab,
Process to add Add-Ins in Excel Ribbon
Excel Option-Add-Ins-Manage-Excel Add-Ins-Go-Ok
You can see below link..
http://www.lytebyte.com/2009/01/08/how-to-add-and-remove-excel-add-in-or-plugins/
--
Thanks regards,
Noorain Ansari
*http://noorain-ansari.blogspot.com/*
Hello,
Use :
a = SUMPRODUCT(--( rng1 = BEL ),--( rng2 =
AAO ),--( rng4 ))
HTH
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Chandra Shekar
Envoyé : lundi 29 août 2011 16:37
À : excel-macros@googlegroups.com
Objet :
- Original message
From:Teamware Solutions (quantum leap consulting) sw...@twsol.com
Date: 30 Aug 11 12:43:07
Subject: Urgent Requirment for MS SQL server 2005/2008Developers for TCS,
Kochi
To: venkatesa...@in.com
The sender of this email is registered with Naukri.com as
- Original message
From:Magna Infotech Pvt Ltd car...@magna.in
Date: 30 Aug 11 12:28:42
Subject: Opening for SQl Developer in Chennai with Ramco Systems
To:
The sender of this email is registered with Naukri.com as Magna Infotech Pvt
Ltd Experience required for the Job: 3 - 7
Dear Sajid,
Please change blue color path as per your system..
This code is working fine in my systems..
*Once again.try..*
**
*Private Sub CommandButton1_Click()
Dim wrknm As String
wrknm = ActiveWorkbook.Name
wrknm = Left(wrknm, InStr(1, wrknm, .) - 1)*
Hi Noorian,
How it will automatically save PDF Format in 2003 Version...is it
available..
--
*Best Regards,*
*Venkat *
*Chennai*
*
*
On Tue, Aug 30, 2011 at 2:16 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Sajid,
Please change blue color path as per your system..
This code is
Why don't you use a pivot table with the table option to split your
document by Division and Regional lead ?
On 30 août, 06:52, anu gomathi anugomathi.d...@gmail.com wrote:
Hi Experts,
I am very new to this forum.
Attached the details report the out put file. I need a macro to split the
On Aug 30, 4:55 am, Cab Boose swch...@gmail.com wrote:
Hi once again
This is totally new subject. I have model railroads. I would like to
control from Excel. (there are some other software available but I would
like to use Excel)
I want to send from Excel to a bus wire digital
Hi,
Be cautious with this macro and keep a copy of your workbook. Look at the
attached workbook in which there is an example of error.
Sub test()
Dim N As Name, Var As String, Tabl As Variant
For Each N In ActiveWorkbook.Names
If LCase(Left(N.RefersTo, 7)) =offset Then
Hi,
Can u pls explain me the steps. Any way i need the summary in the detail
sheet.
Regards
Anu
On Tue, Aug 30, 2011 at 2:52 PM, Frederic LE GUEN - MVP Excel
fleg...@gmail.com wrote:
Why don't you use a pivot table with the table option to split your
document by Division and Regional lead ?
Hi All,
Need a small help , i need to get a pop up of the user form when my excel
is opened, see the attachment
Thanks
Prasad.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks
Hi Prasad,
Look attached below...
If you want to create some VBA Coding in background of userforms..You have
to save the file has a .XLS or
XLSM because XLSX wont support Macro Language..
*Best Regards,*
*Venkat *
*Chennai*
On Tue, Aug 30, 2011 at 6:12 PM, Suryaprasad
What userform? Put this in the ThisWorkbook module
Private Sub Workbook_Open()
nameofyouruserformhere.Show
End Sub
From: Suryaprasad
Sent: Tuesday, August 30, 2011 7:42 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ User form
Hi All,
Need a small help , i need to get a pop
Hi ,
Please see my excel spread sheet i need the userform as POP see the chail
mail
Thanks
Prasad
On Tue, Aug 30, 2011 at 6:39 PM, dguillett1 dguille...@gmail.com wrote:
What userform? Put this in the ThisWorkbook module
Private Sub Workbook_Open()
nameofyouruserformhere.Show
End Sub
Hi Surya,
Your excel sheet is empty..Please check..
*Best Regards,*
*Venkat *
*Chennai*
*
*
*
*
On Tue, Aug 30, 2011 at 7:26 PM, Suryaprasad suryaprasad...@gmail.comwrote:
Hi ,
Please see my excel spread sheet i need the userform as POP see the chail
mail
Thanks
Prasad
On Tue, Aug
Hi vijay,
Please send some sample data...for your requirement..
*Best Regards,*
*Venkat *
*Chennai*
On Tue, Aug 30, 2011 at 7:26 PM, vijayajith VA vijayajith...@gmail.comwrote:
Hi,
i have four words and i need to combine using trim and proper functions.
Please can you provide me
Hi Surya,
Your excel sheet is empty..Please check..and resend it back...and
please Elaborate more about your query.
*Best Regards,*
*Venkat *
*Chennai*
*
*
*
*
On Tue, Aug 30, 2011 at 7:26 PM, Suryaprasad suryaprasad...@gmail.comwrote:
Hi ,
Please see my excel spread sheet i need the
Use Concatenate
=Concatenate(Proper(Trim(YourWord)), Proper(Trim(YourWord))
Or Sign
Proper(Trim(YourWord)) Proper(Trim(YourWord))
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of vijayajith VA
Sent: Tuesday, August 30, 2011 7:27 PM
You can put this in a regular sub or this worksheet double click event
Right click sheet tabview codeinsert thisdouble click any cell to name range
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
For Each N In ActiveWorkbook.Names
If InStr(1, N.RefersTo,
Hi Bajrang,
You can use sumifs() Function for this I think, or attached a sample file to
better understand your Query,
Rajan.
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of B Sharma
Sent: Tuesday, August 16, 2011 12:53 PM
To:
Hi NOORAIN ANSARI,
Pls tell wat is this.??
if you feel free explain me.
Regards
V. Kannan
Aircel Limited
Chennai
On Mon, Aug 29, 2011 at 3:38 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Anil,
Use Alt+A Q for Advance filter..
Choose *Filter the list-List range-Criteria
Hi Kannan,
In Excel 2007(or)2010 version Having Advanced filter option you can get a
unique records by using *Filter the list-List range-Criteria range-Unique
Records only *
*
*
*This Option will be used for removing duplicates and unique records viewing
Purpuse..*
*Best Regards,*
*Venkat *
Dear Vijay,
if your Word in one cell you can use...
=PROPER(Trim(SUBSTITUTE(D4, ,)))
On Tue, Aug 30, 2011 at 7:26 PM, vijayajith VA vijayajith...@gmail.comwrote:
Hi,
i have four words and i need to combine using trim and proper functions.
Please can you provide me formula
Thank
Hi Venkat,
Sorry for the wrong attachment, here is the updated one.
What i need is when i open the spread sheet the form should POP
automatically.
Thanks
Prasad.
On Tue, Aug 30, 2011 at 7:36 PM, Venkat CV venkat1@gmail.com wrote:
Hi Surya,
Your excel sheet is empty..Please check..
Dear surya,
Please see attached sheet..
On Tue, Aug 30, 2011 at 9:00 PM, Suryaprasad suryaprasad...@gmail.comwrote:
Hi Venkat,
Sorry for the wrong attachment, here is the updated one.
What i need is when i open the spread sheet the form should POP
automatically.
Thanks
Prasad.
On
Hi All,
Attached is the sheet where i need the list of the countries to be added to
the combo box
Note : The Combo box should be enabled once the data is entered in Text Box
given above of Combo box.
Please do the needfull.
Thanks
Prasad
--
Go to Property of Combo box type the Range under the row source of
Combobox.:
On Tue, Aug 30, 2011 at 9:09 PM, Suryaprasad suryaprasad...@gmail.comwrote:
Hi All,
Attached is the sheet where i need the list of the countries to be added to
the combo box
Note : The Combo box should be enabled
See the attached
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rakesh Joshi
Sent: Tuesday, August 30, 2011 9:29 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ How to load data into Combo box in user form
Go to Property of Combo
Your help please. I have a log of product sold and need to calculate the
different product sold to date, like a running accumulation field specific
to product listed in column B.
Please see my attached spreadsheet. Thanking you in advance for all your
great help.
John
--
Dear All,
Do we have any option for countifs Sumifs formula in MS Excel 2003?
Best Regards,
Amit Desai
Disclaimer: This message and its attachments contain confidential information
and may also contain legally privileged information. This message is intended
=sumproduct((a2:a22=1)*b2:b22)
From: Amit Desai (MERU)
Sent: Tuesday, August 30, 2011 11:24 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Option for countifs Sumifs formula in MS Excel 2003
Dear All,
Do we have any option for countifs Sumifs formula in MS Excel 2003?
What about option for countifS?
Best Regards,
Amit Desai
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of dguillett1
Sent: Tuesday, August 30, 2011 10:04 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Option for countifs Sumifs formula
=sumproduct((a2:a22=1)*(b2:b22))
From: Amit Desai (MERU)
Sent: Tuesday, August 30, 2011 12:03 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Option for countifs Sumifs formula in MS Excel
2003
What about option for countifS?
Best Regards,
Amit Desai
From:
Hi Rajan,
Thanks for the attachment, but my requirement is to add the list in the
Userform provided in excel sheet not on the excel spread sheet.
Note : The Combo box should be enabled once the data is entered in Text Box
given above of Combo box.
Please do the needfull.
Thanks
Prasad
On Tue,
But what if I need a count ( not sum)of numbers in a cell?
Best Regards,
Amit Desai
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of dguillett1
Sent: Tuesday, August 30, 2011 10:41 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Option
See the attached Sheet..
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rakesh Joshi
Sent: Tuesday, August 30, 2011 9:29 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ How to load data into Combo box in user form
Go to Property
TRY it!!!
From: Amit Desai (MERU)
Sent: Tuesday, August 30, 2011 12:18 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Option for countifs Sumifs formula in MS Excel
2003
But what if I need a count ( not sum)of numbers in a cell?
Best Regards,
Amit Desai
From:
Thank you very much for your quick response, your patience and your help.
John
On Tue, Aug 30, 2011 at 12:37 PM, dguillett1 dguille...@gmail.com wrote:
in d2 copied down
=SUMIF($B$2:B2,B2,$C$2:C2)
*From:* John A. Smith johnasmit...@gmail.com
*Sent:* Tuesday, August 30, 2011 11:09 AM
Please attach file
2011/8/30 anu gomathi anugomathi.d...@gmail.com
Hi,
Can u pls explain me the steps. Any way i need the summary in the detail
sheet.
Regards
Anu
On Tue, Aug 30, 2011 at 2:52 PM, Frederic LE GUEN - MVP Excel
fleg...@gmail.com wrote:
Why don't you use a pivot
Hi
I have written today a page about the way to create a worksheet
function of a criteria
http://www.excel-exercice.com/en/2074/creation-of-worksheets-by-criteria
I'm sure that this tip will help you ;)
On 30 août, 06:52, anu gomathi anugomathi.d...@gmail.com wrote:
Hi Experts,
I am very new
I have also created thousands of functions, and PivotTables
you're asking or you're selling web site?
2011/8/30 Frederic LE GUEN - MVP Excel fleg...@gmail.com
Hi
I have written today a page about the way to create a worksheet
function of a criteria
Hi Surya,
Try the Below...
*Private Sub Workbook_Open()*
*UserForm1.show*
*End Sub*
*Best Regards,*
*Venkat *
*Chennai*
*
*
On Tue, Aug 30, 2011 at 9:00 PM, Suryaprasad suryaprasad...@gmail.comwrote:
Hi Venkat,
Sorry for the wrong attachment, here is the updated one.
What i need is
Hi Amit
See below link for Sumifs in 2003
http://chandoo.org/forums/topic/converting-sumifs-to-excel-2003
--
*Best Regards,*
*Venkat *
*Chennai*
*
*
On Tue, Aug 30, 2011 at 9:54 PM, Amit Desai (MERU)
amit.de...@merucabs.comwrote:
Dear All,
** **
Do we have any option for countifs
Hi john,
Try the Below...
=SUMIF($B$2:$B$8,B2,$D$2:$D$8)
*Best Regards,*
*Venkat *
*Chennai*
*
*
On Tue, Aug 30, 2011 at 9:39 PM, John A. Smith johnasmit...@gmail.comwrote:
Your help please. I have a log of product sold and need to calculate the
different product sold to date, like a
Yes Rajan,
You are right I am using the same for the time being...
but I wanted to use this through Dsum... anyways ... thanks for your
time...
On Aug 30, 7:32 pm, Rajan_Verma rajanverma1...@gmail.com wrote:
Hi Bajrang,
You can use sumifs() Function for this I think, or attached a
How can I attach a spreadsheet for review?
--
--
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 @
I have the following:
Column A B C D
E F
12722 12722 51.564.89 RNLOX
12723 12723 51.564.89 RNLOX
Would you have the solution to replace B1 by B2 and delete row 2 once
completed since they have been
Hi All,
How to convert the numbers in a column based on following:
example:
13.45 should be displayed as 13
13.5 or 13.51(decimal equal or greater than .5) should be 14.
--
--
Some important links for excel users:
Hi,
You can try Remove duplicate's option in Excel 2007 or 2010 use ALT+A+T
*Best Regards,*
*Venkat *
*Chennai*
On Wed, Aug 31, 2011 at 2:44 AM, Gaetan M gaetan.me...@wanadoo.fr wrote:
I have the following:
Column A B C D
E F
12722
Hi,
In your G mail Just click Compose Mail and attach and write your query
and send it to
*excel-macros@googlegroups.com*
*Best Regards,*
*Venkat *
*Chennai*
On Wed, Aug 31, 2011 at 2:47 AM, Tripp ken...@gmxresources.com wrote:
How can I attach a spreadsheet for review?
--
Hi,
try Round formula Example Below
=ROUND(A1,0)
*Best Regards,*
*Venkat *
*Chennai*
*
*
On Tue, Aug 30, 2011 at 10:54 PM, Skanda skanda.pokkun...@gmail.com wrote:
Hi All,
How to convert the numbers in a column based on following:
example:
13.45 should be displayed as 13
13.5 or
Hi All,
Attached is the sheet where i need the data to be loaded Combo box of the
userform given, i need a VBA Code which picks the data from the excel
spread sheet and provides them in the combo box as a drop down list..please
help
Thanks
Prasad.
--
See attached file..
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Mr Excellent
Sent: Wednesday, August 31, 2011 10:20 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Combox List in Userform
Hi All,
Attached is the sheet where i
You can also use this :
=MROUND(B5,1)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Venkat CV
Sent: Wednesday, August 31, 2011 10:07 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Decimal greater than 0.5
Hi,
try Round
Sir ji EK sample file attached Kar do ..
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of B Sharma
Sent: Wednesday, August 31, 2011 9:24 AM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ How to use Multiple criteria in
Hi all experts
i have a small store which contains 300 products( MEDICINES).in a
quarter i reviced the items once or twice.But i issue items to various
dept twice in a week or thrice in fortnight.My requirement is
1.on item recieved to my store i enter all items in reciept colum.The
qty should
See the attached
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Venkat CV
Sent: Wednesday, August 31, 2011 7:33 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Option for countifs Sumifs formula in MS
Excel 2003
Hi Amit
60 matches
Mail list logo