There are problems with this as the conditional formatting overrides any
locally applied formatting so the macro would need to exclude that cell
from the conditional formatting - not easy and not advisable. Conditional
formats can get confused enough without any help.
I would suggest you have a c
*Hi,
Please help in preparing the graph on the attached data
*
On Tue, Jun 5, 2012 at 6:33 PM, Rajan_Verma wrote:
> Hi Smith
>
> Every Chart needs related data, can you provide the data of *Growth*?
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** *
Great Noorain and Seraj,
Will revert if incase of any issue.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Seraj Alam
Sender: excel-macros@googlegroups.com
Date: Tue, 5 Jun 2012 20:31:55
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: extr
Hi
You can use below formula also...
=IFERROR(INDEX($B$3:$S$3,MATCH(B$19,$B$1:$S$1,0)),"")
On Tue, Jun 5, 2012 at 7:31 PM, NOORAIN ANSARI wrote:
> Dear Joseph,
>
> Please find attached sheet, Hope it will help to you.
>
> for Column Heading
>
> =IFERROR(INDEX($1:$1,0,SMALL(IF(($A$2:$A$11=$A$16)
Dear Michael,
Please share a sample workbook with Group.
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Wed, Jun 6, 2012 at 2:03 AM, Michael Landry wrote:
> I am working on a spreadsheet that contains several columns with due
> dates. I have cond
Dear Joseph,
Please find attached sheet, Hope it will help to you.
for Column Heading
=IFERROR(INDEX($1:$1,0,SMALL(IF(($A$2:$A$11=$A$16)*($A$2:$S$11<>0),COLUMN($B$1:$S$1),""),COLUMN(B1))-1),"")
For Numbers without 0
=IFERROR(HLOOKUP(B$15,$B$1:$S$11,MATCH($A16,$A$1:$A$11,0),0),"")
--
Thanks & r
Hi Joseph,
Do you want this done with formula or Vba script?
Pascal
--
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 atte
I am working on a spreadsheet that contains several columns with due dates.
I have conditional formatting rules that change the cell color as a due
date gets closer to today's date.
<15 days = yellow
<10 days = orange
<5 days = red
Once an activity has been completed, the user formats the date
Can you also give me an option if my number of rows change.
On Wed, Jun 6, 2012 at 1:18 AM, joseph camill wrote:
> yes, the number of rows and columns will be the same, but the values in it
> may change.
>
>
> On Wed, Jun 6, 2012 at 1:10 AM, Vish wrote:
>
>> Hi,
>>
>> Is your table going to be t
yes, the number of rows and columns will be the same, but the values in it
may change.
On Wed, Jun 6, 2012 at 1:10 AM, Vish wrote:
> Hi,
>
> Is your table going to be the same? I mean the number of columns and rows
> going to be same??
>
> On Wednesday, June 6, 2012 12:51:31 AM UTC+5:30, Joseph
Hi,
Is your table going to be the same? I mean the number of columns and rows
going to be same??
On Wednesday, June 6, 2012 12:51:31 AM UTC+5:30, Joseph wrote:
>
> Hi,
>
> I have a table and need to extract data that is non-zero.
>
> Attached is the sample file for your reference.
>
> Thanks,
>
Hi Puttu,
Please provide more details about your task such as the email client you
want to use. I would suppose Outlook but you don't tell. How column F is
completed? Do you manually changed the dates? What are the dates related to.
You should provide more details, it's too vague to me and mayb
Hi,
I have a table and need to extract data that is non-zero.
Attached is the sample file for your reference.
Thanks,
Joseph
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Pro
Thanks Asa, Noorain and Vijayjith for your help. Works great.
On Monday, June 4, 2012 5:59:40 PM UTC+4, vijayajith VA wrote:
> Hi ,,
> Then removie ..YES ..just give " "
>
> Thanks
>
> =IF(NOT(ISERROR(VLOOKUP(A7,'C:\Documents and Settings\user\My
> Documents\Downloads\New Folder\[Stock.xls]
PERFECT!! Thank you very much! I knew there was something out there I
haven't found yet.
On Tuesday, June 5, 2012 10:57:07 AM UTC-4, Sandeep Kumar Baranwal wrote:
>
> Refer
> functionx.com/vbaexcel
>
> this will help
>
> Sandeep
>
>
> On Tue, Jun 5, 2012 at 7:12 AM, charlyRoot wrote:
>
>> I don
You probably have your macro in the ThisWorkbook workbook open or a sheet
module activate. Move the body of the macro to a regular Sub linked to your
command button or a shape.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Mangesh Dayne
Sent: Tuesday, June 05,
Refer
functionx.com/vbaexcel
this will help
Sandeep
On Tue, Jun 5, 2012 at 7:12 AM, charlyRoot wrote:
> I don't know VBA other than manipulating recorded macros. What is the
> quickest way to learn from foundation up? Book? Some pay site? It takes to
> long to go through youtubes.
>
> I woul
Hi Friends,
I am working with the file containing macros.
I want all macros should be disable when i opened the file and should be
enable when i click on command button in file.
My intention is to stop executing the macro just after opening the file. It
should be run only when i click on command b
thanks Raj, I've just noticed, it's still too complicated to me but with the
time maybe.
Thanks
Pawel
From: Rajan_Verma
To: excel-macros@googlegroups.com
Sent: Tuesday, June 5, 2012 1:49 PM
Subject: RE: $$Excel-Macros$$ Graph with radio button
Hi,
Th
You can use the vba DIR to open each file in the current folder and then copy
the used range.offset(1) to the next available row in the consolidate file. If
necessary, you can specify the files within an array
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Kishore
Hi Rajan,
See below and attached. The first three are DOR (days of receivables) in
days and second three are the amounts associated with these accounts.
DOR in DaysInventory in m$ AccountWIPAR TotalWIPAR TotalABC5645101
6.517.524DEF 68351036.313.2 19.5GHI344579 3.44.57.9JKL 5525802.2
Hi Smith
Every Chart needs related data, can you provide the data of Growth?
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Smitha S R
Sent: 05 June 2012 3:25
To: excel-macros@googlegroups.com
Subje
You need to hide your workbook , because you cannot hide all worksheets in
your workbook
ALT +W H to Hide
ALT + W H U to Unhide
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Shaik Waheed
Sen
Can you please provide sample data also?
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Shishir Ranjan
Sent: 05 June 2012 11:30
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Creatin
This can probably be greatly simplified. Provide your excel version and the
file.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: thatguy
Sent: Monday, June 04, 2012 9:59 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need VBA to select and reassig
Hi,
There are three Simple VBA Procedure to accomplish this task. I have created
3 name ranges in your sheet Team1,Team2 and Team3 then on Every Option
Button Click Event I am assigning the Current Region of Corresponding Range
to the Chart Source.
Sub OptionButton1_Click()
S
May I ask why your request is more urgent and more important than the other
requests.??
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Nagendra Modupalli
Sent: Monday, June 04, 2012 11:30 PM
To: excel-macros@googlegroups.com
Subject:
Please help on the graph preparation
On Tue, Jun 5, 2012 at 3:25 PM, Smitha S R wrote:
> Hi,
>
> Please help me in drawing the graph, as per the attachment.
> Need a graph , month wise where the employee growth, cost wise growth and
> team could be identified .
>
> --
> FORUM RULES (986+ members
*To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com*
On Tue, Jun 5, 2012 at 4:04 AM, Ajay Tripathi wrote:
> Hi
>
> Please delete my name from mailing list for the time being.
>
> Thanx
>
> Ajay Tripathi
>
> --
> FORUM RULES (986+ members already BANNED for violatio
Hi
Please delete my name from mailing list for the time being.
Thanx
Ajay Tripathi
--
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 n
Hi,
Please help me in drawing the graph, as per the attachment.
Need a graph , month wise where the employee growth, cost wise growth and
team could be identified .
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Hi Sonal,
Sure --
String * length
indicates a "fixed-length string" of length number of characters in length.
I used it because the variable will always hold exactly one character, but
the usual "variable length string" (declared as just String) would have
worked too.
Asa
From: excel
Rajan...Thanks for the help but still your code is returning numbers .
On Monday, June 4, 2012 9:11:22 PM UTC+5:30, Rajan_Verma wrote:
>
> Ah , *Cod* is just a integer type *variable* , that will hold the *ACSII
> Code* or each character in string,
>
>
>
>
>
> * *
>
> *Regards*
>
> *Rajan ve
Hi david.
that "e" was bymistake.I want to clean special characters & spaces & it's
done by Asa's code.
thanks for your concern.
On Tuesday, June 5, 2012 6:11:41 AM UTC+5:30, David Grugeon wrote:
> Hi Sonal
>
> I hope you realise that if you apply any of the suggested solutions to
> your stri
Hi Asa,
your code really works exact for me.Thanks for the help but can u please
explain why you have done this "Character As String * 1".
On Monday, June 4, 2012 9:14:07 PM UTC+5:30, Asa R. wrote:
> I re-read your query and I see you only wanted alphabet characters. I
> had this include num
http://www.teachexcel.com/excel-help/excel-how-to.php?i=447580#3
2012/6/5 Darwin Chan
> Dear,
>
> I am not an expert, but see if the below page can give you some idea.
>
> Darwin
>
> 2012/6/5 Puttu *
>
>> Experts,
>>
>> Can you have look on my requirements and provide the solution.
>>
>> On Mo
Dear,
I am not an expert, but see if the below page can give you some idea.
Darwin
2012/6/5 Puttu *
> Experts,
>
> Can you have look on my requirements and provide the solution.
>
> On Mon, Jun 4, 2012 at 12:19 AM, Puttu * wrote:
>
>> Hi Excel Experts,
>>
>> Need a help on the macro for autom
Hi,
You can use the following code, i had been using this..
Sub unhide_sheets()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
ws.Visible = True
Next ws
End Sub
On Tue, Jun 5, 2012 at 1:33 PM, jayendra gaurav
wrote:
> Dear Team,
>
> I required your support to unhide 20 sheet
many many thanks ashish sir for helping me. i am also done it with the
following formula
=IFERROR(INDEX(Table1[SUBCODE],SMALL(IF(COURSES!$A$2:$A$804=LIST!$E$1,ROW(INDIRECT("1:803")),""),ROW()-34)),"")
but sir your method is simpler than me now i am following your method.
On Mon, Jun 4, 2012
Dear Team,
I required your support to unhide 20 sheets in single go.
kindly support me .
--
J.Gaurav
Call-7838594954
--
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,
Experts,
Can you have look on my requirements and provide the solution.
On Mon, Jun 4, 2012 at 12:19 AM, Puttu * wrote:
> Hi Excel Experts,
>
> Need a help on the macro for automated email reminders. below is the
> requirements. Attached is sheet for your reference
>
>
> Need a macro based on
Congrats Rajan. :D
On Mon, Jun 4, 2012 at 6:06 PM, Rajan_Verma wrote:
> Thank you all J
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *resp...@gm
42 matches
Mail list logo
