Dear Sir
Data is not change because the data value is same in both the sheet for
Zincmini. If we change the value in 61212 sheet the data will be change.
Rgds
Rajesh
On Friday, December 14, 2012 2:18:03 PM UTC+5:30, amar takale wrote:
>
> Dear Swapnil,
>
> Formula is good,but if I change sheet na
Dear Praveen,
Thanks for the reply.
Actually frankly speaking I don't have any file right now with me. But I can
discuss the problem.
I want to hide two rows with a click in check box. So by recording macro I am
able to do that!!
But now I want to unhide this two row when it uncheck the "Check b
Dear Excel guru,
I want to capture check box uncheck procedure! I have assigned a macro to
check box! So when I click it, it works perfectly but now I want that when I
untick it, it works differently from that!
Please help!
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
--
Join offi
Paul,
I can't thank you enough for working so hard on this. I definitely
understand your logic but unfortunately when I try to create the Start
(adj) column, it returns the error #NUM!. What is weird is that the
End(adj) column works fine. Do you have any idea why this would happen? I
have att
Congratulations to all winners
Thanks for the participation.
-Ayush
On Dec 14, 2012 8:26 PM, "Rajan_Verma" wrote:
> *Vinay’s worksheet is password protected, I think formula should be
> visible to all *
>
> * *
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> * *
>
Hi
try this one too see if it helps
https://sites.google.com/site/e90e50fx/home/infographic-chart-with-excel
http://www.excelhero.com/blog/2012/05/excel-formulas-can-make-a-graph.html
On Fri, Dec 14, 2012 at 11:05 PM, Christi Jacob wrote:
> i think the "radar" used innovatively does give option
The donut chart will help
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Christi Jacob
Sender: excel-macros@googlegroups.com
Date: Fri, 14 Dec 2012 23:05:24
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Pie Charts
i think the "radar" used inn
i think the "radar" used innovatively does give option to use the pie chart
with 2 variable.
:)
regards
christi jacob
On Fri, Dec 14, 2012 at 7:19 PM, Rajan_Verma wrote:
> *Hi,*
>
> * *
>
> *You can use this Add-ins ( Unfortunately I did not get time to document
> it. ) *
>
> * *
>
> *Data shou
Paul,
Thanks for getting back so quickly. For Row 11, that was my error, it was
suppose to end the following day at 11:00 AM (giving us a total of 5
Business Hours). I have attached the revised spreadsheet.
Perhaps a little more explanation on my part can help. I am trying to
measure a Help D
Timothy,
What you're asking is pretty tricky...
---
TECHNICALLY, you cannot START an action on a Saturday and END it on a Sunday of
the SAME WEEK,
unless you "assume" that the week begins on Monday (instead of Sunday)
And... for your row 11, the start time is AFTER the end time.
-
I don't think we can work that way...
You're using someone ELSE's macro with YOUR files and folders
and you've admitted that you've "edited the macro a little bit"...
and you want us to suggest how to fix it without seeing
the macro, your files and folders, and what edit's you've done?
Well.. I
thanks but the macro is not entering in to the loop.
I have edited the macro lil bit at my end.I have removed the part which is
for saving the complied file & i think it's not going to effect anyway.
please suggest..
On Friday, December 14, 2012 8:31:22 PM UTC+5:30, Rajan_Verma wrote:
> *Ok,*
>
There are LOTS of different objects that are required by different applications.
Rather than try to include them all at the same time,
we can include them individually as "References".
In order to use:
Dim Fso As New Scripting.FileSystemObject
The "Microsoft Scripting Runtime" reference is require
Yes
www.ozgrid.com
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Manjunath Narayanappa
Sent: 14 December 2012 8:25
To: 'excel-macros@googlegroups.com'
Cc: 'Rajan_Verma'
Subject: RE: $$Excel-Macros$
Ok,
Open Visula Basic Editor
Goto the Tool- Reference -Select Microsoft scripting runtime
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of SG
Sent: 14 December 2012 8:26
To: excel-macros@googlegro
Hi all,
I have been really struck trying to find a formula to calculate business
hours between 2 dates, especially if it is started on a weekend and ending
on a weekend.
I have attached an excel spreadsheet with certain dates, and the answers
that I am looking for. I have also attached a holid
Vinay's worksheet is password protected, I think formula should be visible
to all
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Paul Schreiner
Sent: 14 December 2012 8:20
To: excel-macros@googlegr
may be i'm silly with the question, but really not getting it that you have
replied.
On Friday, December 14, 2012 8:16:28 PM UTC+5:30, Rajan_Verma wrote:
> *Ah..*
>
> * *
>
> *You can add reference “Microsoft scripting runtime”*
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gt
Dear Rajan,
is this a link
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Rajan_Verma
Sent: 14 December 2012 13:55
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Link or Group to Join
Ozgrid.com
Regards
Rajan verma
+91 78381006
Ah..
You can add reference "Microsoft scripting runtime"
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of SG
Sent: 14 December 2012 7:54
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$
hi Rajan,
Thanks for the reply.I have taken the macro from 2nd link.
However on running the macro, the code in 4th line
'Dim Fso As New Scripting.FileSystemObject'
gives an complie error 'user-defined type not defined'.
please help on this.
On Friday, December 14, 2012 7:28:17 PM UTC+5:30, Raj
See if it helps
1) http://excelpoweruser.wordpress.com/2012/06/07/compile-worksheets/
2)
http://excelpoweruser.wordpress.com/2011/08/12/compiling-workbooks-2/
3) http://excelpoweruser.wordpress.com/2011/07/06/compiling-workbooks/
Regards
Rajan verma
+91 7838100659 [IM
Ozgrid.com
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Manjunath Narayanappa
Sent: 14 December 2012 7:03
To: 'excel-macros@googlegroups.com'
Subject: $$Excel-Macros$$ Link or Group to Join
Hi Experts,
I need your help in one of my problem.I want to consolidate the
multiple excel files of a folder with same name & numbered as 1,2,3 in to a
one excel file.I have tried but unable to create a macro on it.There is
only one criteria in this consolidation is that on column D of every s
Dear Expert
I want my friends to join this group, but there are beginner and they have to
start from the Scratch
Is there as Link or Group . So I can suggest them to Join to this Group to
learn
Thanks
Manjunath
PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTI
*Dear Amar,*
*
*
*Pl share the test file.*
*
*
*Regards*
*Pravin Gunjal.*
*
*
On Fri, Dec 14, 2012 at 5:50 PM, amar takale wrote:
> Dear Experts
>
> Pls can anybody help me on this matter.
>
> As always, Thank you very much for all the help
>
> Regards
> Amar
>
>
>
> On Thu, Dec 13, 2012 at 1:00
Dear Experts
Pls can anybody help me on this matter.
As always, Thank you very much for all the help
Regards
Amar
On Thu, Dec 13, 2012 at 1:00 PM, amar takale wrote:
> Dear all
> Can Anybody tell me formula to merge cell entry in one column if it is
> duplicate then over right on it
>
> Reg
You can make two pie charts, make one larger or smaller and drag the
smaller on top of the larger.
Regards
David Grugeon
On 14 December 2012 16:32, P.VIJAYKUMAR wrote:
> Respected Guru's,
>
>
> I have a curious question i.e why cannot pie chart represent two sets of
> values.For Example if I
28 matches
Mail list logo