Is there a way to find a duplicate with 3 criteria? I know it can be done with
one. Assuming there is data in columns A, B, C. I need to find if there are
any duplicates that match all three in those columns. Thanks.
--
---
Hi,
Is it possible to crack the password for the excel window.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN g
Would really appreciate if you give others some time to think.. Thanks !!
~Cheers,
Krishnan Moorthy
P Please consider the environment before printing this e-mail.
ツ♫♪
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On
Behalf Of Nadine S
Sent: Friday, July 30
Hi,
Try this out.
Sub Macro1()
'Assumes data starts in cell A1
Columns("A:A").Select
Selection.Insert Shift:=xlToRight
Range("B1").Select
Selection.Cut
ActiveCell.Offset(2, -1).Range("A1").Select
ActiveSheet.Paste
Selection.Copy
ActiveCell.Offset(1, 0).Range("A1")
HI,
Hope this helps
pls run the macro "ALign" in the attached file.
Data in "Sheet1" is aligned in "Sheet2". I hv copied the code for your
convenience.
*Sub Align()
Dim Wksht As Worksheet, NWksht As Worksheet
Set Wksht = ThisWorkbook.Worksheets("Sheet1")
Set NWksht = ThisWorkbook.Worksheets("Sh
Hello,
Thanks for the feedback, could you please help me out do a lookup.how
can i retrieve the "code" attached to each maximum. The " code" column is on
the left and for example ...the first column max 901 is related to code
107, how can i get that code!
Regards and thanks!
2010/7
Hi Janet,
Another, perhaps neater way is to set H4 to =IFERROR(D4/G4,"-") which
will override not only #DIV/0 errors but also those pesky #N/As that
crop up with monotonous regularity in my worksheets! (I overote them
with a "-", but you could equally use "" if you want the field to
appear empty
I need to create macro to reformat spreadsheet for importing into
Access. As usual the spreadsheet is not formatted properly.
Here is a piece of the spreadsheet:
3196
28320221EBLADENST 39294812
275813701MABLELANE 40189085
3200
601771294ANGELINEDRIVE 40240796
60136321JOHNMBOORDR
Hi Angelo,
Have a look at the attached.
Regards - Dave.
From: spinolaang...@gmail.com
Date: Fri, 30 Jul 2010 11:35:12 +0100
Subject: $$Excel-Macros$$ Maximum...URGENT!
To: excel-macros@googlegroups.com
Hello,
I urgently need to get the maximum value from Kgs column. But i have specific
c
Please see if you can resolve the below code..It use to run perfect,
but now fails the last statement:
Sub patron_RetrieveData()
Dim ns As Outlook.NameSpace
Dim fld As Outlook.MAPIFolder
Dim itm As Object
Dim msg As Outlook.MailItem
Dim ex As Excel.Application
Dim filePreMD
Hi,
This is a stand-alone line. Just put it in a module and run it from a button or
keyboard shortcut. Or you can use it inconjunction with other code.
But try it alone first, to see if it does what you need.
Sub FirstEmptyCellActiveRow()
Cells(ActiveCell.Row, Columns.Count).End(xlToLeft).
Hello,
I urgently need to get the maximum value from Kgs column. But i have
specific criteria, they have to have same "Date" and same "Code_number".
How can i do this?
Thanks for you help and regards
--
--
Some im
>
> Hello All,
>
> I have a collumn called problem, in that collum i recieved a mapped value
> but it is doing it wrong.
>
>
> I need the formula to get the highest value in "*Kgs*" Column (criteria
> same *date*, same *code_number)*.
>
>
> Based on the *Kgs *Maximum value, it has to get the "*code
2003 h/..but jo apne bataya vo already tha ..but fir b macros nai h
On Fri, Jul 30, 2010 at 2:16 PM, Aindril De wrote:
> Which version of Excel are you using??
> In Excel 2003:
>
> To allow unsigned macros to run, the *Trust all installed add-ins and
> templates* check box must be selected on th
Kishan
Thanx, for your help.
But kindly tell me if i save macro in This Workbook,
Will it work for other workbooks.
REHAN
On Wed, Jul 28, 2010 at 11:53 AM, Kishan Reddy, K <
kishanreddy.kethire...@gmail.com> wrote:
> Instead of storing the macro in personal macro workbook, select this
> workb
The solution was sent through mail.
Is the solution working fine, reply back.
Regards,
Kishan Reddy, K
On Jul 29, 8:33 am, Nagendra Modupalli wrote:
> Hi Team,
>
> The password is correct "STPIInvoices" in this up to STPII is CAPS letter
> nvoices is small latters.
>
> Please let me know if you
HI
If you are using excel 2003
Click on Tools->Macro->Security
and then select Medium
and close the file and open the file again.
If you are using excel 2007
Click on Office Button
Goto Excel Options, select Trust Center, select Trust Centre Settings,
select Macro Settings, check on Enable All
attach the form, let me check.
Kishan Reddy, K
On Jul 28, 10:16 pm, b wrote:
> I have an Excel workbook w/ a VBA menu to pops up a userform to write
> values back to a worksheet in the workbook. Sometimes, the userform
> locks Excel and it has to be abended. I suspect its due to users have
> oth
Hello,
Let me know,
How many number of REPs are there?
Why do you want to put them in different sheets?
Regards,
Kishan Reddy, K
On Jul 29, 2:11 pm, Venkatesh Narla wrote:
> Hi,
> Can u check this this can be helpor not
>
> On Wed, Jul 28, 2010 at 11:21 PM, Ahmed Honest wrote:
> > Dear Al
Dear Pooja
Pls find below the steps to be taken to enable the macros in MS Excel.
1. Click the *Microsoft Office Button* [image: Button image], and then click
*Excel Options*.
2. Click *Trust Center*, click *Trust Center Settings*, and then click *Macro
Settings*.
3. Select the options *Enable al
Which version of Excel are you using??
In Excel 2003:
To allow unsigned macros to run, the *Trust all installed add-ins and
templates* check box must be selected on the *Trusted Publishers* tab of the
*Security* dialog box. This option is selected by default. If it is not
selected (recommended), E
Mr Abhishek Jain,
There is problem with the function when the following dates are given.
29/01/2010
30/01/2010
31/01/2010
Please check and modify it.
Regards,
Kishan Reddy, K
On Jul 30, 9:47 am, Abhishek Jain wrote:
> You're welcome.
>
> However, both works. 1st one is having reference of th
hi
there is a problem in opening an excel file with macros...wht should be done
to open the excel file with macros?
pls rply soon..it is urgent
--
Pooja
--
--
Some important links for excel users:
1. Follow us o
Hi Vasant,
I have sent an email to you with regard to the date ranges. Please refer
that mail and do the needful. Thanks a lot for your help.
Regards,
Sharma
On Thu, Jul 29, 2010 at 10:31 PM, Vasant wrote:
> Hi,
>
> The Recd Date and Completion date is differs for each employee. So you
> mean
24 matches
Mail list logo
