TO UNSUBSCRIBE
Google Groups help on the subject:
http://support.google.com/groups/bin/answer.py?hl=enanswer=46608
Key points thereof:
Leave the group by any of these methods:
·Reply to any group email and change the subject to REMOVE ME
·Send a blank email to
Suppose you Enter actual date on D2 Cell
enter this formula where you want this result
=IF(VALUE(TEXT(D2,SS))30,TIME(TEXT(D2,HH),MOD(TEXT(D2,[m]),60)+1,0),TIME(TEXT(D2,HH),MOD(TEXT(D2,[m]),60),0))
On Fri, Mar 2, 2012 at 12:26 AM, Aruna jayaram aruna2...@gmail.com wrote:
Kindly help me with
Still waiting for reply?
On Thu, Mar 1, 2012 at 4:47 PM, Divaker Pandey divake...@gmail.com wrote:
Hi Expert,
Is there any way to access in Public Variable of Workbook A module by
WorkBook B Procedure.
if I can't do any modification in Workbook A macros.
Thanks in addvance
--
Aruna,
You could also use
=ROUND(A1*1440,0)/1440
The time is stored as a fraction of a day, and there are 1440 minutes in a
day. Multiplying the time by 1440 gives you minutes, which can then be
rounded off with ROUND() and converted back to time/day fraction by dividing
by 1440 again.
Asa
Hi Divaker,
This is possible. You just have to set a reference to the other workbook in
the VBE (Tools - References).
If you get a name conflict error, it is because the default name for the VBA
Project in a workbook is always VBAProject and you can't have multiple
references with the same
Hello,
Could you please let me know how to remove hyperlinks linked to graphical
objects (Its nearly 1000 objects)
Thanks in advance.
Regards,
Chandra Shekar B
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Dear Chandra,
Please check it
http://www.bigresource.com/VB-remove-hyperlinks-from-graphical-objects-in-excel-sv9vpXaqEN.html#APhFEcBxqn
On Fri, Mar 2, 2012 at 4:56 PM, Chandra Shekar chandrashekarb@gmail.com
wrote:
Hello,
Could you please let me know how to remove hyperlinks linked to
Hi Every One,
Friend I need a big help from you all, as I work in BPO company as a MIS
executive but I am not aware about Access or SQL. But every day I need to scrub
the NDNC data which I receive it from my client side.. Volume of a data will be
around 5 to 6 lake. Where I get NDNC scrubbed
Hi,
Do you want to chek whether the master file ph.# are callable or
non-callable by verying it with NDNC sheet?
On Sat, Mar 3, 2012 at 4:16 AM, Satvik satvik...@gmail.com wrote:
Hi Every One,
Friend I need a big help from you all, as I work in BPO company as a MIS
executive but I am not
Friends help me on this help.
Thanks
N.Sundarvelan
9600160150
-- Forwarded message --
From: Sundarvelan N nsund...@gmail.com
Date: Fri, Mar 2, 2012 at 11:52 AM
Subject: $$Excel-Macros$$ Sumproduct accross multiple sheets
To: excel-macros@googlegroups.com
Hi Friends,
Help me
chk attachments solved
On Fri, Mar 2, 2012 at 6:11 PM, Shaik Waheed waheedb...@gmail.com wrote:
Hi,
Do you want to chek whether the master file ph.# are callable or
non-callable by verying it with NDNC sheet?
On Sat, Mar 3, 2012 at 4:16 AM, Satvik satvik...@gmail.com wrote:
Hi Every
Dear Chandra,
You can also use..
Sub test()
Dim sh As Shape
For Each sh In ActiveSheet.Shapes
On Error Resume Next
sh.Hyperlink.Delete
Next
End Sub
--
Thanks regards,
Noorain Ansari
*http://noorainansari.com/*
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
On
Thanks for the replay Shaik...
Yes I need to check with DNC..
Sent from BlackBerry® on Airtel
-Original Message-
From: Shaik Waheed waheedb...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Fri, 2 Mar 2012 18:11:44
To: excel-macros@googlegroups.com
Reply-To:
Hi,
You can use vlookup to find the callable # from DNC sheet. Find the
attached file for ur reference.
On Sat, Mar 3, 2012 at 6:59 AM, Satvik satvik...@gmail.com wrote:
**
Thanks for the replay Shaik...
Yes I need to check with DNC..
Sent from BlackBerry® on Airtel
Shaik,
As off now I'm doing the same logic. Where as my data volume is too high!
Is there any other logic to map the same...
Regards,
Satvik
Sent from BlackBerry® on Airtel
-Original Message-
From: Shaik Waheed waheedb...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Fri,
u can try this one
=INDEX('E:\Desktop\[NDNC
file.xlsx]Sheet1'!$A$2:$B$11,MATCH(A2,'E:\Desktop\[NDNC
file.xlsx]Sheet1'!$A$2:$A$11,0),2)
On Sat, Mar 3, 2012 at 7:19 AM, Satvik satvik...@gmail.com wrote:
**
Shaik,
As off now I'm doing the same logic. Where as my data volume is too
high!
Thanks for helping me Sourabh..
Surly I will try the formula.. I will let you know the results by morning...
Regards,
Satvik
Sent from BlackBerry® on Airtel
-Original Message-
From: Sourabh Salgotra rhtdmja...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Fri, 2 Mar 2012
Hi,
Assume the sheet name always be in dd-mmm-yy format. I have define a name
CurrPeriod, you need to define it on your file. Just change Start End
Date reference in this formula. I also change some Locations for SALES in
multiple sheets to make sure it works :-)
See the attached.
Hi Satvik,
MATCH is faster than vlookup.
If your master file is unsorted, here are my best suggestions:
1. =IF(ISERROR(MATCH($A2,'[master
file.xlsx]Sheet1'!$A$2:$A$11,0)),Non Callable,Callable)
2. {=IF(ISERROR(MATCH($A2:$A11,'[master
file.xlsx]Sheet1'!$A$2:$A$11,0)),Non
Dear Haseeb
This is much better than what I expected ! Thanks a lot !!
On Sat, Mar 3, 2012 at 1:23 AM, Haseeb Avarakkan haseeb.avarak...@gmail.com
wrote:
Hi Yahya, See the attached.
___
HTH, Haseeb
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise,
Dear Group, thanx for the information for how to unsubscribe.
Regards,
Muneer,
CC
From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of Finos Edavanna
Sent: Thursday, March 01, 2012 7:57 PM
To:
Hi Muneer,
Do You need them for TDS Returns ?
On Tue, Feb 28, 2012 at 9:25 AM, Mohammed Muneer mmun...@ccc.com.qa wrote:
Dear Friends have a nice day,
** **
I have a small question.
** **
For example, I have two cols A and B as shown below one is for date the
other have
22 matches
Mail list logo