Hi Everyone.
Can you tell me what is worksheet change events. how can we use of advance
filter in worksheets change events.
Thanks
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips trick
Hi All,
Team, see attached file, please help me on how to remove duplicates in .xls
file.
.on love
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.
You can use Advance filters to remove the duplicates. Select the data...Go
to Data - Filter - Advance Filter - Click on Unique Records only - and Click
Ok...All the duplicate records will be filtered of.
Thanks,
Shreedar
On Thu, Sep 23, 2010 at 2:07 PM, janet dickson wrote:
> Hi All,
>
> Team, s
Hi,
See the attached file for details.
Chandru
On Thu, Sep 23, 2010 at 2:07 PM, janet dickson wrote:
> Hi All,
>
> Team, see attached file, please help me on how to remove duplicates in .xls
> file.
>
> .on love
>
>
>
--
Step1: Use additional columns as Test1 & test 2 in Column H & I
Step2: Add the Below formula to H2
=A2&C2&D2
Step3: Add the Below formula to I2
=COUNTIF(H$2:H2,H2)
Step4: Select H2 & I2 then Copy paste the formula to the below cells in
column H&I
Step5: Select the first row that th
Hi cyberspace,
I have some c programming background...
Is it possible to increment a worksheet object (worksheets collection)
in a loop such as below ?
Public Sub CopyShNamesFromWkbToWkb2()
Dim i As Integer
Dim wkb As Object
Set wkb = Workbooks("Nouveau_Feuille_Excel_1.xls")
Dim wkb2 As
Dear expert,
I am facing a problem to create dependent dropdown list.
Please check the attached file & help.
Thanks in advance
Kalyan
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tr
hi friends hereby i am attaching a worksheet in which i need a addition in
the given formula for getting the desired result.
please help me out.
--
Sidhu
--
--
Some important links for excel users:
1. Follow us on TW
you need to use:
Property Worksheets As Sheets
of Excel.Workbook
Public Sub CopyShNamesFromWkbToWkb2()
Dim i As Long
Dim wkb As Excel.Workbook
Dim wkb2 As Excel.Workbook
Set wkb = Workbooks("Nouveau_Feuille_Excel_1.xls")
Set wkb2 = Workbooks("Classeur1.xls")
'Dim ws As Object
'Set ws = W
> For i = 1 To wkb.Worksheets.Count
>
Fix this line
regards
r
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN gr
Thanks for your response I used *Advanced filter *and it worked out.
One Love...
On Thu, Sep 23, 2010 at 12:28 PM, Srinivasan Ethirajalu <
srinivasan.ethiraj...@gmail.com> wrote:
> Step1: Use additional columns as Test1 & test 2 in Column H & I
> Step2: Add the Below formula to H2
> =A
On 23 Set, 12:28, roberto mensa wrote:
> > For i = 1 To wkb.Worksheets.Count
>
> Fix this line
> regards
> r
g :-)
i'm sorry, so ...
For i = 1 To wkb2.Worksheets.Count
regard
r
--
--
Some important links fo
if you want to refer more than one column for identifying duplication you
need to concatenate the columns for advance filter... please keep in
mind.
Thanks
Srinivasan E
On Thu, Sep 23, 2010 at 4:11 PM, janet dickson wrote:
> Thanks for your response I used *Advanced filter *and it worked out
hi
check the attachment have made two functions see if it helps you
On Mon, Sep 20, 2010 at 11:07 PM, janet dickson wrote:
> Hello Team,
> Everyday I am supposed to visit http://www.goldprice.org/ and checking
> gold price, then I enter gold price into an excel file. I was wondering if
> it
Hi All,
Again I’m looking for help from you guys.
This is time I’m not sure this can be done by excel macro but just really
need it.
I have two excel with name A_201025.xls and B_201025.xls, I need to zip the
both file in a single compress file with a password protection. Below is the
actu
Send the file i will do it for you
N.SHIVKUMAR
Mobile : +919422613567
Office : +912332301775
Alternate Email: shiv1...@yahoo.com
On 23 September 2010 04:40, Skanda wrote:
> Hi All,
> How to unlock a password that is set for an excel file?
>
>
> --
>
> --
Hi,
I wanted to learn Excel Macros.Kindly help me.
Thanks,
Aswin
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN
Good day everyone,
I have a small fleet of Excel apps who, sometime, need updating.
For modules, I simply
ThisWorkbook.VBProject.VBComponents("WhateverModule").Export
tempFile
DestWbk.VBProject.VBComponents.Import tempFile
Kill (tempFile)
But I can not use the same code to import int
Good day everyone,
I have a small fleet of Excel apps who, sometime, need updating.
For modules, I simply
ThisWorkbook.VBProject.VBComponents("WhateverModule").Export
tempFile
DestWbk.VBProject.VBComponents.Import tempFile
Kill (tempFile)
But I can not use the same code to import int
Hello I have 3 columns with data and I need to make the following
comparisons:
1. value exists in all three columns
2. value exists in ONLY the first column
3. value exists in ONLY the second column
4. value exists in ONLY the third column
5. value exists in column 1 and exists in only column
Hi,
Instead of "Roundup" try "Round" formula.
Regards,
Swapnil
On Thu, Sep 23, 2010 at 3:49 PM, sudarshan rampe wrote:
>
> hi friends hereby i am attaching a worksheet in which i need a addition in
> the given formula for getting the desired result.
> please help me out.
> --
> Sidhu
>
> --
>
Hi,
I'm looking for a more general answer about objects in vba like :
dim ws as object
set ws = worksheets
For i = 1 To wkb.Worksheets.Count
wkb.Sheets(3).Cells(i, 4) = wkb2.Worksheets(i).Name
It's ok until the last line, i understand what little there is to
understand (pointed notation?).
Bu
hi swapnil...
if i am using round formula then the resultant value is coming to nearest
ten. but i need the resultant value to next ten only if the value is more
than 1 rupee in the one's place.
Eg
for ---8350-00
result8600.50
in this case only 8600 should be displayed.
but
for---9460
res
Kindly share the file for better understanding
--
--
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 @ http://www.
use
=IF(*MOD(ROUNDUP(C2*3%+C2,-1),10)>5*,*
ROUNDUP(C2*3%+C2,-1)-MOD(ROUNDUP(C2*3%+C2,-1),10)+10*,*
ROUNDUP(C2*3%+C2,-1)-MOD(ROUNDUP(C2*3%+C2,-1),10*))
On Fri, Sep 24, 2010 at 9:12 AM, sudarshan rampe wrote:
> hi swapnil...
> if i am using round formula then the resultant value is coming to nea
Hi Ayush,
I'm sasikanth. I'm new joinee to your group. I want to learn excel macros
(VBA). Could you please suggest me how to start because I don't know how to
write VBA script. Please suggest me how to start with it.
Thanks & Regards,
Sasikanth.
--
---
Please clarify:
Below are all possibilities:
***
Possibilities: Value to be displayed
***
ABC 1
A-- 2
-B- 3
--C 4
AB- 5
A-C 6
-BC 7
-
27 matches
Mail list logo