older containing all Files you want to
consolidate", vbCritical, "Browse"
End If
End If
Application.DisplayAlerts = False
Application.ScreenUpdating = True
End Sub
Please assist me.
Thanks
Manjunath
On Fri, Feb 21, 2014 at 6:43 AM, Manjunath Narayanappa <
manjunath
hanks
Manjunath
On Thu, Feb 20, 2014 at 4:40 PM, priti verma wrote:
> somthing like this?
>
> if you have date in 2nd column.it wil put all data of today,s date.
>
>
> On Wed, Feb 19, 2014 at 10:00 AM, Manjunath Narayanappa <
> manjunath.n1...@gmail.com> wrote:
&
Hi Experts,
How to extract data from multiple workbooks to one single workbook.
Thanks
Manjunath
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
Sir,
Can you please help me out with it
Thanks
Manjunath
On Mon, Feb 17, 2014 at 1:09 PM, Manjunath Narayanappa <
manjunath.n1...@gmail.com> wrote:
> Yeah i want that one...
> Can we do for Employee id
>
> Thanks
> Manjunath
>
>
> On Mon, Feb 17, 201
>
> PFA...
>
> warm regards,
>
>
> On Sun, Feb 16, 2014 at 10:43 PM, Manjunath Narayanappa <
> manjunath.n1...@gmail.com> wrote:
>
>> Hi Experts
>>
>> Could you please help me on it.
>> how to copy specific data from one workbook to another w
Hi Experts
Could you please help me on it.
how to copy specific data from one workbook to another workbook for
specific name using VBA
Thanks
Manjunath
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
HTH
On Wed, Jun 19, 2013 at 1:50 PM, Manjunath Narayanappa
mailto:manjunath.narayana...@aon.co.uk>> wrote:
Dear Experts,
Thanks , it was a sample data which was provided me... Usually there will be
more 500 to 1000 rows and every month I need to delete
Is there any macros automatically
+ F8 to run code
HTH
On Wed, Jun 19, 2013 at 12:32 PM, Manjunath Narayanappa
mailto:manjunath.narayana...@aon.co.uk>> wrote:
Dear sant,
Please find the sample attachment for your reference
For ex: There are 18 rows in the attachment , where I need to delete first 15
rows
Can we apply macros
Dear expert,
I have a spreadsheet where every month I need to delete more than 500 rows
manually. Is there any macros automatically data should get delete at end of
the month
Thanks
Manjunath
PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL
Aon
s. No offense, just saying.
Regards, Abhishek
On Thu, Jun 13, 2013 at 3:33 PM, Manjunath Narayanappa
mailto:manjunath.narayana...@aon.co.uk>> wrote:
Dear Priti,
Can we use conditional formatting for this
Thanks
Manjunath
From: excel-macros@googlegroups.com<mailto:excel-macros@go
Dear Priti,
Can we use conditional formatting for this
Thanks
Manjunath
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Manjunath Narayanappa
Sent: 13 June 2013 11:00
To: 'excel-macros@googlegroups.com'
Subject: RE: $$Excel-Macros$$ Report (n
more explanation would be great to give answer quickly,
do you need data validation or formula, can you explain last point specially ?
On Thu, Jun 13, 2013 at 1:16 PM, Manjunath Narayanappa
mailto:manjunath.narayana...@aon.co.uk>> wrote:
Dear Experts,
Can someone help me on the below.
Dear Experts,
I wanna create a spreadsheet, every 15 or 20 minutes it should pop up with
msgbox.
Is there anyway that we can create for every 15 or 20 minutes it should pop up
with msgbox but without running macros evry 15 or 20 minutes
For example : I have created for Good morning , Afternoo
Dear Expert,
Am not able to understand when & where to apply in code.
Can someone help me out on this
Data Type
Bytes
Used Range of Values
Boolean
2
True or False
Integer
2
-32,768 to 32,767
Long
4
-2,147,483,648 to 2,147,483,647
Single
4
-3.402823E38 to 1.401298E45
Double
8
-1.7
Thanks for the below link
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Lalit Mohan Pandey
Sent: 03 April 2013 05:58
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Macro-with example file
You can go through below links:
http://www.excel
http://vbadud.blogspot.in/2008/05/create-pivot-table-using-excel-vba.html
.
Enjoy
Team XLS
On Tue, Mar 26, 2013 at 5:51 PM, Manjunath Narayanappa
mailto:manjunath.narayana...@aon.co.uk>> wrote:
But every day i need to run report & update in fresh spreadsheet
Fro
are fixed then i think no need for create pivot-table on daily..
just refresh pivot daily ...
.
Enjoy
Team XLS
On Tue, Mar 26, 2013 at 3:42 PM, Manjunath Narayanappa
mailto:manjunath.narayana...@aon.co.uk>> wrote:
Dear Experts
Everyday I need to create pivot table t
17:24
To: excel-macros@googlegroups.com
Cc: gawlianil8...@gmail.com
Subject: Re: $$Excel-Macros$$ Pivot table
need more explanation
.
Enjoy
Team XLS
On Mon, Mar 25, 2013 at 6:00 PM, Manjunath Narayanappa
mailto:manjunath.narayana...@aon.co.uk>> wrote:
Dear Anil,
F
Dear Experts,
I have spreadsheet, in which I will be updating the data & i want same
information in new workbook
Can it be done with help of macros
Thanks
Manjunath
PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL
For Aon's standard conditions as
Dear Experts,
In a spreadsheet I have more than 1000 rows, in that I want to find duplicate
entries with the help of macros & row as to get highlighted
Thanks
Manjunath
PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL
For Aon's standard condition
hi prince,
As per VBA code entire data is getting deleted from sheet. Just want to delete
0(Zero) from the sheet.
Thanks
Manjunath
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Prince
Sent: 06 March 2013 13:26
To: excel-macros@googlegroups.com
Subject:
Dear Experts
I have disable SAVEAS option from excel
Thanks
Manjunath
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thr
Can some one help me on the below
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Manjunath Narayanappa
Sent: 05 March 2013 11:20
To: 'xlstime'
Cc: 'excel-macros@googlegroups.com'
Subject: RE: $$Excel-Macros$$Extract information
Yes
Yes
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Manjunath Narayanappa
Sent: 05 March 2013 11:18
To: 'excel-macros@googlegroups.com'
Subject: RE: $$Excel-Macros$$Extract information
Yes
From: excel-macros@googlegroups.com [mailto:ex
XLS
On Tue, Mar 5, 2013 at 4:25 PM, Manjunath Narayanappa
mailto:manjunath.narayana...@aon.co.uk>> wrote:
Hi Prince,
We update on daily basis on sheet1, for Monday to Friday of each individuals
I want same information to be calculated for entire week in sheet 2( total no
of Resolution , L
anjunath
From: Prince [mailto:prince141...@gmail.com]
Sent: 05 March 2013 11:04
To: excel-macros@googlegroups.com
Cc: 'Prince'; Manjunath Narayanappa
Subject: Re: $$Excel-Macros$$Extract information
So how calculation on sheet2 has done please explain. With an example.
Regards
Prince
O
: Prince [mailto:prince141...@gmail.com]
Sent: 05 March 2013 10:39
To: excel-macros@googlegroups.com
Cc: Manjunath Narayanappa
Subject: Re: $$Excel-Macros$$Extract information
Hi Manjunath,
Do you want to get the same information to be pasted on the sheet2 with same
information as it is on sheet1 or
Dear Experts,
In the above attachment, I have a data in Sheet1 in which we update on daily
basis.
With the help of macros, can I extract same information in sheet2 with one click
Thanks
Manjunath
PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL
Dear All,
Macros is like sea and I'm sitting in seashore just watching code like a water
waves
Not able to understand but still trying to learn some thing from it.
Can some one please provide spreadsheet on the below so that I can see that and
practices
Thanks
Manjunath
From: excel-macros@goo
Dear Experts,
I want to create time bar or time capture on Excel.
Please teach me how to create with the help of macro
Thanks
Manjunath
PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL
For Aon's standard conditions associated with this e-mail plea
Dear Abhi,
Please find the attached spreadsheet
Rather than input two different formula in two column . Can I get one formula.
Thanks
Manjunath
From: Abhishek Jain [mailto:abhishek@gmail.com]
Sent: 20 February 2013 09:41
To: Manjunath Narayanappa
Cc: excel-macros@googlegroups.com
Subject
greater than 2 = Red
Thanks
Manjunath
From: Abhishek Jain [mailto:abhishek@gmail.com]
Sent: 20 February 2013 08:59
To: Manjunath Narayanappa
Cc: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ conditional formatting
Check attached.
On Wed, Feb 20, 2013 at 2:18 PM, Manjunath Narayanappa
mail
this what you want?
On Wed, Feb 20, 2013 at 11:55 AM, Manjunath Narayanappa
mailto:manjunath.narayana...@aon.co.uk>> wrote:
Dear Expert,
I want to create conditional formatting for below information
Please help me on this
Minor (If Cell is =2 should show green &if cell is great than
Dear Expert,
I want to create conditional formatting for below information
Please help me on this
Minor (If Cell is =2 should show green &if cell is great than >2 should show
red)
Major(If Cell is > 0 red =0 green )
Thanks
Manjunath
PLEASE CONSIDER THE ENVIRO
Dear Expert,
I wanna learn basic macro, please anyone send me the ppt
Thanks
Manjunath
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Manjunath Narayanappa
Sent: 07 February 2013 15:52
To: 'excel-macros@googlegroups.com'
Subject: $$Excel-Macr
Dear Experts,
Can someone please provide me below ppt
Thanks
Manjunath
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Manjunath Narayanappa
Sent: 05 February 2013 10:30
To: 'excel-macros@googlegroups.com'
Subject: $$Excel-Macros$$ Macro
De
Dear Experts,
Can you please send me the advance excel & Macro ppt, it will be useful to learn
Thanks
Manjunath
PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL
For Aon's standard conditions associated with this e-mail please visit
http://www.aon.
At all the times you can,
To all the people you can,
As long as ever you can." - John Wesley
-
________
From: Manjunath Narayanappa
To: "excel-macros@googlegroups.com"
Sent: Mon, February 4, 2013 10:05:31 AM
Subject:
At all the times you can,
To all the people you can,
As long as ever you can." - John Wesley
-
________
From: Manjunath Narayanappa
To: "excel-macros@googlegroups.com"
Sent: Mon, February 4, 2013 10:05:31 AM
Subject:
Anyone can guide/assist me on this
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Manjunath Narayanappa
Sent: 04 February 2013 11:26
To: 'excel-macros@googlegroups.com'
Subject: $$Excel-Macros$$ Not receiving email from Google Groups "MS
Dear Experts,
One of my friend is not receiving any email from Google Groups "MS EXCEL AND
VBA MACROS" group.
Please assist
Thanks
Manjunath
PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL
For Aon's standard conditions associated with this e-m
Dear Ayush,
I have to click on this link every time to access group, I'm still confused
that i haven't become member of this group
On Saturday, July 23, 2011 5:50:06 PM UTC+5:30, Ayush Jain wrote:
>
> Hello everyone,
>
> Please adhere to below rules of the forum. You will be banned without
>
Dear Team,
Is there any online excel exam to get certified.
Thanks
Manjunath
PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL
For Aon's standard conditions associated with this e-mail please visit
http://www.aon.com/uk/en/email-footer/aon-uk-limit
ll the places you can,
At all the times you can,
To all the people you can,
As long as ever you can." - John Wesley
-
From: Manjunath Narayanappa
To: "excel-macros@googlegroups.com"
Sent: Mon, January 28, 2
Dear Experts
Thanks to all,
Please find the attachment, please advise in case if we have K508 ,F508, E508,
A508 in rows but in same column B
I have highlighted in red.
Regards
Manjunath
PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL
For Aon's
sorry to miss spell your name
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Manjunath Narayanappa
Sent: 29 January 2013 10:14
To: 'excel-macros@googlegroups.com'
Subject: RE: $$Excel-Macros$$ Extract information from excel
Dear Gawli Ali,
I&#
$ Extract information from excel
Pl see the attached sheet.
Why to write too much formula if you want only 8digits alpha.
Warm Regards,
Gawli Anil
On Mon, Jan 28, 2013 at 9:54 PM, Manjunath Narayanappa
mailto:manjunath.narayana...@aon.co.uk>> wrote:
Thank you very much Ashish, its wor
=MID(B2&" ",FIND("K508",B2&" "),FIND(" ",B2&" ",FIND("K508",B2&"
"))-FIND("K508",B2&" "))
On Mon, Jan 28, 2013 at 8:41 PM, Manjunath Narayanappa
mailto:manjunath.narayana...@aon.c
Dear Team,
In above attachment I have a data from which I want to extract only the
highlighted information
For Eg K5024454
Thanks
Manjunath
PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL
For Aon's standard conditions associated with this e-mail
@googlegroups.com
Cc: Manjunath Narayanappa; Prince
Subject: Re: FW: $$Excel-Macros$$ need formula Highlight
Hi Manjunath,
See below pdf. I hope it will help you.
http://ide20.com/upload/ModuleAE/Lesson01.pdf
http://ide20.com/upload/ModuleAE/Lesson02.pdf
http://ide20.com/upload/ModuleAE/Lesson03.pdf
Dear Prince,
I'm keen to learn this. please teach me.
Thanks
Manjunath
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Manjunath Narayanappa
Sent: 18 January 2013 08:09
To: 'excel-macros@googlegroups.com'
Cc: 'Prince'
Subje
Dear Prince,
Thank you very much. Can you please teach me how to execute on 2007 excel
Await your assistance
Regards
Manjunath
From: Prince [mailto:prince141...@gmail.com]
Sent: 17 January 2013 16:32
To: excel-macros@googlegroups.com
Cc: Manjunath Narayanappa
Subject: Re: FW: $$Excel-Macros
Dear Prince,
Thank you very much. Can you please teach me how to execute on 2007 excel
Await your assistance
Regards
Manjunath
From: Prince [mailto:prince141...@gmail.com]
Sent: 17 January 2013 16:32
To: excel-macros@googlegroups.com
Cc: Manjunath Narayanappa
Subject: Re: FW: $$Excel-Macros
Dear all,
Please can I get macro for below requests
Regards
Manjunath
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Manjunath Narayanappa
Sent: 17 January 2013 08:47
To: 'excel-macros@googlegroups.com'
Subject: $$Excel-Macros$$ need formula
Dear Expert,
Good afternoon have a nice day :)
I have a data in the attached spreadsheet, automatically data in B column
should get highlighted when there is a duplicate or repeated entry.
Please help me on this.
Thanks
Manjunath
PLEASE CONSIDER THE ENVIRONM
Hi Prince,
Thank you so much.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Prince
Sent: 07 January 2013 16:18
To: excel-macros@googlegroups.com
Cc: Manjunath Narayanappa
Subject: Re: $$Excel-Macros$$ Re: Keen to more Learn
Hi Manjunath,
Here is
Thank you prince…..
I'm looking for Lookup function
[cid:image001.png@01CDEFE9.B0D749D0]
Thanks
Manjunath
From: Prince [mailto:prince141...@gmail.com]
Sent: 11 January 2013 09:10
To: excel-macros@googlegroups.com
Cc: Manjunath Narayanappa
Subject: Re: $$Excel-Macros$$ Lookup
Hi Manj
Dear All,
How to use Lookup in Excel Worksheet.
I need to know the formulas.
Thanks
Manjunath
PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL
For Aon's standard conditions associated with this e-mail please visit
http://www.aon.com/uk/en/email-fo
Dear All,
I wanna learn more Advance Excel & share the knowledge to others, please send
me the link or PPT, So that I can refer to learn.
Thanks
Manjunath
PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL
For Aon's standard conditions associated wi
Dear All,
I have date format as 190410, Can I get date format like 19/04/10.
Is there any function can be used. please assist me
190410
70510
40610
60710
220910
101210
80211
240211
140311
80711
180811
31011
7
160112
70312
Regards
Manjunath
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
Dear Expert
I want my friends to join this
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
Hi experts,
I want to calculate no of workdays and excludes holiday
For examples 24/12/2012 to 28/12/2012 and exclude 25th & 26 th as holiday
I tried using =Networkdays but I was able to no of working days
Please help me to Exclude holiday.
Thanks
Manjunath
P
Hi experts,
I want to calculate no of workdays and excludes holiday
For examples 24/12/2012 to 28/12/2012 and exclude 25th & 26 th as holiday
I tried using =Networkdays but I was able to no of working days
Please help me to Exclude holiday.
Thanks
Manjunath
PL
Dear Expert,
Looking forward for the below humble request
Thanks
Manjunath
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Manjunath Narayanappa
Sent: 06 December 2012 14:51
To: 'excel-macros@googlegroups.com'
Cc: 'schreiner_p...@a
Dear Expert,
I'm keen to learn many things on excel but I don't have proper guide line like
assignment or example to work out.
Can you please provide if you have anything's. So that I can improve my excel
skill
Thanks
Manjunath
PLEASE CONSIDER THE ENVIRONMENT
Hearty Congratulation Paul..
With the help of expertise. I started teaching Basic Excel to my friends
Thanks
Manjunath
From: Ayush Jain
Sender: excel-macros@googlegroups.com
Date: Mon, 3 Dec 2012 23:58:06 +0530
To: excel-macros
ReplyTo: excel-macros@googlegroups.
l the people you can,
As long as ever you can." - John Wesley
-
____
From: Manjunath Narayanappa
To: "excel-macros@googlegroups.com"
Sent: Thu, November 29, 2012 10:57:38 AM
Subject: RE: $$Excel-Macros$$ Remove highl
: $$Excel-Macros$$ Remove highlighted number
Hi,
You can also use
=REPLACE(A1,3,2,"")
On Thu, Nov 29, 2012 at 8:17 PM, Manjunath Narayanappa
mailto:manjunath.narayana...@aon.co.uk>> wrote:
Dear Experts.
In a spreadsheet there are more than 80 policy for example below. I want to
Dear Experts.
In a spreadsheet there are more than 80 policy for example below. I want to
remove 3rd & 4th for below entries
Examples - PH1106220. I want to remove highlighted one
PH1106220
AK0721911
AG0600641
AK0915631
AK1015631
AK1015631
AK0915631
AK0721911
AK0915631
Thanks
Manjunath
___
t;
Please Consider the environment. Please don't print this e-mail unless you
really need to.
On Wed, Nov 28, 2012 at 5:26 PM, Manjunath Narayanappa
mailto:manjunath.narayana...@aon.co.uk>> wrote:
One of my friend wanna join this Group but I donna how to add him.
--
Join official Fac
Dear Experts,
One of my friend wanna join this Group but I donna how to add him.
Thanks
Manjunath
PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL
For Aon's standard conditions associated with this e-mail please visit
http://www.aon.com/uk/en/emai
se the TRIM function to, at J3 you use the formula:
= TRIM (C3)
Complete copy of the column J, dragon to column E you choose Paste Special
Value, and click the OK button.
2012/11/23 Manjunath Narayanappa
mailto:manjunath.narayana...@aon.co.uk>>
Dear Sir/Madam,
Thank you so much but in few e
reference), and it will
remove space from the cell value and then use function remove duplicate which
is available in data->remove Duplicates.
--- On Thu, 11/22/12, Manjunath Narayanappa
wrote:
From: Manjunath Narayanappa
Subject: $$Excel-Macros$$ REmove duplicate entries
To: "exce
Dear Sir/Madam,
Thank you so much but in few entries there is a space so it doesn’t show as
duplicate entry
Regards
Manjunath
From: Orlando José Mézquita Fabián [mailto:orlando.mezqu...@gmail.com]
Sent: 23 November 2012 02:27
To: excel-macros@googlegroups.com
Cc: Manjunath Narayanappa
Subject
Hi Prince,
>From all the column…
Thanks
Manjunath
From: Prince [mailto:prince141...@gmail.com]
Sent: 22 November 2012 16:27
To: excel-macros@googlegroups.com
Cc: Manjunath Narayanappa
Subject: Re: REmove duplicate entries
Hi Manjunath,
Do you want to remove duplicates from C column only
Dear Experts,
I'm keen to learn basic Macro, please send me training guide or manual
Thanks
Manjunath
PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL
For Aon's standard conditions associated with this e-mail please visit
http://www.aon.com/uk/en/
Dear Experts,
I keen to learn basic Macro, please send me training guide or manual
Thanks
Manjunath
PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL
For Aon's standard conditions associated with this e-mail please visit
http://www.aon.com/uk/en/em
78 matches
Mail list logo
