date:20110808

Re: $$Excel-Macros$$ sumproduct issue

2011-08-08 Thread Shiek Peer Mohd

Hi Noorain,

It works.  Thanks a lot for your support

On Tue, Aug 9, 2011 at 12:13 PM, NOORAIN ANSARI wrote:

> Dear Peer Mohd,
>
> Please see attached sheet
>
> On Tue, Aug 9, 2011 at 11:46 AM, Shiek Peer Mohd wrote:
>
>>
>> Hi Experts,
>>
>> I have the issues in using the multiple criteria in sumproduct. Sample
>> file attached.
>>
>>
>> Regards,
>>
>> Shiek
>>
>> --
>>
>> --
>> 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
>>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
> *http://noorain-ansari.blogspot.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,

Shiek

-- 
--
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 needed. compare two wxcel files

2011-08-08 Thread Rajan_Verma

See if it helps , but Scop of this macro is only only Worksheet.

 

Sub matchValue()

' Short CUt Key Shift + CTRL + M

Application.ScreenUpdating = False

 

Dim F_range As Range

Dim S_range As Range

On Error Resume Next

Set F_range = Application.InputBox("Please Select 1st Range", , , , , , , 8)

Set S_range = Application.InputBox("Please Select 2nd Range", , , , , , , 8)

Dim r As Integer

Dim c As Integer

r = F_range.Rows.Count

c = F_range.Columns.Count

Dim cc As Integer

Dim rc As Integer

For cc = 1 To c

For rc = 1 To r

'For Each cell In F_range.Cells

If F_range.Cells(rc, cc).Value = S_range.Cells(rc, cc).Value Then

'F_range.Cells(rc, cc).Interior.ColorIndex = 32

'S_range.Cells(rc, cc).Interior.ColorIndex = 32

Else

F_range.Cells(rc, cc).Font.Bold = True

F_range.Cells(rc, cc).Color = 2

F_range.Cells(rc, cc).Interior.ColorIndex = 31

S_range.Cells(rc, cc).Font.Bold = True

S_range.Cells(rc, cc).Interior.ColorIndex = 31

End If

'Next cell

Next rc

Next cc

Application.ScreenUpdating = True

Range("A1").Select

End Sub

 

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rajendra prasad yadav
Sent: Tuesday, August 09, 2011 12:01 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Help needed. compare two wxcel files

 

Hi friends,

 

I am not good at excel. I have a requirement now, Can some one please give
the macro to compare two worksheets in diferent workbooks and display the
differences.

 

Regards,

Rajendra

8147524172

-- 

--
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 needed. compare two wxcel files

2011-08-08 Thread dguillett1

You need to post examples, etc.

From: Rajendra prasad yadav 
Sent: Monday, August 08, 2011 1:31 PM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Help needed. compare two wxcel files

Hi friends,

I am not good at excel. I have a requirement now, Can some one please give the 
macro to compare two worksheets in diferent workbooks and display the 
differences.

Regards,
Rajendra
8147524172
-- 
--
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$$ Question

2011-08-08 Thread dguillett1

Homework?

-Original Message- 
From: XLS S

Sent: Monday, August 08, 2011 3:38 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Question

Q-1 )Can I write VBA code to protect or unprotect my VB Project?
Q-2) Why does Excel have two macro languages?
Q-3) Can I lock cells such that only specific users can modify them?
Q-4) When I enter a value, it appears with two decimal places. For
example, when I enter 123 it shows up as 1.23. What's wrong?
Q-5) How can I increase the number of columns in a worksheet?

--
--
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$$ populate consecutive numbers in discrete rows with other text

2011-08-08 Thread dguillett1

Right click sheet tab>view code>insert this. Now when you put  149 in col A 
col B will populate


Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row < 2 Or Target.Column <> 1 Then Exit Sub
Target.Offset(, 1) = "#" & Target & " Story"
End Sub

-Original Message- 
From: deej109

Sent: Monday, August 08, 2011 1:37 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ populate consecutive numbers in discrete rows with 
other text


I have two adjacent columns of consecutive numbers, spaced several
rows apart each.  For example:

 A  B
149 | #149 Story


150 | #150 Story


I know how to create consecutive numbers in column A.  Is there a way
to automatically populate the numbers in column B?  Is there a way to
combine text and function commands?

Thanks very much!
deej109

--
--
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$$ Code need to Transfer Excel worksheets labelled 1 to X to Word.

2011-08-08 Thread dguillett1

What do you need to do in Word that you can't do in excel?

-Original Message- 
From: skyping1

Sent: Monday, August 08, 2011 12:07 PM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Code need to Transfer Excel worksheets 
labelled 1 to X to Word.

Anyone have any ideas on this please?

On Aug 3, 9:50 pm, Kevin gray  wrote:

Please see attachments

Date: Wed, 3 Aug 2011 07:48:44 +0530
Subject: Re: $$Excel-Macros$$ Code need to Transfer Excel worksheets 
labelled 1 to X to Word.

From: venkat1@gmail.com
To: excel-macros@googlegroups.com

Hi
There is No attachment.

Best Regards,Venkat
Chennai

On Tue, Aug 2, 2011 at 10:41 PM, skyping1  
wrote:

Please find attached files...hope you can help

On Aug 2, 10:23 am, "Rajan_Verma"  wrote:

> Please Attached  a sample file

> -Original Message-
> From: excel-macros@googlegroups.com 
> [mailto:excel-macros@googlegroups.com]

> On Behalf Of skyping1
> Sent: Tuesday, August 02, 2011 12:07 AM
> To: MS EXCEL AND VBA MACROS
> Subject: $$Excel-Macros$$ Code need to Transfer Excel worksheets 
> labelled 1

> to X to Word.

> I have many Excel files in a folder which all have labelled Worksheets
> from 1 to X where X is always an integer.

> Most of the files have about 10 worksheets, and these can have both
> text and pictures in.

> I have searched, for some code (to no avail and through quite a few
> forums!!), that would copy the content of the worksheets in numeric
> order to a blank Word document.

> I am using 2010, and ideally would like to select any number of files
> and even perhaps the order(!) that they can be pasted into Word.

> Hope you guys can help.

> --
> --- 
>  -

> --
> 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 
> linkhttp://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

--

--

--- 
 ---

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

 Start.xlsm
971KViewDownload

 finish.docx
154KViewDownload

--
--
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

<><><><><><><><><><><><><><><

Re: $$Excel-Macros$$ Making Excel Project Unviewable

2011-08-08 Thread Venkat CV

*Hi ,*
*
*
*Look below link it may help u*

http://www.excelforum.com/excel-programming/392497-project-is-unviewable.html

http://support.microsoft.com/kb/q229499/

*Best Regards,*
*Venkat *
*Chennai*

On Tue, Aug 9, 2011 at 3:30 AM, hanumant shinde wrote:

> Hi how to make project unviewable i.e. when we do Alt+F11 and try to expand
> the
> code it shows below pop up.
>
> i have a file which if i try to open shows pop up saying "project is
> unviewable"
>
> i tried to send the file but i cannot attach it. i think this is 1 more
> functionality.
> that excel file gets generated by some exe.
>
> --
>
> --
> 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$$ populate consecutive numbers in discrete rows with other text

2011-08-08 Thread Venkat CV

*
Hi ,

Try Below see if helps else please attach some sample workbook

**="#"&A1&" "&"Story"*
*Best Regards,*
*Venkat *
*Chennai*

On Tue, Aug 9, 2011 at 12:07 AM, deej109  wrote:

> I have two adjacent columns of consecutive numbers, spaced several
> rows apart each.  For example:
>
>  A  B
> 149 | #149 Story
>
>
> 150 | #150 Story
>
>
> I know how to create consecutive numbers in column A.  Is there a way
> to automatically populate the numbers in column B?  Is there a way to
> combine text and function commands?
>
> Thanks very much!
> deej109
>
> --
>
> --
> 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$$ Email : Paste Object

2011-08-08 Thread ashish koul

check this

http://www.rondebruin.nl/notes.htm




On Mon, Aug 8, 2011 at 3:23 PM, Chandra Shekar  wrote:

> Hi,
>
> Please find attached file I have code to send mail to lotus notes id. Here
> I need range from A1:E6 pasted as object as in the body of notes as shown in
> attached file.
>
> Please let me know how to do this thanks!
>
> Thanks,
>
> Chandra Shekar B
>
> --
>
> --
> 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

$$Excel-Macros$$ Making Excel Project Unviewable

2011-08-08 Thread hanumant shinde

Hi how to make project unviewable i.e. when we do Alt+F11 and try to expand the 
code it shows below pop up. 

i have a file which if i try to open shows pop up saying "project is unviewable"

i tried to send the file but i cannot attach it. i think this is 1 more 
functionality.
that excel file gets generated by some exe.

-- 
--
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$$ Question

2011-08-08 Thread XLS S

Q-1 )Can I write VBA code to protect or unprotect my VB Project?
Q-2) Why does Excel have two macro languages?
Q-3) Can I lock cells such that only specific users can modify them?
Q-4) When I enter a value, it appears with two decimal places. For
example, when I enter 123 it shows up as 1.23. What's wrong?
Q-5) How can I increase the number of columns in a worksheet?

-- 
--
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 needed. compare two wxcel files

2011-08-08 Thread Rajendra prasad yadav

Hi friends,

I am not good at excel. I have a requirement now, Can some one please give
the macro to compare two worksheets in diferent workbooks and display the
differences.

Regards,
Rajendra
8147524172

-- 
--
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$$ populate consecutive numbers in discrete rows with other text

2011-08-08 Thread deej109

I have two adjacent columns of consecutive numbers, spaced several
rows apart each.  For example:

  A  B
149 | #149 Story


150 | #150 Story


I know how to create consecutive numbers in column A.  Is there a way
to automatically populate the numbers in column B?  Is there a way to
combine text and function commands?

Thanks very much!
deej109

-- 
--
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$$ Multiple Range Pivot Table

2011-08-08 Thread mahamadou lawali

I think a "One point lesson" on this add in would be highly welcome.
Thanks

On Aug 8, 10:27 am, Anil Bhange 
wrote:
> Hi Rajan,
>
> Still I am not able to do with this addin, find below screen preview
> [cid:image001@01CC5605.69E40C40]
>
> Regards,    Anil Bhange
> IP Phone - 512320 | Mobile - 90290 32123
>
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
> Behalf Of Rajan_Verma
> Sent: Monday, August 08, 2011 04:48 PM
> To: excel-macros@googlegroups.com
> Subject: RE: $$Excel-Macros$$ Multiple Range Pivot Table
>
> Sorry For that.. I have attached Another One File.
> Add this addins and Press Ctrl+Shift+P
>
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
> Behalf Of Anil Bhange
> Sent: Monday, August 08, 2011 12:20 PM
> To: excel-macros@googlegroups.com
> Subject: RE: $$Excel-Macros$$ Multiple Range Pivot Table
>
> Ctrl + Shift + P is not working in attached file
>
> Regards,    Anil Bhange
> IP Phone - 512320 | Mobile - 90290 32123
>
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
> Behalf Of Rajan_Verma
> Sent: Sunday, August 07, 2011 07:00 PM
> To: excel-macros@googlegroups.com
> Subject: RE: $$Excel-Macros$$ Multiple Range Pivot Table
>
> Add this add in and Press Shift+Ctrl + P and Follow the step
> Hope it will helps
>
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
> Behalf Of Anil Bhange
> Sent: Sunday, August 07, 2011 5:24 PM
> To: excel-macros@googlegroups.com
> Subject: $$Excel-Macros$$ Multiple Range Pivot Table
>
> Hi All,
>
> Is there any way where I could able to create Pivot table with multiple 
> ranges and able to use all the columns of all ranges as like normal Pivot 
> Table.
>
> I know the Multiple Range Consolidation but in this you can only play around 
> with Row, Column & Data and not with all column heading.
>
> Please let me know if any facility available in excel.
>
> 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 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 
> linkhttp://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 
> linkhttp://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 
> linkhttp://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

Re: $$Excel-Macros$$ Code need to Transfer Excel worksheets labelled 1 to X to Word.

2011-08-08 Thread skyping1

Anyone have any ideas on this please?

On Aug 3, 9:50 pm, Kevin gray  wrote:
> Please see attachments
>
> Date: Wed, 3 Aug 2011 07:48:44 +0530
> Subject: Re: $$Excel-Macros$$ Code need to Transfer Excel worksheets labelled 
> 1 to X to Word.
> From: venkat1@gmail.com
> To: excel-macros@googlegroups.com
>
> Hi
> There is No attachment.
>
> Best Regards,Venkat
> Chennai
>
> On Tue, Aug 2, 2011 at 10:41 PM, skyping1  wrote:
>
> Please find attached files...hope you can help
>
> On Aug 2, 10:23 am, "Rajan_Verma"  wrote:
>
>
>
>
>
>
>
>
>
> > Please Attached  a sample file
>
> > -Original Message-
> > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
>
> > On Behalf Of skyping1
> > Sent: Tuesday, August 02, 2011 12:07 AM
> > To: MS EXCEL AND VBA MACROS
> > Subject: $$Excel-Macros$$ Code need to Transfer Excel worksheets labelled 1
> > to X to Word.
>
> > I have many Excel files in a folder which all have labelled Worksheets
> > from 1 to X where X is always an integer.
>
> > Most of the files have about 10 worksheets, and these can have both
> > text and pictures in.
>
> > I have searched, for some code (to no avail and through quite a few
> > forums!!), that would copy the content of the worksheets in numeric
> > order to a blank Word document.
>
> > I am using 2010, and ideally would like to select any number of files
> > and even perhaps the order(!) that they can be pasted into Word.
>
> > Hope you guys can help.
>
> > --
> > --- 
> > -
> > --
> > 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 
> > linkhttp://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
>
> --
>
> --
>
> --- 
> ---
>
> 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
>
>  Start.xlsm
> 971KViewDownload
>
>  finish.docx
> 154KViewDownload

-- 
--
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$$ Information

2011-08-08 Thread Venkat CV

Hi Lucky,

First you have to determine your requirement...and then you have decide
which software is convinent to perform

the Operation it's if Windows based application you may Try VB,

If web projects try in JAVA ,.NET like that...Same DB Like SQL,ORACLE,OR MS
Access..

*Best Regards,*
*Venkat *
*Chennai*
*
*

On Sat, Aug 6, 2011 at 7:52 PM, lucky  wrote:

> DEAR SIR,
> i am new meber in your group. Iam learning  in BCA
> finel year pls give me information
>  what is the process developing the software & which language we use
> software.
>
> --
>
> --
> 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 4

2011-08-08 Thread vijayajith VA

Thank you raj  for your help



On Sun, Aug 7, 2011 at 8:04 PM, Rajan_Verma wrote:

>  *See this Function :*
>
> * *
>
> *if sum of any Two cell in selected Range is Equal to Given Value in
> Second Parameter of Function then Function will Return the Address of that
> Two Cells, here Flag will be True if condition will match, *
>
> *Next if Condition will not match Flag will be False, then I  check again
>  if Flag is False then I Assign another Value to Function Name,*
>
> * *
>
> *Flag is nothing more then Simplify the programming ..*
>
> * *
>
> * *
>
> *Function GetAddress(Rng As Range, Value1 As Integer) As String*
>
> *Dim Flag As Boolean*
>
> *Dim cell As Range*
>
> *Dim cell2 As Range*
>
> *Flag = False*
>
> * *
>
> *For Each cell In Rng*
>
> *For Each cell2 In Rng*
>
> *If cell.Value + cell2.Value = Value1 Then*
>
> *Flag = True*
>
> *GetAddress = cell2.Address & "|" & cell.Address*
>
> *Exit For*
>
> *End If*
>
> *Next cell2*
>
> *Next cell*
>
> **
>
> *If Flag = False Then*
>
> *GetAddress = "No Match Found"*
>
> *End If*
>
> *End Function*
>
> * *
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *vijayajith VA
> *Sent:* Sunday, August 07, 2011 7:22 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ help 4
>
> ** **
>
> Hi Excel gurus.
>
> ** **
>
> Can anybody explain  me on  below code ?
>
> Just i wanted to kn About flag with examples ..Please dont scold me for
> asking this type of silly questions ... i am still learing 
>
> ** **
>
> ** **
>
> ** **
>
> Thnks 
>
> For Each cell In rng
> flag = 0
>For t = LBound(List) To UBound(List)
>   If cell.Value = List(t) Then
>
>flag = 1
>Exit For
>End If
>Next
>
>If flag = 0 Then
>List(i) = cell.Value
>i = i + 1
>End If
> Next
> UniqueList = List(Pos)
> End Function 
>
> --
>
> --
> 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$$ Information

2011-08-08 Thread Rajan_Verma

Read this Small Book

http://devedzic.fon.rs/publications/SEKE-Handbook-2.pdf

-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of lucky
Sent: Saturday, August 06, 2011 7:53 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Information

DEAR SIR,
 i am new meber in your group. Iam learning  in BCA
finel year pls give me information
  what is the process developing the software & which language we use
software.

-- 

--
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$$ Urgent Help Graph

2011-08-08 Thread Rajan_Verma

See if it helps

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Sundarvelan N
Sent: Monday, August 08, 2011 4:01 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Urgent Help Graph

 

Hi Friends,

 

I need one help.

 

I have 5 to 6 graphs in a sheet. On clicking a combo box respective graph
should pop up. Please help me.


Thanks

N.Sundarvelan 

9600160150

 

-- 

--
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


Book4.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

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

2011-08-08 Thread Venkat CV

Hi Sundarvelan ,

Look attached it May help u...

 *Best Regards,*
*Venkat *
*Chennai*


On Mon, Aug 8, 2011 at 4:01 PM, Sundarvelan N  wrote:

> Hi Friends,
>
> I need one help.
>
> I have 5 to 6 graphs in a sheet. On clicking a combo box respective graph
> should pop up. Please help me.
> Thanks
> N.Sundarvelan
> 9600160150
>
> --
>
> --
> 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


Graphs Select.xlsm
Description: Binary data

RE: $$Excel-Macros$$ While Using Vlookup Insted of Zero need Blanks...

2011-08-08 Thread Rajan_Verma

See if it helps

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Venkat CV
Sent: Monday, August 08, 2011 11:37 AM
To: Google
Subject: $$Excel-Macros$$ While Using Vlookup Insted of Zero need Blanks...

 

Dear All,

 

Find attached query regarding While Using Vlookup Insted of Zero need
Blanks


Best Regards,

Venkat 

Chennai

 

 

 

 

-- 

--
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


Copy of Vlookup Insted of o need Blanks.xls
Description: MS-Excel spreadsheet

RE: $$Excel-Macros$$ urgent macro or template r eq

2011-08-08 Thread Rajan_Verma

See if it helps

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Sara Lee
Sent: Monday, August 08, 2011 12:32 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ urgent macro or template r eq

 

 i have a table in excel  like below


volumeships   parameter savings
1x   20   T1200
2x   25   L  1500
3X   67   T 1400


i need a macro or a form or template where user is asked to enter volume or
parameter and then excel should output the corresponding savings and ships
values fo

for example enter the volume 

if user enters the volume 1x, then excel should return the output in
columnar form as follows

For 1x 

ships   20
savings  1200

besides the above columns i would be adding other columns. So the macro or
form should ask the user to enter any of the input values/columns.  please
explain me how i would modify the 
macro to input other columns.  If  user enters
one of the input values as blank or null , then it should still extract the
output based on other parameter. for example if user does not enter any
value for volume and enters T for parameter,

the output should be

1x   

ships 20 
savings 1200

3x

ships  67
saving 1400

please advise




-- 

--
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


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

$$Excel-Macros$$ Urgent Help Graph

2011-08-08 Thread Sundarvelan N

Hi Friends,

I need one help.

I have 5 to 6 graphs in a sheet. On clicking a combo box respective graph
should pop up. Please help me.
Thanks
N.Sundarvelan
9600160150

-- 
--
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$$ Re: assistance needed; open to pay a fees

2011-08-08 Thread Sara Lee

Thank You so much. It is a great start. You are gwonderful!!!.   Do i have
to keep the source sheet (data) in the same file as the macro? or can i
seperate them and put them in different files but in a common folder ?

On Sun, Aug 7, 2011 at 10:29 PM, ashish koul  wrote:

>
> try this
>
> we can make few changes in it
>
> On Sun, Aug 7, 2011 at 10:47 PM, Sara Lee  wrote:
>
>> Hi Ashish
>>
>> i think you got me wrong. user does not have to enter new values. he will
>> select one of the values from the table i sent you.
>>
>> excel will  ask for the volume , the user will enter 1X , then the excel
>> should return the rest of row information for 1X in column form ... For
>> example corresponding to 1x, the savings could be 100,000,  scenario no
>> could  be 1RR  so o/p will be
>>
>> savings10
>> scenario no   1RR
>> locationhebron ky
>>
>> am i clear?
>>  no addition of data, just the excel should extract data from this table
>> based on user inupts in the Columnar form like above
>>
>>
>>
>> ideal inputs that user is asked to enter 1) volume  2) no of
>> locations  3) no of consolidations   4) parmeters 5) scenario
>>
>> outputs--- savings, damage( i will add this and other column in the table)
>>
>> Excel should be able to extract the output even if the user enters one of
>> the inputs and none of the other four..
>>
>> please advise
>>
>>
>> On Sun, Aug 7, 2011 at 10:19 AM, ashish koul wrote:
>>
>>> hi try this
>>>
>>>
>>> i have created a user form  go to macro run it it will show the user form
>>>  to enter the value then you can change the
>>> column names accordingly also u can ad text boxes , etc.
>>>
>>> use fill down option to copy the formula from above cell.
>>>
>>>
>>> if you are not able to do it tell me
>>>
>>> volume  - which col a, b , or c,etc
>>>
>>> location
>>>
>>> building
>>>
>>> if any formula need to copy from above  cell  " for which columns then"
>>>
>>>
>>>
>>>
>>>
>>> On Sun, Aug 7, 2011 at 6:20 PM, Sara Lee  wrote:
>>>
 hello

 i have the table in the below format and  4 columns as below  in excel

 volumelocation   builds   saving



 Now i want the user to be prompted for three values which will be
 volume, location, builds and the excel should give the user corresponding
 savings and the o/p should be in *vertical format* with all the inputs.
 o/p should be

 volume: [ value entered by user]
 location:[ value entered by user]
 builds:[ value entered by user]
 saving: corresponding value in the table for that row of inputs

 is there a template or a macro or a dashboard... can you pls hlep.

 thanks


 same thing;;; above is simplified


 On Sun, Aug 7, 2011 at 8:27 AM, Sara Lee  wrote:

> Hi Ashish
>
> I am attaching a table  which has all the inputs.  i need a macro /
> or a template/buttons in excel where
> the user is asked  to enter the following input
>
> Scneario NO:  user will enter either 1 , or 2 or 3 --- any value
> from column A
>
> once he enters the value, the o/p should be following in the below
> format one below the other for whatever scenario he or she enters
>
> volume : excel should get the value from column d
> # of location : similarly from column m
> inbound consolidation:
> parmeters
> savings :
>
>
> there might be other columns that i might be adding to the table, if i
> have to get other columns generated in ouput, could you also please 
> instruct
> me on how to do that
>
> Please advise ASAP.
>
> Thanks
>
>
>
>
> On Mon, Aug 1, 2011 at 11:46 PM,  wrote:
>
>> ** Is it in excel or access send me will let u know
>>
>> Sent on my BlackBerry® from Vodafone
>> --
>> *From: * Sara Lee 
>> *Date: *Mon, 1 Aug 2011 23:42:42 -0400
>> *To: *ashish koul
>> *Subject: *Re: assistance needed; open to pay a fees
>>
>> Ashish
>>
>> Would you have time within next 9- 10 hrs need to link up a couple
>> of tables and need to add a column in the table.must be half an hour
>> work for you... Shall i send it ? please let me know ASAP
>>
>> On Mon, Aug 1, 2011 at 2:01 AM, ashish koul wrote:
>>
>>> Hi Sara ,
>>>
>>> Hope you are doing well.
>>>
>>> I am working full time with CSC India.  Money is not an issue i would
>>> like to solve any of ur query without any charges..
>>>
>>>  As i work full time with CSC so can't assure you to send the
>>> solution at the same time.
>>>
>>>
>>> Please feel free to send any excel query on my mail will try to solve
>>> asap.
>>>
>>> In case if i will not be having time to solve ur problem will let u
>>> know.
>>>
>>> Regards
>>>
>>> Ashish Koul
>>>
>>>
>>> On

Re: $$Excel-Macros$$ While Using Vlookup Insted of Zero need Blanks...

2011-08-08 Thread Venkat CV

Dear Ashish,

WorkingThank you

Dear Noorain,

Ashish's formula WorkingThanks for your try.

*Best Regards,*
*Venkat *
*Chennai*
*
*

On Mon, Aug 8, 2011 at 12:33 PM, ashish koul  wrote:

> IF(NOT(ISERROR(VLOOKUP(I3,$B$3:$C$14,2,0))),IF(VLOOKUP(I3,$B$3:$C$14,2,0)="","",VLOOKUP(I3,$B$3:$C$14,2,0)),"Not
> Found")
>
>
> On Mon, Aug 8, 2011 at 12:22 PM, Venkat CV  wrote:
>
>> Dear Noorain,
>>
>> Thanks for your Try...
>> The Below Formula is working for Cell is Blank...
>>
>> But If cell Value is 0 That's the case not working...
>>
>> If Cell is 0 and also Coming Blank...It should Come has a 0
>>
>> *Best Regards,*
>> *Venkat *
>> *Chennai*
>>
>> On Mon, Aug 8, 2011 at 11:43 AM, NOORAIN ANSARI > > wrote:
>>
>>> Dear Venkat,
>>>
>>> Please try.
>>>
>>> =IF(VLOOKUP(I11,$B$3:$C$14,2,0)=0,"",VLOOKUP(I11,$B$3:$C$14,2,0))
>>>
>>> --
>>> Thanks & regards,
>>> Noorain Ansari
>>> *http://noorain-ansari.blogspot.com/*
>>>
>>> On Mon, Aug 8, 2011 at 11:37 AM, Venkat CV wrote:
>>>
 Dear All,

 Find attached query regarding While Using Vlookup Insted of Zero need
 Blanks

 *Best Regards,*
 *Venkat *
 *Chennai*
 *
 *
 *
 *


 --

 --
 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
>>
>
>
>
> --
> *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

Re: $$Excel-Macros$$ Fwd: कविता : जो मुरझाये ना कभी वो कवल है दोस्ती.(Happy Freindship Day)

2011-08-08 Thread NOORAIN ANSARI

Dear Seraj,

Please don't keep in loop of excel-macros group's mail in chain mail.
This group is dedicated for only Excel,Macro and Access.


Thanks & regards,
Noorain Ansari

2011/8/7 seraj alam 

>
>
>
>
> जो मुरझाये ना कभी वो कवल है दोस्ती.
> दिल के पवित्र ख्यालों की पहल है दोस्ती.
> दोस्ती दोस्तों के दम से निभाई जाती है,
> मिले आप जैसे दोस्त तो सफल है दोस्ती.
> खुदगर्ज दोस्त हो तो गन्दी नाली है दोस्ती,
> सच्चे  दोस्त के खातिर गंगाजल है दोस्ती.
> रिश्तों में सबसे ऊँचा दर्जा है दोस्ती का,
> थोड़ी शोख,थोड़ी नटखट, थोड़ी चंचल है दोस्ती.
> बसता है खुदा यारों सच्चे दोस्तों के दिल में,
> कही गीता,कही कुरान तो कही बाईबल है दोस्ती.
> कविता :
> --
> Thanks & regards,
> Noorain Ansari
> *http://noorain-ansari.blogspot.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
>



-- 
Thanks & regards,
Noorain Ansari
*http://noorain-ansari.blogspot.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

$$Excel-Macros$$ Fwd: कविता : जो मुरझाये ना कभी वो कवल है दोस्ती.(Happy Freindship Day)

2011-08-08 Thread seraj alam

जो मुरझाये ना कभी वो कवल है दोस्ती.
दिल के पवित्र ख्यालों की पहल है दोस्ती.
दोस्ती दोस्तों के दम से निभाई जाती है,
मिले आप जैसे दोस्त तो सफल है दोस्ती.
खुदगर्ज दोस्त हो तो गन्दी नाली है दोस्ती,
सच्चे  दोस्त के खातिर गंगाजल है दोस्ती.
रिश्तों में सबसे ऊँचा दर्जा है दोस्ती का,
थोड़ी शोख,थोड़ी नटखट, थोड़ी चंचल है दोस्ती.
बसता है खुदा यारों सच्चे दोस्तों के दिल में,
कही गीता,कही कुरान तो कही बाईबल है दोस्ती.
कविता :
-- 
Thanks & regards,
Noorain Ansari
*http://noorain-ansari.blogspot.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
<>

Re: $$Excel-Macros$$ While Using Vlookup Insted of Zero need Blanks...

2011-08-08 Thread NOORAIN ANSARI

Dear Venkat try it
=IF(OR(VLOOKUP(F3,$B$3:$C$14,2,0)=0,VLOOKUP(F3,$B$3:$C$14,2,0)=""),"",VLOOKUP(F3,$B$3:$C$14,2,0))

On Mon, Aug 8, 2011 at 12:22 PM, Venkat CV  wrote:

> Dear Noorain,
>
> Thanks for your Try...
> The Below Formula is working for Cell is Blank...
>
> But If cell Value is 0 That's the case not working...
>
> If Cell is 0 and also Coming Blank...It should Come has a 0
>
> *Best Regards,*
> *Venkat *
> *Chennai*
>
> On Mon, Aug 8, 2011 at 11:43 AM, NOORAIN ANSARI 
> wrote:
>
>> Dear Venkat,
>>
>> Please try.
>>
>> =IF(VLOOKUP(I11,$B$3:$C$14,2,0)=0,"",VLOOKUP(I11,$B$3:$C$14,2,0))
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>> *http://noorain-ansari.blogspot.com/*
>>
>>   On Mon, Aug 8, 2011 at 11:37 AM, Venkat CV wrote:
>>
>>> Dear All,
>>>
>>> Find attached query regarding While Using Vlookup Insted of Zero need
>>> Blanks
>>>
>>> *Best Regards,*
>>> *Venkat *
>>> *Chennai*
>>> *
>>> *
>>> *
>>> *
>>>
>>>
>>> --
>>>
>>> --
>>> 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
>



-- 
Thanks & regards,
Noorain Ansari
*http://noorain-ansari.blogspot.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

Re: $$Excel-Macros$$ While Using Vlookup Insted of Zero need Blanks...

2011-08-08 Thread ashish koul

IF(NOT(ISERROR(VLOOKUP(I3,$B$3:$C$14,2,0))),IF(VLOOKUP(I3,$B$3:$C$14,2,0)="","",VLOOKUP(I3,$B$3:$C$14,2,0)),"Not
Found")

On Mon, Aug 8, 2011 at 12:22 PM, Venkat CV  wrote:

> Dear Noorain,
>
> Thanks for your Try...
> The Below Formula is working for Cell is Blank...
>
> But If cell Value is 0 That's the case not working...
>
> If Cell is 0 and also Coming Blank...It should Come has a 0
>
> *Best Regards,*
> *Venkat *
> *Chennai*
>
> On Mon, Aug 8, 2011 at 11:43 AM, NOORAIN ANSARI 
> wrote:
>
>> Dear Venkat,
>>
>> Please try.
>>
>> =IF(VLOOKUP(I11,$B$3:$C$14,2,0)=0,"",VLOOKUP(I11,$B$3:$C$14,2,0))
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>> *http://noorain-ansari.blogspot.com/*
>>
>> On Mon, Aug 8, 2011 at 11:37 AM, Venkat CV  wrote:
>>
>>> Dear All,
>>>
>>> Find attached query regarding While Using Vlookup Insted of Zero need
>>> Blanks
>>>
>>> *Best Regards,*
>>> *Venkat *
>>> *Chennai*
>>> *
>>> *
>>> *
>>> *
>>>
>>>
>>> --
>>>
>>> --
>>> 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
>



-- 
*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

RE: $$Excel-Macros$$ Multiple Range Pivot Table

2011-08-08 Thread Anil Bhange

Hi Venkat,

Actually I need the facility where I could able to select multiple ranges as 
per my requirement, and able to generate the report based on all ranges columns.

Regards,Anil Bhange
IP Phone - 512320 | Mobile - 90290 32123

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Venkat CV
Sent: Monday, August 08, 2011 12:25 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Multiple Range Pivot Table

Hi Anil,

for the Below filejust hit the Create Pivot Table button  Pivot will be 
Generated automatically...

Best Regards,
Venkat
Chennai


On Mon, Aug 8, 2011 at 12:20 PM, Anil Bhange 
mailto:anil.bha...@tatacommunications.com>> 
wrote:
Ctrl + Shift + P is not working in attached file

Regards,Anil Bhange
IP Phone - 512320 | Mobile - 90290 32123

From: excel-macros@googlegroups.com 
[mailto:excel-macros@googlegroups.com] On 
Behalf Of Rajan_Verma
Sent: Sunday, August 07, 2011 07:00 PM

To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Multiple Range Pivot Table

Add this add in and Press Shift+Ctrl + P and Follow the step
Hope it will helps

From: excel-macros@googlegroups.com 
[mailto:excel-macros@googlegroups.com] On 
Behalf Of Anil Bhange
Sent: Sunday, August 07, 2011 5:24 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Multiple Range Pivot Table

Hi All,

Is there any way where I could able to create Pivot table with multiple ranges 
and able to use all the columns of all ranges as like normal Pivot Table.

I know the Multiple Range Consolidation but in this you can only play around 
with Row, Column & Data and not with all column heading.

Please let me know if any facility available in excel.


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



--




--
--
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

<><><><><><><><><><><><><><><><><

Re: $$Excel-Macros$$ sumproduct issue

RE: $$Excel-Macros$$ Help needed. compare two wxcel files

Re: $$Excel-Macros$$ Help needed. compare two wxcel files

Re: $$Excel-Macros$$ Question

Re: $$Excel-Macros$$ populate consecutive numbers in discrete rows with other text

Re: $$Excel-Macros$$ Code need to Transfer Excel worksheets labelled 1 to X to Word.

Re: $$Excel-Macros$$ Making Excel Project Unviewable

Re: $$Excel-Macros$$ populate consecutive numbers in discrete rows with other text

Re: $$Excel-Macros$$ Email : Paste Object

$$Excel-Macros$$ Making Excel Project Unviewable

$$Excel-Macros$$ Question

$$Excel-Macros$$ Help needed. compare two wxcel files

$$Excel-Macros$$ populate consecutive numbers in discrete rows with other text

Re: $$Excel-Macros$$ Multiple Range Pivot Table

Re: $$Excel-Macros$$ Code need to Transfer Excel worksheets labelled 1 to X to Word.

Re: $$Excel-Macros$$ Information

Re: $$Excel-Macros$$ help 4

RE: $$Excel-Macros$$ Information

RE: $$Excel-Macros$$ Urgent Help Graph

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

RE: $$Excel-Macros$$ While Using Vlookup Insted of Zero need Blanks...

RE: $$Excel-Macros$$ urgent macro or template r eq

$$Excel-Macros$$ Urgent Help Graph

$$Excel-Macros$$ Re: assistance needed; open to pay a fees

Re: $$Excel-Macros$$ While Using Vlookup Insted of Zero need Blanks...

Re: $$Excel-Macros$$ Fwd: कविता : जो मुरझाये ना कभी वो कवल है दोस्ती.(Happy Freindship Day)

$$Excel-Macros$$ Fwd: कविता : जो मुरझाये ना कभी वो कवल है दोस्ती.(Happy Freindship Day)

Re: $$Excel-Macros$$ While Using Vlookup Insted of Zero need Blanks...

Re: $$Excel-Macros$$ While Using Vlookup Insted of Zero need Blanks...

RE: $$Excel-Macros$$ Multiple Range Pivot Table

30 matches

Site Navigation

Mail list logo

Footer information