Yes apart from this thanks a ton to Ayush for his continous support... U rock
ayush
Sent from BlackBerry® on Airtel
-Original Message-
From: shashank bhosle
Sender: excel-macros@googlegroups.com
Date: Wed, 5 Oct 2011 11:17:30
To: excel-macros@googlegroups.com
Reply-To: excel-macros@goo
Hi Ayush,
Great Going Brother Keep up the Good Work...
Cheers,
Andy
On Tue, Oct 4, 2011 at 12:14 AM, Ayush Jain wrote:
> Dear members,
>
> I am proud to share that I have been re-awarded the Micrososft MVP award in
> 2011. My deep thanks to each group member for all your support and
> con
Hello Dguillett, Momin Siraj Ahmed,
Thank you very very much for giving your valuable time to solve my querry.I
can't express my self to thank to you.
you guys are so talented, even i feel like solving the querries, but i dont
have such a knowledge as you people have.
One more request to
Justyna,
Did you ever figure this out? I am currently going through the same
issue. Oddly, everyone I send the file to has the ability to see the
data populate as it should. However, I (the author of the file) is
receiving the same REF# error.
Let me know,
Thanks,
On Sep 21, 3:15 am, e_milia
Please see Mathai solution proposed by Sam Chacko
Excellent!
Private Sub Worksheet_Change(ByVal Target As Range)
Dim lngCount As Long
Dim lngLoop As Long
Dim strMsg As String
lngCount =
Evaluate("=SUMPRODUCT((Hoja1!$B$2:$B$57&Hoja1!$C$2:$C$57<>)*(Hoja1!$B$2:$B$57=Hoja1!B"
& Ta
Thanks Rajan I need is to columns B and C (together)
containing the mirrored pair in same row
good solution you propose, but only in column B duplicate
Thanks Rajan
2011/10/4 rajan verma
> Try this Code :
> this Code enable you to check the duplicate entry at the time of Data Entry
> ..
>
>
Dear Ayush ,
Congrats on your second achievement,
I have a problem with excel.Generally I work with Tally and Excel.When I
export accounting Data into excel, I am getting the data with debit and
credit along with the number i.e I am getting the data in custom format (
0.00 Dr). It is not possible
ADDITION: i just need the raw data to be exported to the respective sheets
based on REP column.No need of calculations of any kind.Hope i made it
clear...
On Wed, Oct 5, 2011 at 5:28 AM, Mr excel wrote:
> I m interested in learning macros don.only reason i m asking repeatedly is
> this situation
I m interested in learning macros don.only reason i m asking repeatedly is
this situation will be very helpful for me in my work.i just want the
workbook to update sheets as and when a new row is updated in the main
worksheet.
I need to see the whole details when demanded in my work.the example yo
Super, thanks a lot .
Regards
Rahul.
Sent from BlackBerry® on Airtel
-Original Message-
From: Sam Mathai Chacko
Sender: excel-macros@googlegroups.com
Date: Wed, 5 Oct 2011 00:16:13
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Pivot
Rahul,
So you select yo
I'm sorry, but it's not like that
I need it to be checked when i click on it like this symbol ( *√* )
On Tue, Oct 4, 2011 at 9:28 PM, dguillett1 wrote:
> Can you simply use
> data>validation
> as shown in the attached
> *From:* Ahmed Emam
> *Sent:* Tuesday, October 04, 2011 1:16 PM
> *To:*
Rahul,
So you select your source and create a pivot table. Take date in the row
field and Average of VND= in data column.
Now use grouping in the date column and select the time period is month.
Again use grouping in the month column and select the time period as year.
And voila! you have tw
Can you simply use
data>validation
as shown in the attached
From: Ahmed Emam
Sent: Tuesday, October 04, 2011 1:16 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ I need help
Here it's attached
On Tue, Oct 4, 2011 at 8:39 PM, NOORAIN ANSARI wrote:
Dear Ahmed,
if poss
Can you attach your file?
From: shaneallen
Sent: Tuesday, October 04, 2011 1:11 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Working out of Statistics on Exam Results URGENT
solution needed!
https://docs.google.com/viewer?a=v&pid=forums&srcid=MTI3OTgyMTkwNDM5NTM5NjQ5MzEBM
Here it's attached
On Tue, Oct 4, 2011 at 8:39 PM, NOORAIN ANSARI wrote:
> Dear Ahmed,
>
> if possible, Can you share Sample sheet with group..
>
> On Tue, Oct 4, 2011 at 11:38 AM, Ahmed Emam wrote:
>
>> Hi all members,
>>
>> I need an Excel sheet that contains check list for about 20 items
https://docs.google.com/viewer?a=v&pid=forums&srcid=MTI3OTgyMTkwNDM5NTM5NjQ5MzEBMTM0MzYwODk4NTMzNDg3MTc0MTEBMTgwMzYxMDQuMjM5LjEzMTc2NzA2NTg1NTkuSmF2YU1haWwuZ2VvLWRpc2N1c3Npb24tZm9ydW1zQHByZmIxMgE0AQ&authuser=0
*Hi *
*Thanx for your interest ,I feel more positive now that help is on its way
as I
Dear Ahmed,
if possible, Can you share Sample sheet with group..
On Tue, Oct 4, 2011 at 11:38 AM, Ahmed Emam wrote:
> Hi all members,
>
> I need an Excel sheet that contains check list for about 20 items , and
> that will be as a to-do note.
> Can anyone help me?
>
> Thanks in advance
>
> -
the file i need will have a list and every item will has in the next column
a check box that when i finish with one item i can check it.
As i told before it will be a to-do list.
Thanks
On Tue, Oct 4, 2011 at 7:18 PM, rajan verma wrote:
> hi,
> please explain ..
>
> On Tue, Oct 4, 2011 at 11:38 A
Email: sakshi.ma...@empyrean-partners.com
*
*
*
*
*Dear Candidate,*
Please find the details below:
Job Title Analytics Analyst
Reports to Assistant Manager /Manager / Senior Manager
Scope of Role
UK & Europe
Overall Job Purpose
• Handle projects that involves data analysis and data mining
hi,
please explain ..
On Tue, Oct 4, 2011 at 11:38 AM, Ahmed Emam wrote:
> Hi all members,
>
> I need an Excel sheet that contains check list for about 20 items , and
> that will be as a to-do note.
> Can anyone help me?
>
> Thanks in advance
>
> --
>
> ===*
> *
>
Try this Code :
this Code enable you to check the duplicate entry at the time of Data Entry
..
Private Sub Worksheet_Change(ByVal Target As Range)
Dim lngValueAs Long
Dim intICounter As Integer
Dim strMsg As String
lngValue = Target.Value
If Intersect(Target, Range("
Thanks Sam,
Could you please explain the method used ?
Regards
Rahul.
On Tue, Oct 4, 2011 at 8:59 PM, Sam Mathai Chacko wrote:
> Rahul,
>
> PFA the pivot
>
> Regards,
>
> Sam Mathai Chacko (GL)
>
> On Tue, Oct 4, 2011 at 6:59 PM, Rahul Garwad wrote:
>>
>> Hi Prince,
>>
>> As mentioned earlie
Try this :
Function ChangeFormat(dt As String) As Variant
If IsDate(dt) Then
ChangeFormat = Format(dt, "dd/mmm/")
Else
ChangeFormat = dt
End If
End Function
On Mon, Oct 3, 2011 at 4:01 PM, Sanjib Chatterjee <
chatterjee.kolk...@gmail.com> wrote:
> Dear Frie
Hi
Try a Function Like this to get the data.
='C:\Documents and Settings\HAPPY 2\Desktop\[Book1[Sheet1]]Sheet1'!A1
On Mon, Oct 3, 2011 at 2:18 PM, NOORAIN ANSARI wrote:
> Dear Rashid,
>
> Please try through below link, I hope it will be help to u..
>
> http://www.wikihow.com/Recover-a-Corrupt-E
Find the attache Sheet:
On Mon, Oct 3, 2011 at 12:34 PM, Sanjib Chatterjee <
chatterjee.kolk...@gmail.com> wrote:
> dear Sir,
>
> I am facing a problem in Excel. I like to put the dae value in excel in
> "dd/mm/" format.
> But like to get back the result in "dd-mmm-" format.
>
> is there
Hi
sort your Data and Insert A Coloum and insert this Function :
=Countif($A$1:A1,A1)
On Mon, Oct 3, 2011 at 11:48 AM, Suman wrote:
> Use this =countif(A:A,A2)>1 in conditional formating. Its compares all of
> the values in column A to the contents of cell A2 the condition is TRUE if
> there r m
Hi,
DashBoard is nothing More then a Understandable Presentation of Analys data
, it can contain Many Dynamic charts , Pivot table , Functions... Keep the
Simplicity of data presentation at the time to making a dashboard, Please
Visit this page to know more about DashBoards.
http://www.inetsoft.co
Dear legend,
Wish you all the best..
On Tue, Oct 4, 2011 at 12:14 AM, Ayush Jain wrote:
> Dear members,
>
> I am proud to share that I have been re-awarded the Micrososft MVP award in
> 2011. My deep thanks to each group member for all your support and
> contribution to this group.
> I keep sa
Thanks Ashish its working fine :)
On Tue, Oct 4, 2011 at 9:36 AM, ashish koul wrote:
> try something like this
>
> Sub create_ppts()
> Dim slidecount As Integer
> Dim slide As slide, PPSlide As slide
> Dim shp As Shape
> Dim ppres As Presentation, pp As Presentation
>
> Dim filepa
Not clear as to what you want. Pls provide sample sheet and urls and what you
need.
From: syed aliya raza hashim
Sent: Monday, October 03, 2011 11:03 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need Help
Can excel file such as reports be access from web or can be acccess as
What is the reason that you do not like my idea of filtering?
From: Mr excel
Sent: Tuesday, October 04, 2011 8:42 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Update sheets on Enter
any help from anybody please?
On Tue, Oct 4, 2011 at 6:29 PM, dguillett1 wrote:
I
It would be helpful if you would post examples of what you want
From: shaneallen
Sent: Tuesday, October 04, 2011 7:24 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Working out of Statistics on Exam Results URGENT
solution needed!
Hi
Good Day
I trust someone will be able to
any help from anybody please?
On Tue, Oct 4, 2011 at 6:29 PM, dguillett1 wrote:
> I, or some of the others can amend my code to do as desired. However,
> again, I suggest you try this where you simply use filters on ONE sheet.
>
> *From:* Mr excel
> *Sent:* Monday, October 03, 2011 11:56
Hi Prince,
As mentioned earlier, i need to it this format as in Column "AA" to
"AC" present in sheet below.
Thanks for your try.
Average of UGX=, Cndl, Close
Years dateTotal
1994Feb 978.75
Mar 1016.40
Apr 986.11
May 948.24
Jun
See if it helps you I did not create separate sheet, u just need to
select the students name and it will give you the details.
So no need to create the separate sheets..
Best Regards
Momin Siraj Ahmad
From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On B
I, or some of the others can amend my code to do as desired. However, again, I
suggest you try this where you simply use filters on ONE sheet.
From: Mr excel
Sent: Monday, October 03, 2011 11:56 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Update sheets on Enter
huhh.
Hi,
Try following code
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Dim sht As Worksheet
Dim shtname As String
If Target.HasFormula Then
For Each sht In ThisWorkbook.Sheets
If sht.Name <> ActiveSheet.Name And sht.Cells(Target.Row,
Ta
Hi
Good Day
I trust someone will be able to assist me with my quest to get the total
number of learners/students per code per subject in each class but
preferably for the whole grade in other words for all the classes in one
grade together
--
--
hi experts!
i am having a excel workbook, it contains 10 sheets
my query is "if i enter a one formula in first sheet in specific range
in one column that formula should be add in specific range in other
sheets at single time" is it possible
if any macro or macro sheet cna you send as soon as pos
I need also this VB Code
On Mon, Oct 3, 2011 at 4:41 AM, ChilExcel wrote:
> Urgent !!
> i Need VB lines codes for
>
> 2011/10/1 ChilExcel
>
>> hi
>>
>> i Need VB lines codes for
>> Alert MsgBox Pair duplicate entry in row
>>
>> Column D function account and duplicates alerts (NO Problem!
hi Noorain
congrats..!
On Oct 2, 9:14 am, Sam Mathai Chacko wrote:
> Fabulous work Noorain. You make a difference, and all of us in the
> forum appreciate your contribution. Carry on the excellent work.
>
> Sam Mathai Chacko (GL)
>
> On 10/2/11, suryaprasad...@gmail.com wrote:
>
> > Hip
hi Ayush congrats
On Oct 3, 11:44 pm, Ayush Jain wrote:
> Dear members,
>
> I am proud to share that I have been re-awarded the Micrososft MVP award in
> 2011. My deep thanks to each group member for all your support and
> contribution to this group.
> I keep saying that this forum is a great co
Hi all members,
I need an Excel sheet that contains check list for about 20 items , and that
will be as a to-do note.
Can anyone help me?
Thanks in advance
--
===*
*
*Ahmed Abu Al magd** Al emam***
General Accountant
*Al-Amana Technology Est. for Contracting*
I
try something like this
Sub create_ppts()
Dim slidecount As Integer
Dim slide As slide, PPSlide As slide
Dim shp As Shape
Dim ppres As Presentation, pp As Presentation
Dim filepath As String
Dim a()
filepath = "c:\"
a = Array("A", "B")
Set pp = ActivePresentation
For i = L
44 matches
Mail list logo
