hi shaik.
Sorry. i need code for ths..
On Fri, Mar 2, 2012 at 12:38 PM, vijayajith VA wrote:
> Hi Sahik,,
>
> Sorry ..i need required code for ths .. Thanks''
>
>
> On Fri, Mar 2, 2012 at 12:35 PM, Shaik Waheed wrote:
>
>> Hi,
>> PFA solved, hope this is what u need.
>>
>> Steps:1) Select ur dat
Hi Sahik,,
Sorry ..i need required code for ths .. Thanks''
On Fri, Mar 2, 2012 at 12:35 PM, Shaik Waheed wrote:
> Hi,
> PFA solved, hope this is what u need.
>
> Steps:1) Select ur data range--> click on "data" menu, ---> Remove
> Duplicates--->Just click OK.
>
> On Fri, Mar 2, 2012 at 12:14 P
Hi,
PFA solved, hope this is what u need.
Steps:1) Select ur data range--> click on "data" menu, ---> Remove
Duplicates--->Just click OK.
On Fri, Mar 2, 2012 at 12:14 PM, vijayajith VA wrote:
> Hi
>
>
>
> Please find the attached query///
>
>
> Thanks
>
> --
> FORUM RULES (986+ members already B
Hi
Please find the attached query///
Thanks
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be
Thank you so much
Thanks
N.Sundarvelan
9600160150
On Wed, Feb 29, 2012 at 8:05 PM, dguillett1 wrote:
> Or this which copies template to the end.
>
> Private Sub Workbook_Open()
> Dim mydate As String
> mydate = Format(Date, "dd-mm-")
> With Sheets(Sheets.Count)
> If .Name <> mydate Then
Thank you verymuch my dear friends
Thanks
N.Sundarvelan
9600160150
On Thu, Mar 1, 2012 at 4:49 AM, Haseeb Avarakkan wrote:
> Hello Sundarvelan,
>
> Assume your sheet name always be in dd-mmm-yy format, if so see the
> attached.
>
> In Summary B1 & B2, enter the Start & End Date, So this will c
Hi Friends,
Help me in achieving this task.
sumproduct across multiple sheets
Thanks
N.Sundarvelan
9600160150
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Pro
On Thu, Mar 1, 2012 at 9:26 AM, Seraj Alam wrote:
> Hi,
>
> Please try this with Ctrl+shift+enter
>
>
>
> =INDEX($B$3:$B$11,MATCH(LARGE(IF($A$3:$A$11=$E$3,$C$3:$C$11,""),1),$C$3:$C$11,0))
>
>
> On Wed, Feb 29, 2012 at 11:40 AM, dguillett1 wrote:
>
>> Is this “homework” for an excel class?
>>
>
Kindly help me with my question on Excel i.e., I have time in the format
01:02:40 ( hh:mm:ss) but I want the time to be shown as 01:03 i.e., seconds
to be rounded off to minutes.
And if you have any files on visual basic 2008 with examples that I can use
to learn with screenshots and codes. Please
Hi Team,
I need a help from your side, i have a folder where more that 2000 xls and
word and PDF file save. i want to make a list of name in MS excel and then
i want to delete the unusable file from the list,
Please help me.
Thanks and Regards,
Surendra Singh
+91 95842 66415
--
FORUM RULES (9
Hi,
Please try this with Ctrl+shift+enter
=INDEX($B$3:$B$11,MATCH(LARGE(IF($A$3:$A$11=$E$3,$C$3:$C$11,""),1),$C$3:$C$11,0))
On Wed, Feb 29, 2012 at 11:40 AM, dguillett1 wrote:
> Is this “homework” for an excel class?
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
> *From:* M
Hi all,
I have a spreadsheet with thousands of rows and columns of text that
I'd like to translate into Greek.
Can anyone tell me how I might do that using VBA with some free
service or API online?
Many thanks in advance.
Kim
--
FORUM RULES (986+ members already BANNED for violation)
1) Use
Try a combination of index and match function
Sent on my BlackBerry® from Vodafone
-Original Message-
From: "John A. Smith"
Sender: excel-macros@googlegroups.com
Date: Thu, 1 Mar 2012 12:10:21
To:
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ LOOKUP Formula for Two
Hello Selva!
So glad Noorain's suggestion worked for you. The apostrophes/single quotes
by-the-way are only needed for surrounding sheet names.
Take care :)
Asa
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of LearnExcel
Sent: Thu
Thanks guys...works like a charm.
your all like angles but just more down to earth
On Mar 1, 1:14 pm, NOORAIN ANSARI wrote:
> Dear Selva,
>
> Please see attached sheet, hope your requirement is this.
>
>
>
>
>
>
>
>
>
> On Thu, Mar 1, 2012 at 10:43 PM, LearnExcel wrote:
> > thanks guys, i
How do you want to split it? Just use
=TEXT(NOW(),"mmm")
for the month
Don Guillett
SalesAid Software
dguille...@gmail.com
From: danial mansoor
Sent: Thursday, March 01, 2012 11:24 AM
To: excel-macros@googlegroups.com ; noorain.ans...@gmail.com ;
grug...@gmail.com
Subject: $$Excel-Macros$$ n
i need to use formula,i did paste special but left right function does not work
properly y?i need to extract time only instead of data but date function does
not work properly?
plz give me any formula.
Date: Thu, 1 Mar 2012 23:36:45 +0530
Subject: Re: $$Excel-Macros$$ number spliting formula
Dear Selva,
Please see attached sheet, hope your requirement is this.
On Thu, Mar 1, 2012 at 10:43 PM, LearnExcel wrote:
> thanks guys, is there any reason why the following isnt's working
>
> a6 = sheet name
> h6 = name of the criteria
> **the criteria is a name "Phone"
>
> all i get it 0
>
>
Need help on counting the combiantion of medicine given to same patient
for eg if NTG and Protonix is given together to same patient then i need to
count how many patients have got the combination of NTG and Protonix.
A matrix has to be designed taking types of Medicine on column side and
types
Dear Danial,
You can also use Text To Column after paste Special as Value
Process
Select-Fixed Width-text-Ok
On Thu, Mar 1, 2012 at 10:54 PM, danial mansoor wrote:
> i used NOW() function to get below date but now i want to split it,i try
> to used LEFT and RIGHT function but it does not work
Hello, I was trying to open an worksheet in an email and read data
from that worksheet.
Does anyone know if that is possible?
thanks in advance,
Matt
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgen
Dear all.,
We can take either NOW() or TODAY(), but those has to be paste special by
values and then we can use RIGHT() or LEFT() with our required values and
then redo the paste special by values and that cell has to be formated by
appropriate function. This may help.please try if u feel Ok.
Why don't you use TODAY()
Sam Mathai Chacko
On Thu, Mar 1, 2012 at 10:54 PM, danial mansoor wrote:
> i used NOW() function to get below date but now i want to split it,i try
> to used LEFT and RIGHT function but it does not work on numbers i think
> wats the reason? and any suitable formula?
>
i used NOW() function to get below date but now i want to split it,i try to
used LEFT and RIGHT function but it does not work on numbers i think wats the
reason? and any suitable formula?
3/1/2012 9:54:09 PM
Date: Thu, 1 Mar 2012 17:58:56 +0530
Subject: $$Excel-Macros$$ Userform Filter
Fr
thanks guys, is there any reason why the following isnt's working
a6 = sheet name
h6 = name of the criteria
**the criteria is a name "Phone"
all i get it 0
COUNTIF(INDIRECT("'"&A6&"'!g:g"),INDIRECT("'"&"h6"))
On Feb 29, 5:59 pm, "Asa Rossoff" wrote:
> =SUM(INDIRECT("'"&A6&"'!G:G"))
>
>
>
>
>
please unsubscribe .to stop mails need to subscribe new mail id
finux...@gmail.com
On Wed, Feb 29, 2012 at 11:50 AM, Mohammed Muneer wrote:
> Hi, Don thanx.
>
> ** **
>
> ** **
>
> Regards,
>
> Muneer,
>
> CC..
>
> ** **
> --
>
> *From:* excel-macros@
Dear Sir,
I am doing MOSTLY repetative tasks with the 'DATA'. Iam learning
the use of the 'RECORDER' in the developer. I save this 'macro'
recoring with diff. names. they are OK. What I need to learn is
1> How to do the tasks for TODAYS No. of record [ as this varies
daily ] and my recorded
Hello Experts
i am trying to follow the logic behind how the figures behind column K was
derived but i still cant see any connection. could you kindly explain to me
pls. thanks
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles
I just sent itThanks!
On Mar 1, 9:42 am, "dguillett1" wrote:
> Reply to my email with your file
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>
>
>
>
>
>
> -Original Message-
> From: Scruffy Huffy
> Sent: Thursday, March 01, 2012 6:51 AM
> To: MS EXCEL AND VBA MACROS
>
Reply to my email with your file
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Scruffy Huffy
Sent: Thursday, March 01, 2012 6:51 AM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ "Un-selecting" a cell being copied
Don,
I did this and got thi
Hi,
Try something like this
Dim CopyRange As Range
Dim DestCellAs Range
Dim FromSheet As Worksheet
Dim ToSheet As Worksheet
Set FromSheet = ThisWorkbook.Worksheets("Sheet1")
Set ToSheet = ThisWorkbook.Worksheets("Sheet2")
Set CopyRange = FromSheet.Range("a2:z223")
S
Can you post the exact range from where you copy and where to you copy?
On Thu, Mar 1, 2012 at 7:33 PM, Scruffy Huffy wrote:
> Sam,
>
> I'm getting a run-time error '438': Object doesn't support this
> property or method.
>
> Thanks for the advice, though.
>
> Robb
>
> On Mar 1, 8:49 am, Sam Ma
Hi,
Arrange your table like this.
D18 E18 F18 G18 H18 D19 0 126 376 626 D20 0 1 2 3 4 D21 101 5 6 7 8
D22 301 9 10 11 12 D23 501 13 14 15 16
and the formula is
=INDEX(E20:H23,MATCH(B2,D20:D23),MATCH(A2,E19:H19))
Kris
--
FORUM RULES (986+ members already BANNED for violation)
Sam,
I'm getting a run-time error '438': Object doesn't support this
property or method.
Thanks for the advice, though.
Robb
On Mar 1, 8:49 am, Sam Mathai Chacko wrote:
> Not tested, but try this
>
> range("a2:z223").copy
> with
> range("a1").resize(range("a2:z223").rows.count,range("a2:z223"
Not tested, but try this
range("a2:z223").copy
with
range("a1").resize(range("a2:z223").rows.count,range("a2:z223").columns.count)
.unmerge
.paste pastevalues
end with
Regards,
Sam Mathai Chacko
On Thu, Mar 1, 2012 at 6:21 PM, Scruffy Huffy wrote:
> Don,
>
> I did this and got this message: "
I still do NOT understand your need?
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Amit Desai (MERU)
Sent: Sunday, February 26, 2012 12:58 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Avg. Revisit in number of days
Dear Don,
Please refer attached sheet...s
Hi friends,
For the sake of learning I just keep doing some thing or the other, mostly
in excel. Once something occurred to me and this is what I have
accomplished so far -
http://www.youtube.com/watch?v=-NT6IYrTqew
Please view the video to understand what exactly I am talking about
(recommended
Don,
I did this and got this message: "run-time error '1004': Method
'Range' of object'_Global' failed"
I'm definitely a novice when it comes to thisanything obvious I'm
missing?
Thanks.
Robb
On Feb 29, 4:55 pm, "dguillett1" wrote:
> range("a2:z223").copy
> range("a1").paste pastevalues
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
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles
Oh ok never saw it that way, I ended up doing this way
=IF(AND(F8<126;G8<16;H8<2);14,5;IF(AND(F8<376;G8<16;H8<4);16,5;IF(AND(F8<626;G8<16;H8<6);18,13;IF(AND(F8<1001;G8<16;H8<16);24,9;0
with 3 rules, do you think it´s viable this way, or should i "compact" to
your way in order to be more stable
Hi Dave or any expert
pls can you provide any feedback on the below?
pls could you kindly explain to me the bases or logic behind column K
figures (as attached). i cant seem to understand the pattern or logic
behind it.
On Tue, Feb 28, 2012 at 2:21 PM, hilary lomotey wrote:
> Hello Dave
>
41 matches
Mail list logo