$$Excel-Macros$$ Split Number into multiple cell

[ICWAI Help]

Hi Ashish,

could  you plese tell me the formula for Spliting number into multiple
cell appriciate fi  you have vba code
but it shouold be dynamics


12345 like 1  2   3   4   5  in multiple columnsa

-- 
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 be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ Opening All excel workbook one by one hen running the code

[ICWAI Help]

Hello Ashish,

i need a help regarding the open all the excel file one by one and
then running the macro.
regarding macro i will take care so please suggest me any code for
opening the all fiel

please dont suggest application.file search becouse i m using 2010 as
its wont work in that.

i dont know whts wrong with below code.


Sub test2()
Dim path As Variant
Dim excelfile As Variant
path = "C:\Documents and Settings\rjosh14\Desktop\inn\Check\"
excelfile = Dir(path & ("*.xls"))
Do While excelfile <> ""
Workbooks.Open path & "\" & excelfile, 0
'excelfile = Dir(path & ("*.xls"))
Loop
End Sub

-- 
FORUM RULES (934+ 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 be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Excel auto filter using criteria from Combobox items

[ICWAI Help]

Hi Noorin i cant share the workbook its higly confidential anyway just
a code help or link is enough for me.
is this below code is right let me know
Selection.AutoFilter Field:=16, Criteria1:=ctr1
Selection.AutoFilter Field:=27, Criteria1:=ctr2
Selection.AutoFilter Field:=15, Criteria1:=ctr3

On Oct 19, 4:52 pm, NOORAIN ANSARI  wrote:
> Dear ICWAI,
>
> Can you share Worksheet with group.
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
>
>
>
> On Wed, Oct 19, 2011 at 5:11 PM, ICWAI Help  wrote:
> > Hello everyone could anyone please let meknow the code for Excel auto
> > filter using criteria from Combobox items
> > i have 5 to 6 criteria from a combobox in form and  i need to extract
> > the data from excelsheet
> > if any link that also apprciated.
>
> > --
>
> > ---­---
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> >http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> >http://www.facebook.com/discussexcel- Hide quoted text -
>
> - Show quoted text -

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Excel auto filter using criteria from Combobox items

[ICWAI Help]

Hello everyone could anyone please let meknow the code for Excel auto
filter using criteria from Combobox items
i have 5 to 6 criteria from a combobox in form and  i need to extract
the data from excelsheet
if any link that also apprciated.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Get the Unique value from pivot table in combo box

[ICWAI Help]

Hello,

I have a pivot table which is dynamic which is going to be change
every time when i open the workbook
i want to get the unique value from pivot table field in combo box
add
item.


lets example :


my pivot table field is Agent name there are several agent who work
repetedly till 4 rows so i need to get the unique vallue in combo
box item


-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Get the Unique value from pivot table in combo box

[ICWAI Help]

Hello,

I have a pivot table which is dynamic which is going to be change
every time when i open the workbook
i want to get the unique value from pivot table field in combo box add
item.

lets example :

my pivot table field is Agent name there are several agent who work
repetedly till 4 rows so i need to get the unique vallue in combo
box item

PIVINT TBALE FIELD Agent:COMBOBOX DROUP DOWN
 
A
A
 
A
D
 
D
R
  D
  D
  D
  D
  R

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ UDF Function for conditoin formetting

[ICWAI Help]

Please find the attached file and give me the solution :)
if the perticuler cell value is 4 then next 4 coloumn cells in same row
shoudl be highleted .

On Tue, Aug 16, 2011 at 11:42 PM, dguillett1  wrote:

>   I did this VERY recently in another formum. Was it you?
> Right click sheet tab>view code>insert this
>
> Private Sub Worksheet_Change(ByVal Target As Range)
> Dim tr As Long
> tr = Target.Row
> Rows(tr).Borders(xlEdgeBottom).LineStyle = xlNone
> If Target.Column <> 1 Or Not IsNumeric(Target) Or _
> Len(Application.Trim(Target)) < 1 Then Exit Sub
> Range(Cells(tr, 2), Cells(tr, Target + 1)) _
> .Borders(xlEdgeBottom).LineStyle = xlContinuous
> End Sub
>
>  *From:* ICWAI Help 
> *Sent:* Tuesday, August 16, 2011 11:02 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ UDF Function for conditoin formetting
>
>   Please provide me UDF functino for below requirement
>
> example:)
>
> if the cell value is 4 then including active cell next 4 cell in a row
> should be higleted with color.
> ex
> if
> a1 is 4 then a1 ,b1 ,c 1, d 1, f 1 should be higleted.
>
> Thansk,
> Rakesh.
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


UDF.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ UDF Function for conditoin formetting

[ICWAI Help]

Please provide me UDF functino for below requirement

example:)

if the cell value is 4 then including active cell next 4 cell in a row
should be higleted with color.
ex
if
a1 is 4 then a1 ,b1 ,c 1, d 1, f 1 should be higleted.

Thansk,
Rakesh.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Any Group for MS access +Vb or simply Advance MS Acess

[ICWAI Help]

*Going forward please send me some pdf or online link which is helpfull for
Advance Access and Acess VB*
*please i dont need basic Acess :)*

On Fri, Jul 29, 2011 at 4:58 PM, XLS S  wrote:

> Yes, ofcourse
>
> On Fri, Jul 29, 2011 at 4:25 PM, Venkat CV  wrote:
>
>> Hi,
>>
>> You can post in this group it self .Some one will resolve your query..
>>
>> *Best Regards,*
>> *Venkat*
>> *Chennai*
>>   *
>> *
>>
>> On Fri, Jul 29, 2011 at 3:46 PM, ICWAI Help wrote:
>>
>>> HI Members,
>>>
>>> is there Any Group for MS access +Vb or simply Advance MS Acess so i cant
>>> jion that group also as i have keen intreast in thsi too.
>>>
>>> Thanks.
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>>
>>
>> --
>>   *
>> *
>> *
>> *
>>
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> .
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Date format

[ICWAI Help]

*right click on cell go to format go to custom format and then type as
DD/MM/*
*you will get it what you are expecting :)*
**
On Fri, Jul 29, 2011 at 7:14 PM, Paul Schreiner wrote:

>   Does Excel recognize the dd-mm- as a valid DATE?
>
> That is: Can you change the format to "long date" format
> and it automatically changes 29-07-2011 to "Friday, July 29, 2011"
>
> If so, then excel recognizes the string as a "date",
>
> Technically, there are two types of "dates"...
> 1) A string of characters that YOU interpret as a date.
> 2) A string of characters that EXCEL interprets as a date.
>
> If EXCEL thinks it is a date, you can DISPLAY it in any way you choose
> (almost)
>
> You can change the way an Excel date is DISPLAYED by:
>
> Right-click the cell, select Format Cells
> on the Date Category, the Type called "14-Mar-01" is the format you're
> looking for.
> Select it and Hit "ok".
>
> Or, you can select the Custom format, and use dd-mm-yy.
>
> If you CANNOT change it to a "long date", that means that Excel thinks of
> this
> as a text string, not a date...
>
> In THAT case, you have to listen to my "dissertation" on the nature of
> Excel Dates.
> and treat the value as any other text string and extract the values you
> wish to use.
>
> To avoid that, give the above a try and let us know if it takes care of it.
>
>
>
> *Paul*
>
> -
> *“Do all the good you can,
> By all the means you can,
> In all the ways you can,
> In all 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:* Ashish Khandelwal <4everash...@gmail.com>
> *To:* excel-macros@googlegroups.com
> *Sent:* Fri, July 29, 2011 7:55:11 AM
> *Subject:* $$Excel-Macros$$ Date format
>
> Hi,
>
> I have a date string in the format of dd-mm-. I want to change in the
> dd-mm-yy.
>
> The Output should be like 29-07-11
>
>
> Please help.
>
>
>
> Thanks & Regards,
>
> Ashish Khandelwal.
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Any Group for MS access +Vb or simply Advance MS Acess

[ICWAI Help]

HI Members,

is there Any Group for MS access +Vb or simply Advance MS Acess so i cant
jion that group also as i have keen intreast in thsi too.

Thanks.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Recover the VB password

[ICWAI Help]

HI Ashish,

i have updated the VB password for my excel file while but i am not able to
open now.could you please let me knwo is there any other way to open the
codes.in that.


Thansk,
ICWAI.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Fwd: Query

[ICWAI Help]

HI hari for below Query you can just do as F1&G1&H1 as much as u can..
if you want to use anysyble between then just use as F1&"-"&H1.

On Thu, Jul 28, 2011 at 6:49 PM, XLS S  wrote:

> Dear Hari,
>
> Use Concatenat Function or & operate..please find the attachment
>
>
>
> On Thu, Jul 28, 2011 at 5:20 PM, Hari  wrote:
>
>>
>>
>> -- Forwarded message --
>> From: Hari 
>> Date: 28 July 2011 17:13
>> Subject: Query
>> To: excel-macros@googlegroups.com
>>
>>
>> dear members,
>>
>> can any one solve my query with help of formula, i am very poor in MS
>> excel.
>>
>> find the attachement, reply at the earliest.
>>
>> Thanks in advance,
>>
>> have a nice day.
>>
>> --
>> Yours,
>>
>> Hari.
>>
>>
>>
>> --
>> Yours,
>>
>> Hari.
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> .
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Custom function in Excel

[ICWAI Help]

Save you all UDF in madule in xlms file.
you will get the help from excel editor.

On Thu, Jul 28, 2011 at 5:09 PM, Venkat CV  wrote:

> Hi Sandeep,
>
> Save your UDF function as a .XLA (or)XLAM and you may open and use it...
>
>
>
>  *Best Regards,*
> *Venkat*
> *Chennai*
>   On Thu, Jul 28, 2011 at 4:13 PM,  wrote:
>
>> Hi excel gurus,
>>
>> I am using excel 2007.I want to give all my custom excel function (UDF) a
>> felling like real function can it possible?
>>
>> I want to show the user all help to be prompt when they select the UDF.
>>
>> Thanks in advance.
>>
>> Sandeep Kr. Chhajer.
>>
>> Sent on my BlackBerry® from Vodafone
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
>   **
> *
> **
> *
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Reverse Vlookup

[ICWAI Help]

Use Sumproduct function ti will help you.
as manhy criteria you can put in brackets and get your desire result.
*SUMPRODUCT(($B$3:$B$21=E3)*$A$3:$A$21)*

On Thu, Jul 28, 2011 at 5:05 PM, Venkat CV  wrote:

>
> Hi Anil,
>
> Look Attached it will help u...
>
> *Best Regards,*
> *Venkat*
> *Chennai*
>
>   On Thu, Jul 28, 2011 at 4:16 PM, Anil Bhange <
> anil.bha...@tatacommunications.com> wrote:
>
>>  Hi All,
>>
>> ** **
>>
>> Could you help me with VB code for Reverse Vlookup function command where
>> we can lookup value from Right to Left.
>>
>> ** **
>>
>> Some similar to Vlookup but lookup from Right to Left.
>>
>> ** **
>>
>> Please give me a function code so that I can able to save this in Personal
>> workbook and use in all excel file.
>>
>> ** **
>>
>> ** **
>>
>> *Anil Bhange*
>>
>> *Business Planning & Management Reporting*
>> Financial Planning & Analysis,
>>
>> TATA Communications Ltd.
>> 6th Floor, B Wing,
>> Bandra Kurla Complex, Bandra (East),
>> India
>>
>> ** **
>>
>> ' Desk : + 91 22 6659 2320
>> | IP Phone : 51 2320 | Mobile :+ 91 90290 32123 
>>
>> anil.bha...@tatacommunications.com
>>
>> ** **
>>
>> ** **
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
>   *
> *
> *
> *
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Vba Code Required for Delete Entire Row

[ICWAI Help]

another way to delete simple just select the rows.
simple macro to understand.

*Sub deleterow()
Application.ScreenUpdating = False
Dim cell As Range
Set cell = Selection
For Each cell In Selection
If cell.Value = 0 Then
cell.EntireRow.Delete
End If
Next cell
End Sub

*
On Thu, Jul 28, 2011 at 4:59 PM, arpit rajput wrote:

> Thaks Daniel,
>
> your logic is super.
>
>
> On Thu, Jul 28, 2011 at 4:09 PM, Daniel  wrote:
>
>>  Hi,
>>
>> ** **
>>
>> Another way to do it :
>>
>> ** **
>>
>> Sub test()
>>
>> Dim rgRange As Range
>>
>> With Sheets("Report")
>>
>> Set rgRange = Range(.[A1], .Cells(.Rows.Count, 1).End(xlUp).Offset(,
>> 9))
>>
>> rgRange.AutoFilter 10, 0
>>
>> Set rgRange = rgRange.Offset(1).Resize(rgRange.Rows.Count - 1)
>>
>> Set rgRange = rgRange.SpecialCells(xlCellTypeVisible)
>>
>> rgRange.EntireRow.Delete
>>
>> .AutoFilter.Range.AutoFilter
>>
>> End With
>>
>> End Sub
>>
>> ** **
>>
>> Regards.
>>
>> Daniel
>>
>> ** **
>>
>> *De :* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *De la part de* arpit rajput
>> *Envoyé :* jeudi 28 juillet 2011 11:20
>> *À :* excel-macros@googlegroups.com
>> *Objet :* $$Excel-Macros$$ Vba Code Required for Delete Entire Row
>>
>> ** **
>>
>> Hi Experts,
>>
>>  
>>
>>  I want to remove entire row when each cell value =0 in column J see in
>> attached file.
>>
>> Anybody suggest me VBA code to delete all 0 value rows.
>>
>>  
>>
>> Thanks
>>
>> ARPIT KUMAR
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ need formula for find specif value based on multiple crteria

[ICWAI Help]

try sumproduct.

SUMPRODUCT((A2:A31=A35)*(B2:B31=B35)*C2:C31)

On Thu, Jul 28, 2011 at 11:57 AM, Venkat CV  wrote:

> Hi Mohan,
>
> If you want to get the data based on Multiple Criteria in 2007 You May Try
> Countifs,Sumifs,Averageifs
>
> *Best Regards,*
> *Venkat*
> *
> *
> *
> *
>
>  On Thu, Jul 28, 2011 at 8:38 AM, Mohanraj shunmugam <
> mohanraj2...@gmail.com> wrote:
>
>> dear team member,
>>
>>   i need formula for multiple criteria to find specfic value
>>
>> i here attach sample file
>> my question on sample file is
>> how to find fundvalue for date 15/07/2011 and fund id 20  need formula
>>
>> help me
>>
>> thanking you
>>
>> regards,
>> mohanraj s
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
>   *
> *
> *
> *
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ use of indirect function

[ICWAI Help]

Oops there is no attachement at all any way thansk for help :)

On Wed, Jul 27, 2011 at 7:11 PM, XLS S  wrote:

> Hey ICWAI,
>
> please find the attachment and try again with attachment
>
>
>
>
>
> On Wed, Jul 27, 2011 at 5:45 PM, ICWAI Help wrote:
>
>> Hi Noorin i have tireed my best but stilll not undeerstand the below point
>> could you please explain me
>> what is mean by this
>>
>> name range of below function is
>> getphoto--Formula-define name-then paste below formula
>> and put name range
>> =INDIRECT("Sheet4!B"&MATCH('Indirect Example 3'!$A$4,Sheet4!$A:$A,0))
>>
>>
>>   On Wed, Jul 27, 2011 at 9:23 AM, XLS S  wrote:
>>
>>> Hey,
>>>
>>> please find the below mention link
>>>
>>>
>>> http://www.jkp-ads.com/articles/ShowPicture00.asp
>>>
>>>
>>>
>>>
>>> On Tue, Jul 26, 2011 at 5:32 PM, ICWAI Help wrote:
>>>
>>>> Hi How the 3rd example sheet works or photo example sheet workds please
>>>> explain clearly..:)
>>>>
>>>>
>>>> On Tue, Jul 26, 2011 at 11:16 AM, sandeep chhajer <
>>>> chhajersand...@gmail.com> wrote:
>>>>
>>>>> Dear Noorain,
>>>>>
>>>>> I have gone through your attachment and find it of a graet help. I hope
>>>>> you wont mind to guide us in a *step by step* *action to be done* for
>>>>> your all four examples.
>>>>>
>>>>> Thanking you in advance.
>>>>>
>>>>>
>>>>>
>>>>> On 25 July 2011 23:14, NOORAIN ANSARI wrote:
>>>>>
>>>>>> Dear Neil,
>>>>>>
>>>>>> Please see attached sheet with Indirect function example
>>>>>>
>>>>>> --
>>>>>> Thanks & regards,
>>>>>> Noorain Ansari
>>>>>> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
>>>>>>
>>>>>>
>>>>>>   On Mon, Jul 25, 2011 at 9:04 PM, neil johnson <
>>>>>> neil.jh...@googlemail.com> wrote:
>>>>>>
>>>>>>> Hi All,
>>>>>>> Is indirect function is good function to make dashboard. Please
>>>>>>> explain about indirect function and provide me some example. how can i 
>>>>>>> use
>>>>>>> indirect function while to make dashboard.
>>>>>>>
>>>>>>> Thanks
>>>>>>>
>>>>>>> --
>>>>>>>
>>>>>>> --
>>>>>>> Some important links for excel users:
>>>>>>> 1. Follow us on TWITTER for tips tricks and links :
>>>>>>> http://twitter.com/exceldailytip
>>>>>>> 2. Join our LinkedIN group @
>>>>>>> http://www.linkedin.com/groups?gid=1871310
>>>>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>>>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>>>>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>>>>>
>>>>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>>>>>
>>>>>>> <><><><><><><><><><><><><><><><><><><><><><>
>>>>>>> Like our page on facebook , Just follow below link
>>>>>>> http://www.facebook.com/discussexcel
>>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>>
>>>>>> --
>>>>>> Some important links for excel users:
>>>>>> 1. Follow us on TWITTER for tips tricks and links :
>>>>>> http://twitter.com/exceldailytip
>>>>>> 2. Join our LinkedIN group @
>>>>>> http://www.linkedin.com/groups?gid=1871310
>>>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com

Re: $$Excel-Macros$$ use of indirect function

[ICWAI Help]

Hi Noorin i have tireed my best but stilll not undeerstand the below point
could you please explain me
what is mean by this

name range of below function is getphoto--Formula-define
name-then paste below formula and put name range
=INDIRECT("Sheet4!B"&MATCH('Indirect Example 3'!$A$4,Sheet4!$A:$A,0))


On Wed, Jul 27, 2011 at 9:23 AM, XLS S  wrote:

> Hey,
>
> please find the below mention link
>
>
> http://www.jkp-ads.com/articles/ShowPicture00.asp
>
>
>
>
> On Tue, Jul 26, 2011 at 5:32 PM, ICWAI Help wrote:
>
>> Hi How the 3rd example sheet works or photo example sheet workds please
>> explain clearly..:)
>>
>>
>> On Tue, Jul 26, 2011 at 11:16 AM, sandeep chhajer <
>> chhajersand...@gmail.com> wrote:
>>
>>> Dear Noorain,
>>>
>>> I have gone through your attachment and find it of a graet help. I hope
>>> you wont mind to guide us in a *step by step* *action to be done* for
>>> your all four examples.
>>>
>>> Thanking you in advance.
>>>
>>>
>>>
>>> On 25 July 2011 23:14, NOORAIN ANSARI  wrote:
>>>
>>>> Dear Neil,
>>>>
>>>> Please see attached sheet with Indirect function example
>>>>
>>>> --
>>>> Thanks & regards,
>>>> Noorain Ansari
>>>> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
>>>>
>>>>
>>>>   On Mon, Jul 25, 2011 at 9:04 PM, neil johnson <
>>>> neil.jh...@googlemail.com> wrote:
>>>>
>>>>> Hi All,
>>>>> Is indirect function is good function to make dashboard. Please explain
>>>>> about indirect function and provide me some example. how can i use 
>>>>> indirect
>>>>> function while to make dashboard.
>>>>>
>>>>> Thanks
>>>>>
>>>>> --
>>>>>
>>>>> --
>>>>> Some important links for excel users:
>>>>> 1. Follow us on TWITTER for tips tricks and links :
>>>>> http://twitter.com/exceldailytip
>>>>> 2. Join our LinkedIN group @
>>>>> http://www.linkedin.com/groups?gid=1871310
>>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>>>
>>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>>>
>>>>> <><><><><><><><><><><><><><><><><><><><><><>
>>>>> Like our page on facebook , Just follow below link
>>>>> http://www.facebook.com/discussexcel
>>>>>
>>>>
>>>>
>>>>
>>>>
>>>> --
>>>>
>>>> --
>>>> Some important links for excel users:
>>>> 1. Follow us on TWITTER for tips tricks and links :
>>>> http://twitter.com/exceldailytip
>>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>>
>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>>
>>>> <><><><><><><><><><><><><><><><><><><><><><>
>>>> Like our page on facebook , Just follow below link
>>>> http://www.facebook.com/discussexcel
>>>>
>>>
>>>
>>>
>>> --
>>> Regards,
>>> Sandeep Kumar Chhajer.
>>> Ph. no: 07498171901
>>>
>>>
>>>
>>>   --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.co

Re: $$Excel-Macros$$ use of indirect function

[ICWAI Help]

Hi How the 3rd example sheet works or photo example sheet workds please
explain clearly..:)

On Tue, Jul 26, 2011 at 11:16 AM, sandeep chhajer
wrote:

> Dear Noorain,
>
> I have gone through your attachment and find it of a graet help. I hope you
> wont mind to guide us in a *step by step* *action to be done* for your all
> four examples.
>
> Thanking you in advance.
>
>
>
> On 25 July 2011 23:14, NOORAIN ANSARI  wrote:
>
>> Dear Neil,
>>
>> Please see attached sheet with Indirect function example
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>> *http://noorain-ansari.blogspot.com/*
>>
>>
>>   On Mon, Jul 25, 2011 at 9:04 PM, neil johnson <
>> neil.jh...@googlemail.com> wrote:
>>
>>> Hi All,
>>> Is indirect function is good function to make dashboard. Please explain
>>> about indirect function and provide me some example. how can i use indirect
>>> function while to make dashboard.
>>>
>>> Thanks
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>>
>>
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> Regards,
> Sandeep Kumar Chhajer.
> Ph. no: 07498171901
>
>
>
>   --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Help Required Urgent :)

[ICWAI Help]

Thanks a lot Ashish its working perfectly

Regards,
Rakesh.

On Fri, Jul 8, 2011 at 10:54 AM, ashish koul  wrote:

> add this code to new workbook and run the macro and choose the csv file
>
> Option Compare Text
>
>
>
> Sub swa()
>
> Application.ScreenUpdating = False
> Application.DisplayAlerts = False
> Dim s As Workbook
> Dim i, j, k As Long
> Set s = Workbooks.Open(Application.GetOpenFilename)
> j = 1
> For i = 1 To s.Sheets(1).Range("a1048576").End(xlUp).Row
>
> s.Activate
> If s.Sheets(1).Cells(i, 1).Value = "TITLERIGHT" Then
> k = i
> s.Sheets(1).Rows(j & ":" & k).Copy
> ThisWorkbook.Activate
>  ThisWorkbook.Sheets.Add After:=Sheets(Sheets.Count)
> ActiveSheet.Range("a1").Select
>
> ActiveSheet.Paste
> j = i
>
> i = i + 1
>
> End If
>
>
> Next i
> ThisWorkbook.Sheets(4).Activate
>
> Application.ScreenUpdating = True
> Application.DisplayAlerts = True
>
> End Sub
>
>
> On Fri, Jul 8, 2011 at 3:49 AM, ICWAI Help wrote:
>
>> Hi Ashish,
>>
>> i have date in sheet its huge date i want the date between The row
>> highlighted *TITLE RIGHT should copy into new sheet*
>> *like *
>> **
>> *1, first select hte data between Two Title right and paste into new
>> sheet.*
>> *total we need to create 80 sheets as i have huge data.*
>> **
>> **
>> *Thanks,*
>> *Rakesh.*
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com <http://akoul.blogspot.com/>
> http://akoul.posterous.com/
> *akoul*.wordpress.com <http://akoul.wordpress.com/>
> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830>
>
>
> P Before printing, think about the environment.
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - June'11

[ICWAI Help]

Hey Ashish heartly Congrats To you .. :)
Thansk for everything Dear.

On Tue, Jul 5, 2011 at 3:06 PM, simplyali  wrote:

> Thanks Ashish for the Invite.. I have accepted the same...
> I would like to thank you million times for making me aware of this
> post
>
> On Jul 5, 10:29 am, Kal xcel  wrote:
> > Congratulation Ashish...You deserve it
> >
> > Kalyan
> >
> >
> >
> > On Mon, Jul 4, 2011 at 11:17 PM, Ahmed galal 
> wrote:
> > >  [image:
> > >
> http://tracking.technodesignip.com/?action=count&projectid=642&conten..]Congratulations
> > > *Ashish*, you deserve it.[image:
> > >
> http://tracking.technodesignip.com/?action=count&projectid=642&conten.
> .]
> >
> > > Best regards,
> >
> > > *Ahmed galal Mohamed*
> >
> > > Procurement Engineer
> >
> > > Head Office : SQUARE Engineering Firm
> > > Tel   :(202) 2402 8846
> > > Fax  :(202) 2405 0476
> > > Mobile :(010) 9 62 60 61
> > > Website :http://www.square.com.eg
> > > 31 Lebanon St. Mohandsen, Giza, Egypt
> >
> > >  --
> > > From: jainayus...@gmail.com
> > > Date: Mon, 4 Jul 2011 22:48:33 +0530
> > > Subject: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - June'11
> > > To: excel-macros@googlegroups.com
> >
> > >   Hello Everyone,
> >
> > > Ashish Koul has been selected as 'Most Helpful Member' for the month of
> > > June'11
> > > He has posted 53 posts in June 2011 and helped many people through his
> > > expertise. He has been consistent contributor to this excel forum and
> > > achieved this recognition from last seven months consecutively.This is
> > > really awesome. He is awarded Microsoft MVP 2011 award for his
> voluntary
> > > contribution.
> >
> > >Thanks to Rajan, Venkat and other folks for helping excel
> enthusiasts !!
> > > keep it up !!
> >
> > >Let see who becomes next MVP..
> >
> > >Keep posting.
> >
> > >  Regards
> > > Ayush Jain
> > > Group Manager
> >
> > > --
> >
> > >
> ---­---
> > > Some important links for excel users:
> > > 1. Follow us on TWITTER for tips tricks and links :
> > >http://twitter.com/exceldailytip
> > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
> >
> > > To post to this group, send email to excel-macros@googlegroups.com
> >
> > > <><><><><><><><><><><><><><><><><><><><><><>
> > > Like our page on facebook , Just follow below link
> > >http://www.facebook.com/discussexcel
> >
> > > --
> >
> > >
> ---­---
> > > Some important links for excel users:
> > > 1. Follow us on TWITTER for tips tricks and links :
> > >http://twitter.com/exceldailytip
> > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
> >
> > > To post to this group, send email to excel-macros@googlegroups.com
> >
> > > <><><><><><><><><><><><><><><><><><><><><><>
> > > Like our page on facebook , Just follow below link
> > >http://www.facebook.com/discussexcel- Hide quoted text -
> >
> > - Show quoted text -
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ and the Microsoft MVP award goes to Ashish Koul :)

[ICWAI Help]

OH Ashish,

I havent gone throuh the mail.
btw congrats buddy :)

Thanks

On Mon, Jul 4, 2011 at 10:07 PM, seraj alam  wrote:

> Hi Ashish,
>
> Many many congrats...
>
>
> With best wishesh,
> Seraj Alam
>
>
>
>
> On Mon, Jul 4, 2011 at 9:40 PM, Hari  wrote:
>
>> Thanks for getting the award. Even though, i am very new to this group,
>> I proudly wishes to keep this spirit high always,
>> Have a nice day
>>
>> with best wishes,
>>
>>
>> Regards,
>> Hari
>>
>> On 1 July 2011 21:25, Ayush  wrote:
>>
>>> Dear Group,
>>> I am extremely happy to share a good news with you. One of our dearest
>>> group member 'Ashish Koul' is awarded Microsoft MVP award on 1st July for
>>> his exceptional MS Excel skills and voluntary contribution.
>>> He is well deserving for the award and I am very happy and proud of his
>>> recognition. The guy has been top poster in the group from last 7-8 months.
>>>  Let see who becomes the next MVP from the group. The group has now
>>> three active MVPs.
>>>
>>> Dear Ashish,
>>> Many Many congratulations for the award.I am very proud of you to be part
>>> of this group.
>>> Keep your valuable contribution to the group. I wish your long
>>> association with this group.
>>> Cheers !!
>>> Best Regards,
>>> Ayush Jain
>>> Group Manager
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>>
>>
>> --
>> Yours,
>>
>> Hari.
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Help Urgent Please

[ICWAI Help]

its Not working getting the wrong emaild id s
Hi Ashish the formula which u have provieded its working somewht but "out 10
geeitn the id for 2 employees id "

Thanks,

On Tue, Jul 5, 2011 at 10:48 PM, PRAVESH KUMAR wrote:

> HI,
> i think solved your quetions.
> otherwise revert me.
> Regards
> Pravesh Kumar
>
> On 7/5/11, ICWAI Help  wrote:
> > Search the employee name in Colomn B and get the email id and should be
> > updated in Colomun C if any formula
> > or code pelase give it to me  I need to do with 1000 records even though
> I
> > will match afterwords
> > single single
> >
> > Note there wont be propper value or text u need to search with part of
> > emplyee name
> >
> > --
> >
> --
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> > http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials at http://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> >
> > To post to this group, send email to excel-macros@googlegroups.com
> >
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> > http://www.facebook.com/discussexcel
> >
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ help me urgent

[ICWAI Help]

USE indirect function ti will  help you

On Tue, Jul 5, 2011 at 2:25 PM, Rajan_Verma wrote:

>  *Try this*
>
> * *
>
> * *
>
> *Sub CompileSheet()*
>
> *Dim Sh As Worksheet*
>
> *Sheets.Add.Name  = "Compile"*
>
> *For Each Sh In ActiveWorkbook.Sheets*
>
> **
>
> *If Sh.Name <> "Compile" Then*
>
> *Sh.Activate*
>
> *ActiveSheet.UsedRange.Select*
>
> *Selection.Copy*
>
> *Sheets("Compile").Activate*
>
> *
> ActiveSheet.Range("A4").End(xlUp).Activate*
>
> *ActiveSheet.Paste*
>
> *End If*
>
> *Next*
>
> * *
>
> *End Sub*
>
> * *
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *ashish koul
> *Sent:* Tuesday, July 05, 2011 2:17 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ help me urgent
>
> ** **
>
> try this
>
>  
>
>
> http://akoul.blogspot.com/search/label/Merge%20data%20from%20multiple%20sheets%20to%20sheet1%20in%20same%20workbook
> 
>
> On Tue, Jul 5, 2011 at 11:12 AM, vijayajith VA 
> wrote:
>
> Hi, 
>
> ** **
>
> I have  30 to 40 excel sheets in one workbook..if i want to copy all the
> excel sheet data in one sheet . it takes time..
>
> ** **
>
> so is thr any macros for that . 
>
> ** **
>
> ** **
>
> Please help me
>
> ** **
>
> thanks in advance.
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
>
>
>
> -- 
>
> *Regards*
>
> * *
>
> *Ashish Koul*
>
> *akoul*.*blogspot*.com *
> http://akoul.posterous.com/*
>
> *akoul*.wordpress.com 
>
> My Linkedin Profile ***
> *
>
>  
>
> P Before printing, think about the environment.
>
>  
>
> ** **
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Two lookup value with sumproduct.

[ICWAI Help]

you simply a champ

On Tue, Jul 5, 2011 at 10:42 PM, ICWAI Help  wrote:

> thank you so much ashish its wrking now
>   On Tue, Jul 5, 2011 at 9:50 PM, ashish koul wrote:
>
>> try this
>>
>>
>> On Tue, Jul 5, 2011 at 7:54 PM, ICWAI Help wrote:
>>
>>> Hello Ashsih,
>>>
>>> COULD YOU PLEASE EXPLAIN ME WITH TWO LOOKUP VALUE THE SUMPRODUCT FUNCTION
>>>
>>> ITS URGENT PLESE HELP ME AS SOON AS POSSIBEL.
>>>
>>> THANKS,
>>> RAKESH.
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>>
>>
>> --
>> *Regards*
>> * *
>> *Ashish Koul*
>> *akoul*.*blogspot*.com <http://akoul.blogspot.com/>
>> http://akoul.posterous.com/
>> *akoul*.wordpress.com <http://akoul.wordpress.com/>
>> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830>
>>
>>
>> P Before printing, think about the environment.
>>
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Two lookup value with sumproduct.

[ICWAI Help]

thank you so much ashish its wrking now
On Tue, Jul 5, 2011 at 9:50 PM, ashish koul  wrote:

> try this
>
>
> On Tue, Jul 5, 2011 at 7:54 PM, ICWAI Help wrote:
>
>> Hello Ashsih,
>>
>> COULD YOU PLEASE EXPLAIN ME WITH TWO LOOKUP VALUE THE SUMPRODUCT FUNCTION
>> ITS URGENT PLESE HELP ME AS SOON AS POSSIBEL.
>>
>> THANKS,
>> RAKESH.
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com <http://akoul.blogspot.com/>
> http://akoul.posterous.com/
> *akoul*.wordpress.com <http://akoul.wordpress.com/>
> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830>
>
>
> P Before printing, think about the environment.
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Help Urgent Please

[ICWAI Help]

Search the employee name in Colomn B and get the email id and should be
updated in Colomun C if any formula
or code pelase give it to me  I need to do with 1000 records even though I
will match afterwords
single single

Note there wont be propper value or text u need to search with part of
emplyee name

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Copy of updated.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Two lookup value with sumproduct.

[ICWAI Help]

Hello Ashsih,

COULD YOU PLEASE EXPLAIN ME WITH TWO LOOKUP VALUE THE SUMPRODUCT FUNCTION
ITS URGENT PLESE HELP ME AS SOON AS POSSIBEL.

THANKS,
RAKESH.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


New Microsoft Office Excel Worksheet.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ need required for data validation value query

[ICWAI Help]

Please find the attached file.

Thanks,
Rakesh.
On Fri, Jul 1, 2011 at 5:49 PM, Markkim  wrote:

> I'm not sure if I understand what you want correctly.
>
>
> O2 cell in your sample file
>
> you can have the following formula
>
> =VLOOKUP(M2,$A$1:$B$56,2,0) * VLOOKUP(M2,Sheet2!$A$1:$B$56,2,0)
>
> then do autofill ..
>
> Is this what you want?
>
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Book5.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Pivot table - show pages as individual workbooks

[ICWAI Help]

Please attached the sheet or file we could help u then

On Thu, Jun 30, 2011 at 9:50 PM, crossy75  wrote:

> Hello again - and thanks for the last response, you guys are ace!
>
> right have now taken a lot of data relating to clients and have a
> pivot table, which when i show pages lists 30 worksheets with each one
> being a separate client and valuation.
>
> Is there a way instead of showing the pages as individual worksheets,
> as individual workbooks with the file name saved as which would be the
> tab name if you clicked on the 'show pages.' (ie from tab 'smith' &
> tab 'jones' to a file smith.xls with one tab ''smith' and another file
> 'jones.xls with one tab 'Jones')
>
> I think this might be a 3 stage process in shoing pages,
> then doing a loop to move the first sheet to a new workbook
> then saving it as the tab name
> closing the file
> then looping to do the same again till no more sheets are left in the
> main workbook
>
> if there is a smarter way please let me know.
>
> ta
>
> Simon
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ How To Concatenate the Cell without loosing the format

[ICWAI Help]

*="$"&ROUND(B3/1000,0)&" "&"GMRR"&""&"("&ROUND(D3,2)&"%"&""&"of the Plan)"*
*find the attached file and formula it will works .
*
On Thu, Jun 30, 2011 at 5:58 PM, Monu Tiwari  wrote:

> Awesome . thanks everyone !
>
>
> On Thu, Jun 30, 2011 at 3:14 PM, ankur  wrote:
>
>> hi ak
>> file is attached for reference
>> Have A Nice Time & Enjoy Life
>>
>> Regards:
>> CMA Ankur Pandey
>> (Someone Different)
>>
>> I'm not the best but i'm not like the rest~~
>>
>>
>>
>>  On Thu, Jun 30, 2011 at 3:10 PM, ankur  wrote:
>> > hi AK , use this formula, may it fullfill ur requirement use in F3
>> cell
>> > =TEXT((C3/1000),"$#,#00")&"K"&" GMRR ("&ROUND((E3*100),0)&" % of the
>> plan)"
>> >
>> > Have A Nice Time & Enjoy Life
>> >
>> > Regards:
>> > CMA Ankur Pandey
>> > (Someone Different)
>> >
>> > I'm not the best but i'm not like the rest~~
>> >
>> >
>> >
>> > On Thu, Jun 30, 2011 at 11:51 AM, Venkatesan c 
>> wrote:
>> >>
>> >> Hi Ak,
>> >>
>> >> Find attached your query resolved
>> >>
>> >> Best Regards,
>> >> Venkat
>> >>
>> >> On Thu, Jun 30, 2011 at 1:10 AM, Monu Tiwari 
>> wrote:
>> >>>
>> >>> Hi Experts,
>> >>>
>> >>>
>> >>>
>> >>> I want to concatenate the different cells without losing the format of
>> the
>> >>> cells. Please refer the excel sheet for more details.
>> >>>
>> >>> Thanking you in Advance.
>> >>>
>> >>>
>> >>>
>> >>> Regards,
>> >>>
>> >>> AK
>> >>>
>> >>> --
>> >>>
>> >>>
>> --
>> >>> Some important links for excel users:
>> >>> 1. Follow us on TWITTER for tips tricks and links :
>> >>> http://twitter.com/exceldailytip
>> >>> 2. Join our LinkedIN group @
>> http://www.linkedin.com/groups?gid=1871310
>> >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>> >>>
>> >>> To post to this group, send email to excel-macros@googlegroups.com
>> >>>
>> >>> <><><><><><><><><><><><><><><><><><><><><><>
>> >>> Like our page on facebook , Just follow below link
>> >>> http://www.facebook.com/discussexcel
>> >>
>> >>
>> >>
>> >> --
>> >>
>> >>
>> >>
>> >>
>> >> --
>> >>
>> --
>> >> Some important links for excel users:
>> >> 1. Follow us on TWITTER for tips tricks and links :
>> >> http://twitter.com/exceldailytip
>> >> 2. Join our LinkedIN group @
>> http://www.linkedin.com/groups?gid=1871310
>> >> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>> >>
>> >> To post to this group, send email to excel-macros@googlegroups.com
>> >>
>> >> <><><><><><><><><><><><><><><><><><><><><><>
>> >> Like our page on facebook , Just follow below link
>> >> http://www.facebook.com/discussexcel
>> >>
>> >
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just fo

Re: $$Excel-Macros$$ VBA Copy Comments Box (with photo)

[ICWAI Help]

Please attached the sheet.
so we can help you better

On Thu, Jun 30, 2011 at 6:29 AM, sswcharlie  wrote:

> Hi
>
> Have a photo in a comments  box in wb 2.  Also have a vlookup in
> another workbook WB1 to bring forward the text from the cell into
> WB2.  This works great.  I also want to bring forward the comment box
> in the same cell from WB2 into WB1.
>
> Would like to use vlookup function but I believe not possible.  With
> vba event, do I use a copy/paste special  macro, or is there a better
> method.
>
> Thanks
>
> Charlie
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Extract a comment and paste in adjacent cell

[ICWAI Help]

*Function GetComment(c As Range)
GetComment = c.Comment.Text
End Function

*
On Wed, Jun 29, 2011 at 11:52 AM, Vasant  wrote:

> Try this.
>
> Sub Test()
> Dim Rng as range
> Set Rng = ActiveSheet.Range("A1")
> Debug.Print Rng.Comment.Text
> End sub
>
> if you want to use it as a UDF
>
> Function GetComment(Rng as range)
> GetComment= Rng.Comment.Text
> End sub
>
>
> On Wed, Jun 29, 2011 at 9:31 AM, Heather  wrote:
>  > I would like to extract comments and paste it next to the cell.
> >
> > For example:
> > The comment in cell A1 would be pasted in B1
> > The comment in cell A2 would be pasted in B2
> > until the bottom row of the data.
> >
> > If this possible or does the fact that comments are objects prohibit
> > this?
> >
> > Any help is appreciated - I am trying to make sense of data where
> > comments were overused!
> >
> > Thanks!
> >
> > Heather
> >
> > --
> >
> --
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials at http://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> >
> > To post to this group, send email to excel-macros@googlegroups.com
> >
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> > http://www.facebook.com/discussexcel
> >
>
>
>
> --
> Regards
>
> Vasant
>
> skype Id: vasantjob
> vasant...@gmail.com
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Extract only 10 digit mobile number

[ICWAI Help]

Hi Ashish,

i have below code but i dont know whts the wrong with this.
please chekc and guide me thansk for you continues help.

Thanks,
Rakesh.
*Sub mobile()
Dim i As Integer
Dim strPath
Dim strFile
Dim UB
For i = 1 To 400
strPath = Cells(i, 1)
strFile = Split(strPath, ".")
UB = UBound(strFile)
Selection.Value = strFile(UB)
i = i + 1
Next i
End Sub*

On Fri, Jun 24, 2011 at 2:58 PM, Brajesh Kumar Porwal <
brajeshkumarpor...@gmail.com> wrote:

> Dear Expert,
>
>
>  I need your help because I have more data of Multiple format. I want
> extract only 10 digit mobile number.
>
> Please find enclose example file.
> --
> --
> One Team One Dream One Goal
>
> Warm Regards,
> Brajesh
> 7503020750
>
> Life is Very beautiful !!!
> ¨`•.•´¨) Always
> `•.¸(¨`•.•´¨) Keep
> (¨`•.•´¨)¸.•´ Smiling!
> `•.¸.•´.
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ solution to put data automtically

[ICWAI Help]

HI Ashish ,

could you please attached the sheet with below formula how it works.

Thansk,
Rakesh.

On Tue, Jun 21, 2011 at 8:35 AM, Subhash Yadav  wrote:

> Thanks a lot my friend
>
>
>
> On Wed, Jun 8, 2011 at 10:01 PM, ashish koul wrote:
>
>> issue = INDEX(E:E,SUMPRODUCT(MAX(($A$4:A10=A11)*ROW($A$4:A10))),0)
>>
>> reading  =INDEX(F:F,SUMPRODUCT(MAX(($A$4:A10=A11)*ROW($A$4:A10))),0)
>>
>>
>> On Wed, Jun 8, 2011 at 7:03 PM, Subhash Yadav  wrote:
>>
>>> Dear friends,
>>>
>>> I am having one sheet containing data for fuel issue.
>>>
>>> I want, if i put any asset code previous issue and previous reading
>>> should come from the latest present issue and present reading of same asset.
>>>
>>>
>>> In the attached sheet yellow cell date should come in yellow cell and
>>> magenta cell data should come in magenta cell.
>>>
>>> Please help me out.
>>>
>>>
>>> --
>>> Subhash Chand Yadav
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>>
>>
>> --
>> *Regards*
>> * *
>> *Ashish Koul*
>> *akoul*.*blogspot*.com 
>> http://akoul.posterous.com/
>> *akoul*.wordpress.com 
>> My Linkedin Profile 
>>
>>
>> P Before printing, think about the environment.
>>
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> Subhash Chand Yadav
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ small doubt help me.

[ICWAI Help]

Can some one please provide the VB code or somehitng automationi for all
this processure

On Mon, Jun 20, 2011 at 5:16 PM, Vasant  wrote:

> use copy, and then paste special with transpose
>
> On Mon, Jun 20, 2011 at 3:46 PM, kannan excel wrote:
>
>> Hi Guru
>>
>>
>> Pls help me i am waiting for your reply.
>>
>>
>> regards
>>
>> Kannan V
>> 9941077703
>> onechennaiproperty.com
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> Regards
>
> Vasant
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel