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 resp...@gmail.com
Oh ok never saw it that way, I ended up doing this way
=IF(AND(F8126;G816;H82);14,5;IF(AND(F8376;G816;H84);16,5;IF(AND(F8626;G816;H86);18,13;IF(AND(F81001;G816;H816);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?
2012/2/29
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
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 dguille...@gmail.com wrote:
range(a2:z223).copy
range(a1).paste
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
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
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 tuffhu...@yahoo.com wrote:
Don,
I did this and got this
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 samde...@gmail.com wrote:
Not tested, but try this
range(a2:z223).copy
with
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)
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 tuffhu...@yahoo.com 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
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)
Set
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 this
I just sent itThanks!
On Mar 1, 9:42 am, dguillett1 dguille...@gmail.com 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
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
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
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 mmun...@ccc.com.qawrote:
Hi, Don thanx.
** **
** **
Regards,
Muneer,
CC..
** **
--
*From:*
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 a...@lovetour.info wrote:
=SUM(INDIRECT('A6'!G:G))
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
Why don't you use TODAY()
Sam Mathai Chacko
On Thu, Mar 1, 2012 at 10:54 PM, danial mansoor danial_...@hotmail.comwrote:
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
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.
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,
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 danial_...@hotmail.comwrote:
i used NOW() function to get below date but now i want to split it,i try
to used LEFT and RIGHT function
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 Selva,
Please see attached sheet, hope your requirement is this.
On Thu, Mar 1, 2012 at 10:43 PM, LearnExcel sendse...@gmail.com 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
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
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$$
Thanks guys...works like a charm.
your all like angles but just more down to earth
On Mar 1, 1:14 pm, NOORAIN ANSARI noorain.ans...@gmail.com wrote:
Dear Selva,
Please see attached sheet, hope your requirement is this.
On Thu, Mar 1, 2012 at 10:43 PM, LearnExcel
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:
Try a combination of index and match function
Sent on my BlackBerry® from Vodafone
-Original Message-
From: John A. Smith johnasmit...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Thu, 1 Mar 2012 12:10:21
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
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 dguille...@gmail.com wrote:
Is this “homework” for an excel class?
Don Guillett
SalesAid Software
dguille...@gmail.com
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
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
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.
On Thu, Mar 1, 2012 at 9:26 AM, Seraj Alam seraj.ala...@gmail.com 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 dguille...@gmail.com wrote:
Is this
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
Thank you verymuch my dear friends
Thanks
N.Sundarvelan
9600160150
On Thu, Mar 1, 2012 at 4:49 AM, Haseeb Avarakkan haseeb.avarak...@gmail.com
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
Thank you so much
Thanks
N.Sundarvelan
9600160150
On Wed, Feb 29, 2012 at 8:05 PM, dguillett1 dguille...@gmail.com 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
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
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 vijayajith...@gmail.comwrote:
Hi
Please find the attached query///
Thanks
--
FORUM RULES (986+ members
Hi Sahik,,
Sorry ..i need required code for ths .. Thanks''
On Fri, Mar 2, 2012 at 12:35 PM, Shaik Waheed waheedb...@gmail.com 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
hi shaik.
Sorry. i need code for ths..
On Fri, Mar 2, 2012 at 12:38 PM, vijayajith VA vijayajith...@gmail.comwrote:
Hi Sahik,,
Sorry ..i need required code for ths .. Thanks''
On Fri, Mar 2, 2012 at 12:35 PM, Shaik Waheed waheedb...@gmail.comwrote:
Hi,
PFA solved, hope this is what u
41 matches
Mail list logo