Re: $$Excel-Macros$$ Need your help

[Ashish Kumar]

Dear Kartik,

Please elaborate more.



On 03/01/2014, karthik N  wrote:
> Dear Friends
>
> Please find the attached file.
>
> Please help..
>
> *Regards*
> karthik.N
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE  : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate 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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ Need your help

[Sanjay Kumar Maurya]

Hi All,

I want to join this group.

-- 
***Thanks
Sanjay Kumar Maurya*

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate 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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Need your help

[Paul Schreiner]

I have a "solution" that I use.
I place most of the files in network locations, so they are backed up regularly.
Where necessary, SHORCUTS are created to utilize these files. 
It has some limitations, since I could not use the Group Policy approach (thank 
you I.T.)

It consists of (4) files. 
---
File #1) I have a simple text file called pctime.txt that is in the format:
Day|  Date    | IN    |   OUT
Mon|01/02/2012|||Holiday
Tue|01/03/2012|07:10:00 AM|04:20:00 PM
Wed|01/04/2012|07:10:00 AM|04:05:00 PM
Thu|01/05/2012|07:00:00 AM|04:05:00 PM
Fri|01/06/2012|07:10:00 AM|03:35:00 PM

It is located in a Network Folder, but can be placed anywhere. 
---
File #2) is the "Login" file:  LogIn.vbs
A shortcut to this file is placed in the Startup Folder so that it executes 
whenever Windows STARTS.
(note, this does NOT run if the computer is "locked" and a password is used to 
unlock the computer)
This file makes an entry into File #1 unless a previous exists. 
---
File #3) is the "Logout" file.
After making the appropriate entry in File #1, this file CURRENTLY opens a web 
page used for updating a company time sheet.
But since my computer must remain logged in so that nightly jobs can run, it no 
longer loggs off.
However, I'm sure I have an older version that forces a reboot.
---
File #4) is an excel Workbook.
This workbook contains all weeks for the current year.
Setting the first workday of the year automatically resets the dates for the 
rest of the year.
When opened, this workbook opens File #1 and updates the start/stop time for 
missing cells.
---

If you feel that this technique is suitable, I will "clean up" my files and 
send 
them to you.


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: Mangesh Vimay 
To: excel-macros@googlegroups.com
Sent: Mon, August 13, 2012 10:35:43 AM
Subject: Re: $$Excel-Macros$$ Need your help

Hi Paul/Friends, 

I would like to use this concept for my personal computer. I knew very well 
that 
It is going to be tough job but as many experts are part of this group, I hope 
someone would definitely try to get answer. 
Let me know if you need more information on same.
Please find the attached sheet that can be use as start up sheet to solve the 
problem.


On Mon, Aug 13, 2012 at 7:41 PM, Paul Schreiner  wrote:

I've worked through quite a bit of this.
>Spent MANY hours trying to work it out.
>
>There's LOTS of things to consider.
>
>#1.. is this for personal use, or for many people in an office?
>1a)  If it is an office, is there an I.T. department that controls PC and 
>Windows configuration?
>
>Windows has a "Group Policy" that allows you to create login/logouts scripts 
>for 
>Windows.
>Since my work environment has an I.T. Department that controlls our system 
>configurations,
>I could not utilize this method. (They locked out the Group Policy Editor)
>
>Instead, I created a login and logout VB script that writes to a text file.
>It looks for today's date.
>If found, it compares the current time to the time record.
>If for some reason, the current time is EARLIER than the login time recorded, 
>it 
>overwrites it.
>(this should only happen if someone manually modified the file)
>
>This vbscript is placed in the Startup folder and runs when windows Starts.
>
>logOUT is a bit of a problem.
>
>I created a vbscript to use to log out.
>It records the time, then exits windows.
>
>However, the user MUST use this script to log out.
>If windows is exited normally, (or abnormally for that matter)...
>basically.. if any other method is used to log out, the time is not recorded.
>
>For Personal use, I am very disciplined about using this.
>But for widespread use? I wouldn't trust it.
>
>Another security issue is that the file it updates is a simple text file.
>Therefore, a user COULD modify the values...
>(i.e.: I was 10 minutes late getting to my desk because my boss was talking to 
>me at the coffee machine on the way in.
>So, I wanted to "back out" the time so it wouldn't show up as "late"...)
>I've CONSIDERED trying to open the file as "Binary".
>I've done this from Excel before, but not from VBScript.
>
>My excel file then updates from this log file 

Re: $$Excel-Macros$$ Need your help

[Mangesh Vimay]

Hi Paul/Friends,

I would like to use this concept for my personal computer. I knew very well
that It is going to be tough job but as many experts are part of this
group, I hope someone would definitely try to get answer.
Let me know if you need more information on same.
Please find the attached sheet that can be use as start up sheet to solve
the problem.

On Mon, Aug 13, 2012 at 7:41 PM, Paul Schreiner wrote:

> I've worked through quite a bit of this.
> Spent MANY hours trying to work it out.
>
> There's LOTS of things to consider.
>
> #1.. is this for personal use, or for many people in an office?
> 1a)  If it is an office, is there an I.T. department that controls PC and
> Windows configuration?
>
> Windows has a "Group Policy" that allows you to create login/logouts
> scripts for Windows.
> Since my work environment has an I.T. Department that controlls our system
> configurations,
> I could not utilize this method. (They locked out the Group Policy Editor)
>
> Instead, I created a login and logout VB script that writes to a text file.
> It looks for today's date.
> If found, it compares the current time to the time record.
> If for some reason, the current time is EARLIER than the login time
> recorded, it overwrites it.
> (this should only happen if someone manually modified the file)
>
> This vbscript is placed in the Startup folder and runs when windows Starts.
>
> logOUT is a bit of a problem.
>
> I created a vbscript to use to log out.
> It records the time, then exits windows.
>
> However, the user MUST use this script to log out.
> If windows is exited normally, (or abnormally for that matter)...
> basically.. if any other method is used to log out, the time is not
> recorded.
>
> For Personal use, I am very disciplined about using this.
> But for widespread use? I wouldn't trust it.
>
> Another security issue is that the file it updates is a simple text file.
> Therefore, a user COULD modify the values...
> (i.e.: I was 10 minutes late getting to my desk because my boss was
> talking to me at the coffee machine on the way in.
> So, I wanted to "back out" the time so it wouldn't show up as "late"...)
> I've CONSIDERED trying to open the file as "Binary".
> I've done this from Excel before, but not from VBScript.
>
> My excel file then updates from this log file when opened.
>
>
> *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:* David Grugeon 
> *To:* excel-macros@googlegroups.com
> *Sent:* Mon, August 13, 2012 9:25:56 AM
> *Subject:* Re: $$Excel-Macros$$ Need your help
>
> Magnesh and Paul
>
> I think you could put an excel file (or a shortcut to one), in the startup
> folder.  have an on open macro in the sheet to record the opening time.
>  Then have a before close macro to record the time and save itself.
>
> My only concern would be whether Windows kills excel before the saving
> process is complete.  Otherwise it should work, provided you don't mind
> having the file, and excel, open all day.
>
> On 13 August 2012 22:55, Paul Schreiner  wrote:
>
>>   This is going to be a tough one.
>> It involves access to the Windows environment.
>> I REALLY hope someone has an alternative,
>> but I think you're going to have to write some
>> VBscript files that run at Windows Login and Logout
>> that will make entries to a log file.
>>
>>
>> *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:* Mangesh Vimay 
>> *To:* excel-macros@googlegroups.com; NOORAIN ANSARI <
>> noorain.ans...@gmail.com>; rajan verma 
>> *Sent:* Mon, August 13, 2012 8:48:16 AM
>> *Subject:* $$Excel-Macros$$ Need your help
>>
>> Hi Friends,
>>
>> Please help me on issue below.
>> *Issue :-*  I need such excel file which can automatically stored login
>> time with date and logout time so that I could able to analysis for how
>> much time my computer was switched on/in use.
>> For ex

Re: $$Excel-Macros$$ Need your help

[Paul Schreiner]

I've worked through quite a bit of this.
Spent MANY hours trying to work it out.

There's LOTS of things to consider.

#1.. is this for personal use, or for many people in an office?
1a)  If it is an office, is there an I.T. department that controls PC and 
Windows configuration?

Windows has a "Group Policy" that allows you to create login/logouts scripts 
for 
Windows.
Since my work environment has an I.T. Department that controlls our system 
configurations,
I could not utilize this method. (They locked out the Group Policy Editor)

Instead, I created a login and logout VB script that writes to a text file.
It looks for today's date.
If found, it compares the current time to the time record.
If for some reason, the current time is EARLIER than the login time recorded, 
it 
overwrites it.
(this should only happen if someone manually modified the file)

This vbscript is placed in the Startup folder and runs when windows Starts.

logOUT is a bit of a problem.

I created a vbscript to use to log out.
It records the time, then exits windows.

However, the user MUST use this script to log out.
If windows is exited normally, (or abnormally for that matter)...
basically.. if any other method is used to log out, the time is not recorded.

For Personal use, I am very disciplined about using this.
But for widespread use? I wouldn't trust it.

Another security issue is that the file it updates is a simple text file.
Therefore, a user COULD modify the values...
(i.e.: I was 10 minutes late getting to my desk because my boss was talking to 
me at the coffee machine on the way in.
So, I wanted to "back out" the time so it wouldn't show up as "late"...)
I've CONSIDERED trying to open the file as "Binary".
I've done this from Excel before, but not from VBScript.

My excel file then updates from this log file when opened.
 
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: David Grugeon 
To: excel-macros@googlegroups.com
Sent: Mon, August 13, 2012 9:25:56 AM
Subject: Re: $$Excel-Macros$$ Need your help

Magnesh and Paul 

I think you could put an excel file (or a shortcut to one), in the startup 
folder.  have an on open macro in the sheet to record the opening time.  Then 
have a before close macro to record the time and save itself.

My only concern would be whether Windows kills excel before the saving process 
is complete.  Otherwise it should work, provided you don't mind having the 
file, 
and excel, open all day.


On 13 August 2012 22:55, Paul Schreiner  wrote:

This is going to be a tough one.
>It involves access to the Windows environment.
>I REALLY hope someone has an alternative,
>but I think you're going to have to write some 
>VBscript files that run at Windows Login and Logout
>that will make entries to a log file.
> 
>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: Mangesh Vimay 
>To: excel-macros@googlegroups.com; NOORAIN ANSARI ; 
>rajan verma 
>Sent: Mon, August 13, 2012 8:48:16 AM
>Subject: $$Excel-Macros$$ Need your help
>
>
>Hi Friends, 
>
>
>Please help me on issue below.
>Issue :-  I need such excel file which can automatically stored login time 
>with 
>date and logout time so that I could able to analysis for how much time my 
>computer was switched on/in use.
>For example,
>If I login by the time 7:00:00 AM and logout on 12:30:00 PM on Date 13/8/2012.
>Then it should feed all these data in an excel sheet like as -
>
>
>
>
>We can take help of VBA also.
>I hope I am able to tell you my need. If not please let me know.
>Thanks in advance.
>
>-- 
>With regards, 
>
>
>MaNgEsH
>-- 
>Join official facebook page of this forum @ 
>https://www.facebook.com/discussexcel
> 
>FORUM RULES (1120+ 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-p

Re: $$Excel-Macros$$ Need your help

[David Grugeon]

Magnesh and Paul

I think you could put an excel file (or a shortcut to one), in the startup
folder.  have an on open macro in the sheet to record the opening time.
 Then have a before close macro to record the time and save itself.

My only concern would be whether Windows kills excel before the saving
process is complete.  Otherwise it should work, provided you don't mind
having the file, and excel, open all day.

On 13 August 2012 22:55, Paul Schreiner  wrote:

> This is going to be a tough one.
> It involves access to the Windows environment.
> I REALLY hope someone has an alternative,
> but I think you're going to have to write some
> VBscript files that run at Windows Login and Logout
> that will make entries to a log file.
>
>
> *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:* Mangesh Vimay 
> *To:* excel-macros@googlegroups.com; NOORAIN ANSARI <
> noorain.ans...@gmail.com>; rajan verma 
> *Sent:* Mon, August 13, 2012 8:48:16 AM
> *Subject:* $$Excel-Macros$$ Need your help
>
> Hi Friends,
>
> Please help me on issue below.
> *Issue :-*  I need such excel file which can automatically stored login
> time with date and logout time so that I could able to analysis for how
> much time my computer was switched on/in use.
> For example,
> If I login by the time *7:00:00 AM* and logout on *12:30:00 PM* on Date *
> 13/8/2012*.
> Then it should feed all these data in an excel sheet like as -
> [image: Inline image 1]
>
> We can take help of VBA also.
> I hope I am able to tell you my need. If not please let me know.
> Thanks in advance.
>
> --
> With regards,
>
> MaNgEsH
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
Regards
David Grugeon

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need 

Re: $$Excel-Macros$$ Need your help

[Paul Schreiner]

This is going to be a tough one.
It involves access to the Windows environment.
I REALLY hope someone has an alternative,
but I think you're going to have to write some 
VBscript files that run at Windows Login and Logout
that will make entries to a log file.
 
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: Mangesh Vimay 
To: excel-macros@googlegroups.com; NOORAIN ANSARI ; 
rajan verma 
Sent: Mon, August 13, 2012 8:48:16 AM
Subject: $$Excel-Macros$$ Need your help

Hi Friends, 

Please help me on issue below.
Issue :-  I need such excel file which can automatically stored login time with 
date and logout time so that I could able to analysis for how much time my 
computer was switched on/in use.
For example,
If I login by the time 7:00:00 AM and logout on 12:30:00 PM on Date 13/8/2012.
Then it should feed all these data in an excel sheet like as -


We can take help of VBA also.
I hope I am able to tell you my need. If not please let me know.
Thanks in advance.

-- 
With regards, 

MaNgEsH
-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ 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. 

 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners 
and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.


<>

$$Excel-Macros$$ Need your help

[Mangesh Vimay]

Hi Friends,

Please help me on issue below.
*Issue :-*  I need such excel file which can automatically stored login
time with date and logout time so that I could able to analysis for how
much time my computer was switched on/in use.
For example,
If I login by the time *7:00:00 AM* and logout on *12:30:00 PM* on Date *
13/8/2012*.
Then it should feed all these data in an excel sheet like as -
[image: Inline image 1]

We can take help of VBA also.
I hope I am able to tell you my need. If not please let me know.
Thanks in advance.

-- 
With regards,

MaNgEsH

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.


<>

Re: $$Excel-Macros$$ Need your help !!!

[Mohit Sharma]

Thanks Noorain sir. you are simply superb.

On Wed, Jun 20, 2012 at 7:23 PM, NOORAIN ANSARI wrote:

> Dear Mohit,
>
> See attached sheet
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
> On Wed, Jun 20, 2012 at 6:13 PM, Mohit Sharma wrote:
>
>> Hi
>> Noorain sir, your method is simply great. but can be display the total no
>> of Value in one time. for eg. in this sheet every value like ABZ,XYZ,PQR
>> are repeated three times. so can be display total of ABZ or XYZ or PQR in
>> answer column with the help of VLookup
>>
>>
>>
>> On Tue, Jun 19, 2012 at 10:49 PM, Mangesh Vimay 
>> wrote:
>>
>>> Thanks Noorain Bhai,
>>>
>>>
>>> On Tue, Jun 19, 2012 at 9:08 PM, NOORAIN ANSARI <
>>> noorain.ans...@gmail.com> wrote:
>>>
 see attached sheet


 On Tue, Jun 19, 2012 at 9:06 PM, NOORAIN ANSARI <
 noorain.ans...@gmail.com> wrote:

> Dear Mangesh,
>
> Please try it..
>
> =VLOOKUP($H9,IF($A$2:$A$10=$H$7,$B$2:$E$10,0),MATCH(I$8,$B$1:$E$1,0),0)
> with ctrl+Shift+enter
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
>
> On Tue, Jun 19, 2012 at 8:59 PM, Mangesh Vimay <
> mangesh.da...@gmail.com> wrote:
>
>> Hi Friends, In above example, if we input the name like ABC then it
>> should display it's apropriate values
>> in the table from the above list.
>> Please find the attached sheet.
>> How can we find the solution by using Vlookup() function? . Thanks
>>
>>
>> --
>> With regards,
>>
>> MaNgEsH
>>
>>  --
>> 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
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>
>
>
>
>
>
>






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

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com

>>>
>>>
>>>
>>> --
>>> With regards,
>>>
>>> MaNgEsH
>>>
>>>  --
>>> 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
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>>
>>
>>  -

Re: $$Excel-Macros$$ Need your help !!!

[NOORAIN ANSARI]

Dear Mohit,

See attached sheet


-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com

On Wed, Jun 20, 2012 at 6:13 PM, Mohit Sharma wrote:

> Hi
> Noorain sir, your method is simply great. but can be display the total no
> of Value in one time. for eg. in this sheet every value like ABZ,XYZ,PQR
> are repeated three times. so can be display total of ABZ or XYZ or PQR in
> answer column with the help of VLookup
>
>
>
> On Tue, Jun 19, 2012 at 10:49 PM, Mangesh Vimay 
> wrote:
>
>> Thanks Noorain Bhai,
>>
>>
>> On Tue, Jun 19, 2012 at 9:08 PM, NOORAIN ANSARI > > wrote:
>>
>>> see attached sheet
>>>
>>>
>>> On Tue, Jun 19, 2012 at 9:06 PM, NOORAIN ANSARI <
>>> noorain.ans...@gmail.com> wrote:
>>>
 Dear Mangesh,

 Please try it..

 =VLOOKUP($H9,IF($A$2:$A$10=$H$7,$B$2:$E$10,0),MATCH(I$8,$B$1:$E$1,0),0)
 with ctrl+Shift+enter

 --
 Thanks & regards,
 Noorain Ansari
 www.noorainansari.com
 www.excelmacroworld.blogspot.com


 On Tue, Jun 19, 2012 at 8:59 PM, Mangesh Vimay >>> > wrote:

> Hi Friends, In above example, if we input the name like ABC then it
> should display it's apropriate values
> in the table from the above list.
> Please find the attached sheet.
> How can we find the solution by using Vlookup() function? . Thanks
>
>
> --
> With regards,
>
> MaNgEsH
>
>  --
> 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
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com








>>>
>>>
>>>
>>>
>>>
>>>
>>>  --
>>> 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
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>>
>>
>>
>>
>> --
>> With regards,
>>
>> MaNgEsH
>>
>>  --
>> 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
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>
>  --
> 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.
>

Re: $$Excel-Macros$$ Need your help !!!

[Mohit Sharma]

Hi
Noorain sir, your method is simply great. but can be display the total no
of Value in one time. for eg. in this sheet every value like ABZ,XYZ,PQR
are repeated three times. so can be display total of ABZ or XYZ or PQR in
answer column with the help of VLookup



On Tue, Jun 19, 2012 at 10:49 PM, Mangesh Vimay wrote:

> Thanks Noorain Bhai,
>
>
> On Tue, Jun 19, 2012 at 9:08 PM, NOORAIN ANSARI 
> wrote:
>
>> see attached sheet
>>
>>
>> On Tue, Jun 19, 2012 at 9:06 PM, NOORAIN ANSARI > > wrote:
>>
>>> Dear Mangesh,
>>>
>>> Please try it..
>>>
>>> =VLOOKUP($H9,IF($A$2:$A$10=$H$7,$B$2:$E$10,0),MATCH(I$8,$B$1:$E$1,0),0)
>>> with ctrl+Shift+enter
>>>
>>> --
>>> Thanks & regards,
>>> Noorain Ansari
>>> www.noorainansari.com
>>> www.excelmacroworld.blogspot.com
>>>
>>>
>>> On Tue, Jun 19, 2012 at 8:59 PM, Mangesh Vimay 
>>> wrote:
>>>
 Hi Friends, In above example, if we input the name like ABC then it
 should display it's apropriate values
 in the table from the above list.
 Please find the attached sheet.
 How can we find the solution by using Vlookup() function? . Thanks


 --
 With regards,

 MaNgEsH

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

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>> www.noorainansari.com
>> www.excelmacroworld.blogspot.com
>>
>>
>>
>>
>>  --
>> 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
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>
>
>
> --
> With regards,
>
> MaNgEsH
>
>  --
> 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
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>

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

Re: $$Excel-Macros$$ Need your help !!!

[Mangesh Vimay]

Thanks Noorain Bhai,

On Tue, Jun 19, 2012 at 9:08 PM, NOORAIN ANSARI wrote:

> see attached sheet
>
>
> On Tue, Jun 19, 2012 at 9:06 PM, NOORAIN ANSARI 
> wrote:
>
>> Dear Mangesh,
>>
>> Please try it..
>>
>> =VLOOKUP($H9,IF($A$2:$A$10=$H$7,$B$2:$E$10,0),MATCH(I$8,$B$1:$E$1,0),0)
>> with ctrl+Shift+enter
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>> www.noorainansari.com
>> www.excelmacroworld.blogspot.com
>>
>>
>> On Tue, Jun 19, 2012 at 8:59 PM, Mangesh Vimay 
>> wrote:
>>
>>> Hi Friends, In above example, if we input the name like ABC then it
>>> should display it's apropriate values
>>> in the table from the above list.
>>> Please find the attached sheet.
>>> How can we find the solution by using Vlookup() function? . Thanks
>>>
>>>
>>> --
>>> With regards,
>>>
>>> MaNgEsH
>>>
>>>  --
>>> 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
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>
>>
>>
>>
>>
>>
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
>
>
>
>  --
> 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
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>



-- 
With regards,

MaNgEsH

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Need your help !!!

[NOORAIN ANSARI]

see attached sheet

On Tue, Jun 19, 2012 at 9:06 PM, NOORAIN ANSARI wrote:

> Dear Mangesh,
>
> Please try it..
>
> =VLOOKUP($H9,IF($A$2:$A$10=$H$7,$B$2:$E$10,0),MATCH(I$8,$B$1:$E$1,0),0)
> with ctrl+Shift+enter
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
>
> On Tue, Jun 19, 2012 at 8:59 PM, Mangesh Vimay wrote:
>
>> Hi Friends, In above example, if we input the name like ABC then it
>> should display it's apropriate values
>> in the table from the above list.
>> Please find the attached sheet.
>> How can we find the solution by using Vlookup() function? . Thanks
>>
>>
>> --
>> With regards,
>>
>> MaNgEsH
>>
>>  --
>> 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
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>
>
>
>
>
>
>


-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Example_Name(Solved).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Need your help !!!

[NOORAIN ANSARI]

Dear Mangesh,

Please try it..

=VLOOKUP($H9,IF($A$2:$A$10=$H$7,$B$2:$E$10,0),MATCH(I$8,$B$1:$E$1,0),0)
with ctrl+Shift+enter

-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com


On Tue, Jun 19, 2012 at 8:59 PM, Mangesh Vimay wrote:

> Hi Friends, In above example, if we input the name like ABC then it should
> display it's apropriate values
> in the table from the above list.
> Please find the attached sheet.
> How can we find the solution by using Vlookup() function? . Thanks
>
>
> --
> With regards,
>
> MaNgEsH
>
>  --
> 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
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

$$Excel-Macros$$ Need your help !!!

[Mangesh Vimay]

Hi Friends, In above example, if we input the name like ABC then it should
display it's apropriate values
in the table from the above list.
Please find the attached sheet.
How can we find the solution by using Vlookup() function? . Thanks


-- 
With regards,

MaNgEsH

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

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

Re: $$Excel-Macros$$ Need Your Help

[dguillett1]

Nicely done...!!

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com

From: ╰» ℓαℓιт мσαнη 
Sent: Sunday, April 29, 2012 12:27 PM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Need Your Help

Hi karthik 


PFA


Regards,
Lalit Mohan





On Sun, Apr 29, 2012 at 10:56 PM, ╰» ℓαℓιт мσαнη  
wrote:

  Hi karthik 


  PFA

  Regards,
  Lalit Mohan





  On Sun, Apr 29, 2012 at 1:38 PM, karthik N  wrote:

Hi friends,

Find the attachment of company address,how to spreat'up the colomn wise data

Sample data is attached.


Regards
karthik.N

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



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

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

Re: $$Excel-Macros$$ Need Your Help

[╰» ℓαℓιт мσαнη]

*Hi karthik*
*
*
*PFA*
*
*
*Regards,*
*Lalit Mohan*



On Sun, Apr 29, 2012 at 10:56 PM, ╰» ℓαℓιт мσαнη
wrote:

> *Hi karthik*
> *
> *
> *PFA*
>
> *Regards,*
> *Lalit Mohan*
>
>
>
> On Sun, Apr 29, 2012 at 1:38 PM, karthik N  wrote:
>
>> Hi friends,
>>
>> Find the attachment of company address,how to spreat'up the colomn wise
>> data
>>
>> Sample data is attached.
>>
>>
>> Regards
>> karthik.N
>>
>> --
>> 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
>>
>
>

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


data.xlsm
Description: Binary data

Re: $$Excel-Macros$$ Need Your Help

[╰» ℓαℓιт мσαнη]

*Hi karthik*
*
*
*PFA*

*Regards,*
*Lalit Mohan*



On Sun, Apr 29, 2012 at 1:38 PM, karthik N  wrote:

> Hi friends,
>
> Find the attachment of company address,how to spreat'up the colomn wise
> data
>
> Sample data is attached.
>
>
> Regards
> karthik.N
>
> --
> 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
>

-- 
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$$ Need your help !!!

[Mangesh Dayne]

Hi Rajan,

I need some web links for the study material of excel vba. So kindly send
me links so that I could learn vba.



With regards,

Mangesh Dayne

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

Re: $$Excel-Macros$$ Need your help in Vlookup formula.....

[rajan verma]

I think its not possible by vlookup() Function ..

On Sat, Aug 20, 2011 at 9:38 PM, Sam Mathai Chacko wrote:

> Not sure why you want to use only Vlookup. VL only looks up the exact, or
> the approximate match from a list. If you are worried about the complexity,
> just use a simple combination of sumproduct and large.
>
> =SUMPRODUCT(LARGE(($A$2:$A$16=H7)*(B2:B16),3))
>
> The advantage here is that you do not even need to use an error handling.
> If your number does not exist in the list, it will return all zeroes as 0 0
> 0
>
> Cheers,
> Sam Mathai Chacko (GL)
>
>
> On Sat, Aug 20, 2011 at 5:19 PM, Indrajit $nai wrote:
>
>> *Thanks to everyone. But one thing, is it possible to get the correct
>> result with the help of "Vlookup" formula?*
>>
>>
>>
>> On Fri, Aug 19, 2011 at 8:11 PM, Rajan_Verma wrote:
>>
>>> Thanks and Welcome
>>>
>>>
>>> -Original Message-
>>> From: excel-macros@googlegroups.com [mailto:
>>> excel-macros@googlegroups.com]
>>> On Behalf Of Lawali
>>> Sent: Friday, August 19, 2011 7:57 PM
>>> To: MS EXCEL AND VBA MACROS
>>> Subject: Re: $$Excel-Macros$$ Need your help in Vlookup formula.
>>>
>>> Rajan,
>>> Your solution is awesome!!!
>>>
>>> On Aug 19, 9:39 am, "Rajan_Verma"  wrote:
>>> > You Can Tri this :
>>> >
>>> > Private Sub Worksheet_Change(ByVal Target As Range)
>>> >
>>> > On Error GoTo Err:
>>> >
>>> > Dim k As Integer
>>> >
>>> > If Target = Range("H7") Then
>>> >
>>> > Application.EnableEvents = False
>>> >
>>> > Range("F9").Resize(1, Range("F9").End(xlToRight).Row).ClearContents
>>> >
>>> > k = 0
>>> >
>>> > For i = 1 To Range("A65536").End(xlUp).Row
>>> >
>>> > If Range("A" & i).Value = Target Then
>>> >
>>> > Range("F9").Offset(0, k).Value = Range("A" & i).Offset(0,
>>> > 1).Value
>>> >
>>> > k = k + 1
>>> >
>>> > End If
>>> >
>>> > Next
>>> >
>>> > End If
>>> >
>>> > Err:
>>> >
>>> > Application.EnableEvents = True
>>> >
>>> > End Sub
>>> >
>>> > From: excel-macros@googlegroups.com [mailto:
>>> excel-macros@googlegroups.com]
>>> > On Behalf Of ashish koul
>>> > Sent: Friday, August 19, 2011 9:20 AM
>>> > To: excel-macros@googlegroups.com
>>> > Subject: Re: $$Excel-Macros$$ Need your help in Vlookup formula.
>>> >
>>> > try this
>>> >
>>> > On Fri, Aug 19, 2011 at 1:02 AM, Indrajit $nai <
>>> talk2indra...@gmail.com>
>>> > wrote:
>>> >
>>> > Hi All,
>>> >
>>> > I need your small help in Vlookup formula. I have attached a file with
>>> this
>>> > mail, where you can see  2 columns in the left. One is Qty. another is
>>> Sr.
>>> > no.
>>> >
>>> > Now I want to search Sr. no. through Qty. Suppose if I put Qty. 1400 it
>>> will
>>> > show me 14, if I put 600 it will show 6, but the problem is when I am
>>> > putting
>>> >
>>> > 100 or 200 in the input column it is only giving me the Sr. No. 1 (in
>>> case
>>> > of 100) or 2 (in case of 200). But 100 or 200 are available more than
>>> one
>>> > time, so
>>> >
>>> > it should give me the result like this;
>>> >
>>> > Please enter the Sr. No. ---> 100
>>> >
>>> > Qty 1 7 9
>>> >
>>> > How can I do this with the help of Vlookup. Can you help me. Please its
>>> > urgent.
>>> >
>>> > Thanks in advance.
>>> >
>>> > --
>>> > Indrajit Snai
>>> >
>>> > Disclaimer:
>>> > This electronic message and any files transmitted with it are
>>> confidential
>>> > and intended solely for the use of the individual or entity to whom
>>> they
>>> are
>>> > addressed. If you are not the intended recipient you are hereby
>>> notified
>>> > that any disclosure, copying, distribution or taking any action in
>

Re: $$Excel-Macros$$ Need your help in Vlookup formula.....

[Indrajit $nai]

*Thanks to everyone. But one thing, is it possible to get the correct result
with the help of "Vlookup" formula?*



On Fri, Aug 19, 2011 at 8:11 PM, Rajan_Verma wrote:

> Thanks and Welcome
>
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf Of Lawali
> Sent: Friday, August 19, 2011 7:57 PM
> To: MS EXCEL AND VBA MACROS
> Subject: Re: $$Excel-Macros$$ Need your help in Vlookup formula.
>
> Rajan,
> Your solution is awesome!!!
>
> On Aug 19, 9:39 am, "Rajan_Verma"  wrote:
> > You Can Tri this :
> >
> > Private Sub Worksheet_Change(ByVal Target As Range)
> >
> > On Error GoTo Err:
> >
> > Dim k As Integer
> >
> > If Target = Range("H7") Then
> >
> > Application.EnableEvents = False
> >
> > Range("F9").Resize(1, Range("F9").End(xlToRight).Row).ClearContents
> >
> > k = 0
> >
> > For i = 1 To Range("A65536").End(xlUp).Row
> >
> > If Range("A" & i).Value = Target Then
> >
> > Range("F9").Offset(0, k).Value = Range("A" & i).Offset(0,
> > 1).Value
> >
> > k = k + 1
> >
> > End If
> >
> > Next
> >
> > End If
> >
> > Err:
> >
> > Application.EnableEvents = True
> >
> > End Sub
> >
> > From: excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com]
> > On Behalf Of ashish koul
> > Sent: Friday, August 19, 2011 9:20 AM
> > To: excel-macros@googlegroups.com
> > Subject: Re: $$Excel-Macros$$ Need your help in Vlookup formula.
> >
> > try this
> >
> > On Fri, Aug 19, 2011 at 1:02 AM, Indrajit $nai 
> > wrote:
> >
> > Hi All,
> >
> > I need your small help in Vlookup formula. I have attached a file with
> this
> > mail, where you can see  2 columns in the left. One is Qty. another is
> Sr.
> > no.
> >
> > Now I want to search Sr. no. through Qty. Suppose if I put Qty. 1400 it
> will
> > show me 14, if I put 600 it will show 6, but the problem is when I am
> > putting
> >
> > 100 or 200 in the input column it is only giving me the Sr. No. 1 (in
> case
> > of 100) or 2 (in case of 200). But 100 or 200 are available more than one
> > time, so
> >
> > it should give me the result like this;
> >
> > Please enter the Sr. No. ---> 100
> >
> > Qty 1 7 9
> >
> > How can I do this with the help of Vlookup. Can you help me. Please its
> > urgent.
> >
> > Thanks in advance.
> >
> > --
> > Indrajit Snai
> >
> > Disclaimer:
> > This electronic message and any files transmitted with it are
> confidential
> > and intended solely for the use of the individual or entity to whom they
> are
> > addressed. If you are not the intended recipient you are hereby notified
> > that any disclosure, copying, distribution or taking any action in
> reliance
> > on the contents of this information is strictly prohibited and may be
> > unlawful.
> >
> > --
> >
> ---
> -
> > --
> > 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
> >
> > --
> >
> > Regards
> >
> > Ashish Koul
> >
> >  <http://akoul.blogspot.com/>
> akoul.blogspot.comhttp://akoul.posterous.com/
> >
> >  <http://akoul.wordpress.com/> akoul.wordpress.com
> >
> > My <http://in.linkedin.com/pub/ashish-koul/10/400/830>  Linkedin Profile
> >
> > P Before printing, think about the environment.
> >
> > --
> >
> ---
> -
> > --
> > Some imp

Re: $$Excel-Macros$$ Need your help in Vlookup formula.....

[Indrajit $nai]

*Thanks to all of you for spending your valuable time*.


On Fri, Aug 19, 2011 at 8:11 PM, Rajan_Verma wrote:

> Thanks and Welcome
>
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf Of Lawali
> Sent: Friday, August 19, 2011 7:57 PM
> To: MS EXCEL AND VBA MACROS
> Subject: Re: $$Excel-Macros$$ Need your help in Vlookup formula.
>
> Rajan,
> Your solution is awesome!!!
>
> On Aug 19, 9:39 am, "Rajan_Verma"  wrote:
> > You Can Tri this :
> >
> > Private Sub Worksheet_Change(ByVal Target As Range)
> >
> > On Error GoTo Err:
> >
> > Dim k As Integer
> >
> > If Target = Range("H7") Then
> >
> > Application.EnableEvents = False
> >
> > Range("F9").Resize(1, Range("F9").End(xlToRight).Row).ClearContents
> >
> > k = 0
> >
> > For i = 1 To Range("A65536").End(xlUp).Row
> >
> > If Range("A" & i).Value = Target Then
> >
> > Range("F9").Offset(0, k).Value = Range("A" & i).Offset(0,
> > 1).Value
> >
> > k = k + 1
> >
> > End If
> >
> > Next
> >
> > End If
> >
> > Err:
> >
> > Application.EnableEvents = True
> >
> > End Sub
> >
> > From: excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com]
> > On Behalf Of ashish koul
> > Sent: Friday, August 19, 2011 9:20 AM
> > To: excel-macros@googlegroups.com
> > Subject: Re: $$Excel-Macros$$ Need your help in Vlookup formula.
> >
> > try this
> >
> > On Fri, Aug 19, 2011 at 1:02 AM, Indrajit $nai 
> > wrote:
> >
> > Hi All,
> >
> > I need your small help in Vlookup formula. I have attached a file with
> this
> > mail, where you can see  2 columns in the left. One is Qty. another is
> Sr.
> > no.
> >
> > Now I want to search Sr. no. through Qty. Suppose if I put Qty. 1400 it
> will
> > show me 14, if I put 600 it will show 6, but the problem is when I am
> > putting
> >
> > 100 or 200 in the input column it is only giving me the Sr. No. 1 (in
> case
> > of 100) or 2 (in case of 200). But 100 or 200 are available more than one
> > time, so
> >
> > it should give me the result like this;
> >
> > Please enter the Sr. No. ---> 100
> >
> > Qty 1 7 9
> >
> > How can I do this with the help of Vlookup. Can you help me. Please its
> > urgent.
> >
> > Thanks in advance.
> >
> > --
> > Indrajit Snai
> >
> > Disclaimer:
> > This electronic message and any files transmitted with it are
> confidential
> > and intended solely for the use of the individual or entity to whom they
> are
> > addressed. If you are not the intended recipient you are hereby notified
> > that any disclosure, copying, distribution or taking any action in
> reliance
> > on the contents of this information is strictly prohibited and may be
> > unlawful.
> >
> > --
> >
> ---
> -
> > --
> > 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
> >
> > --
> >
> > Regards
> >
> > Ashish Koul
> >
> >  <http://akoul.blogspot.com/>
> akoul.blogspot.comhttp://akoul.posterous.com/
> >
> >  <http://akoul.wordpress.com/> akoul.wordpress.com
> >
> > My <http://in.linkedin.com/pub/ashish-koul/10/400/830>  Linkedin Profile
> >
> > P Before printing, think about the environment.
> >
> > --
> >
> ---
> -
> > --
> > Some important links for excel users:
> > 1. Follow us on TWITTER

RE: $$Excel-Macros$$ Need your help in Vlookup formula.....

[Rajan_Verma]

Thanks and Welcome 


-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Lawali
Sent: Friday, August 19, 2011 7:57 PM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Need your help in Vlookup formula.

Rajan,
Your solution is awesome!!!

On Aug 19, 9:39 am, "Rajan_Verma"  wrote:
> You Can Tri this :
>
> Private Sub Worksheet_Change(ByVal Target As Range)
>
> On Error GoTo Err:
>
> Dim k As Integer
>
> If Target = Range("H7") Then
>
> Application.EnableEvents = False
>
> Range("F9").Resize(1, Range("F9").End(xlToRight).Row).ClearContents
>
> k = 0
>
>     For i = 1 To Range("A65536").End(xlUp).Row
>
>         If Range("A" & i).Value = Target Then
>
>             Range("F9").Offset(0, k).Value = Range("A" & i).Offset(0,
> 1).Value
>
>             k = k + 1
>
>         End If
>
>     Next
>
> End If
>
> Err:
>
> Application.EnableEvents = True
>
> End Sub
>
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf Of ashish koul
> Sent: Friday, August 19, 2011 9:20 AM
> To: excel-macros@googlegroups.com
> Subject: Re: $$Excel-Macros$$ Need your help in Vlookup formula.
>
> try this
>
> On Fri, Aug 19, 2011 at 1:02 AM, Indrajit $nai 
> wrote:
>
> Hi All,
>
> I need your small help in Vlookup formula. I have attached a file with
this
> mail, where you can see  2 columns in the left. One is Qty. another is Sr.
> no.
>
> Now I want to search Sr. no. through Qty. Suppose if I put Qty. 1400 it
will
> show me 14, if I put 600 it will show 6, but the problem is when I am
> putting
>
> 100 or 200 in the input column it is only giving me the Sr. No. 1 (in case
> of 100) or 2 (in case of 200). But 100 or 200 are available more than one
> time, so
>
> it should give me the result like this;
>
> Please enter the Sr. No. ---> 100
>
> Qty 1 7 9
>
> How can I do this with the help of Vlookup. Can you help me. Please its
> urgent.
>
> Thanks in advance.
>
> --
> Indrajit Snai
>
> Disclaimer:
> This electronic message and any files transmitted with it are confidential
> and intended solely for the use of the individual or entity to whom they
are
> addressed. If you are not the intended recipient you are hereby notified
> that any disclosure, copying, distribution or taking any action in
reliance
> on the contents of this information is strictly prohibited and may be
> unlawful.
>
> --
>
---
-
> --
> 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
>
> --
>
> Regards
>
> Ashish Koul
>
>  <http://akoul.blogspot.com/>
akoul.blogspot.comhttp://akoul.posterous.com/
>
>  <http://akoul.wordpress.com/> akoul.wordpress.com
>
> My <http://in.linkedin.com/pub/ashish-koul/10/400/830>  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 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
>
>  Copy of Vlookup (2).xls
> 54KViewDownload

-- 

--
Some impo

Re: $$Excel-Macros$$ Need your help in Vlookup formula.....

[Lawali]

Rajan,
Your solution is awesome!!!

On Aug 19, 9:39 am, "Rajan_Verma"  wrote:
> You Can Tri this :
>
> Private Sub Worksheet_Change(ByVal Target As Range)
>
> On Error GoTo Err:
>
> Dim k As Integer
>
> If Target = Range("H7") Then
>
> Application.EnableEvents = False
>
> Range("F9").Resize(1, Range("F9").End(xlToRight).Row).ClearContents
>
> k = 0
>
>     For i = 1 To Range("A65536").End(xlUp).Row
>
>         If Range("A" & i).Value = Target Then
>
>             Range("F9").Offset(0, k).Value = Range("A" & i).Offset(0,
> 1).Value
>
>             k = k + 1
>
>         End If
>
>     Next
>
> End If
>
> Err:
>
> Application.EnableEvents = True
>
> End Sub
>
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf Of ashish koul
> Sent: Friday, August 19, 2011 9:20 AM
> To: excel-macros@googlegroups.com
> Subject: Re: $$Excel-Macros$$ Need your help in Vlookup formula.
>
> try this
>
> On Fri, Aug 19, 2011 at 1:02 AM, Indrajit $nai 
> wrote:
>
> Hi All,
>
> I need your small help in Vlookup formula. I have attached a file with this
> mail, where you can see  2 columns in the left. One is Qty. another is Sr.
> no.
>
> Now I want to search Sr. no. through Qty. Suppose if I put Qty. 1400 it will
> show me 14, if I put 600 it will show 6, but the problem is when I am
> putting
>
> 100 or 200 in the input column it is only giving me the Sr. No. 1 (in case
> of 100) or 2 (in case of 200). But 100 or 200 are available more than one
> time, so
>
> it should give me the result like this;
>
> Please enter the Sr. No. ---> 100
>
> Qty 1 7 9
>
> How can I do this with the help of Vlookup. Can you help me. Please its
> urgent.
>
> Thanks in advance.
>
> --
> Indrajit Snai
>
> Disclaimer:
> This electronic message and any files transmitted with it are confidential
> and intended solely for the use of the individual or entity to whom they are
> addressed. If you are not the intended recipient you are hereby notified
> that any disclosure, copying, distribution or taking any action in reliance
> on the contents of this information is strictly prohibited and may be
> unlawful.
>
> --
> --- -
> --
> 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
>
> --
>
> Regards
>
> Ashish Koul
>
>  <http://akoul.blogspot.com/> akoul.blogspot.comhttp://akoul.posterous.com/
>
>  <http://akoul.wordpress.com/> akoul.wordpress.com
>
> My <http://in.linkedin.com/pub/ashish-koul/10/400/830>  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 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
>
>  Copy of Vlookup (2).xls
> 54KViewDownload

-- 
--
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 your help in Vlookup formula.....

[XLS S]

Hey Inderjit,

please find the attachment...

On Fri, Aug 19, 2011 at 1:02 AM, Indrajit $nai  wrote:
> Hi All,
> I need your small help in Vlookup formula. I have attached a file with this
> mail, where you can see  2 columns in the left. One is Qty. another is Sr.
> no.
> Now I want to search Sr. no. through Qty. Suppose if I put Qty. 1400 it will
> show me 14, if I put 600 it will show 6, but the problem is when I am
> putting
> 100 or 200 in the input column it is only giving me the Sr. No. 1 (in case
> of 100) or 2 (in case of 200). But 100 or 200 are available more than one
> time, so
> it should give me the result like this;
> Please enter the Sr. No. ---> 100
> Qty 1 7 9
> How can I do this with the help of Vlookup. Can you help me. Please its
> urgent.
> Thanks in advance.
>
> --
> Indrajit Snai
>
> Disclaimer:
> This electronic message and any files transmitted with it are confidential
> and intended solely for the use of the individual or entity to whom they are
> addressed. If you are not the intended recipient you are hereby notified
> that any disclosure, copying, distribution or taking any action in reliance
> on the contents of this information is strictly prohibited and may be
> unlawful.
>
> --
> --
> 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-1.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Need your help in Vlookup formula.....

[NOORAIN ANSARI]

Dear indajit,

Please see attached sheet..

On Fri, Aug 19, 2011 at 1:02 AM, Indrajit $nai wrote:

> Hi All,
>
> I need your small help in Vlookup formula. I have attached a file with this
> mail, where you can see  2 columns in the left. One is Qty. another is Sr.
> no.
> Now I want to search Sr. no. through Qty. Suppose if I put Qty. 1400 it
> will show me 14, if I put 600 it will show 6, but the problem is when I am
> putting
> 100 or 200 in the input column it is only giving me the Sr. No. 1 (in case
> of 100) or 2 (in case of 200). But 100 or 200 are available more than one
> time, so
> it should give me the result like this;
>
> *Please enter the Sr. No. *---> 100
> *Qty *1 7 9
>
> How can I do this with the help of Vlookup. Can you help me. Please its
> urgent.
>
> Thanks in advance.
>
> --
> Indrajit Snai
>
> Disclaimer:
> This electronic message and any files transmitted with it are confidential
> and intended solely for the use of the individual or entity to whom they are
> addressed. If you are not the intended recipient you are hereby notified
> that any disclosure, copying, distribution or taking any action in reliance
> on the contents of this information is strictly prohibited and may be
> unlawful.
>
> --
>
> --
> 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


Vlookup(Solved).xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Need your help in Vlookup formula.....

[ashish koul]

try this

On Fri, Aug 19, 2011 at 1:02 AM, Indrajit $nai wrote:

> Hi All,
>
> I need your small help in Vlookup formula. I have attached a file with this
> mail, where you can see  2 columns in the left. One is Qty. another is Sr.
> no.
> Now I want to search Sr. no. through Qty. Suppose if I put Qty. 1400 it
> will show me 14, if I put 600 it will show 6, but the problem is when I am
> putting
> 100 or 200 in the input column it is only giving me the Sr. No. 1 (in case
> of 100) or 2 (in case of 200). But 100 or 200 are available more than one
> time, so
> it should give me the result like this;
>
> *Please enter the Sr. No. *---> 100
> *Qty * 1 7 9
>
> How can I do this with the help of Vlookup. Can you help me. Please its
> urgent.
>
> Thanks in advance.
>
> --
> Indrajit Snai
>
> Disclaimer:
> This electronic message and any files transmitted with it are confidential
> and intended solely for the use of the individual or entity to whom they are
> addressed. If you are not the intended recipient you are hereby notified
> that any disclosure, copying, distribution or taking any action in reliance
> on the contents of this information is strictly prohibited and may be
> unlawful.
>
> --
>
> --
> 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


Vlookup.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Need your help in Vlookup formula.....

[Indrajit $nai]

Hi All,

I need your small help in Vlookup formula. I have attached a file with this
mail, where you can see  2 columns in the left. One is Qty. another is Sr.
no.
Now I want to search Sr. no. through Qty. Suppose if I put Qty. 1400 it will
show me 14, if I put 600 it will show 6, but the problem is when I am
putting
100 or 200 in the input column it is only giving me the Sr. No. 1 (in case
of 100) or 2 (in case of 200). But 100 or 200 are available more than one
time, so
it should give me the result like this;

*Please enter the Sr. No. *---> 100
*Qty * 1 7 9

How can I do this with the help of Vlookup. Can you help me. Please its
urgent.

Thanks in advance.

-- 
Indrajit Snai

Disclaimer:
This electronic message and any files transmitted with it are confidential
and intended solely for the use of the individual or entity to whom they are
addressed. If you are not the intended recipient you are hereby notified
that any disclosure, copying, distribution or taking any action in reliance
on the contents of this information is strictly prohibited and may be
unlawful.

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


Vlookup.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ need your help on Validation

[ashish koul]

check this link

http://www.contextures.com/xldataval13.html#Create

On Tue, Dec 14, 2010 at 11:32 AM, lucky singh  wrote:

>
> Hi All,
>
> need your help on validation
>
> if i select softdiet then only the menu of soft diet should be shown in
> dropdown & not hard diet similarly to hard diet on hard diet should be shown
> in dropdown & not soft diet...
>
> Regards,
>
> Lucky
>
>
> --
>
> --
> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ need your help on Validation

[lucky singh]

Hi All,

need your help on validation

if i select softdiet then only the menu of soft diet should be shown in
dropdown & not hard diet similarly to hard diet on hard diet should be shown
in dropdown & not soft diet...

Regards,

Lucky

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts


diet chart.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ need your help

[Abhishek Jain]

Hi Shammi,

I am not sure if I have understood your query correctly. This is what I have
done:

> On the basis of the total score, the Band in the range G11 to H15 will be
highlighted with blue color.
> The amount of proposed growth on the basis of percentage relevant to to
Band # would be reflected in Cell - I11
> Total amount (Basic + Growth) would be reflected in Result - D17.

Please see the attached file and advise if this is what you are looking for.

Cheers !

AJ

On Thu, Feb 11, 2010 at 7:54 PM, shammi shrivastav <
shammi.shrivas...@gmail.com> wrote:

> friends please go through the attached file and help me. For about an hour
> I am fiddling with this. what I want:
>
> based on the value in cell K8; the corresponding band level should be
> highlighted automatically and a final result is available after all the
> calculations corresponding to the relevent basic and band
>
> regards
>
> --
> shammi shrivastav
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 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
> If you find any spam message in the group, please send an email to:
> Ayush Jain @ jainayus...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,700 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
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
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,700 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe


Evaluation Sheet - Shammi.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ need your help

[shammi shrivastav]

friends please go through the attached file and help me. For about an hour I
am fiddling with this. what I want:

based on the value in cell K8; the corresponding band level should be
highlighted automatically and a final result is available after all the
calculations corresponding to the relevent basic and band

regards

-- 
shammi shrivastav

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
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
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,700 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe


Evaluation Sheet.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Need your help

[Santhosh Kumar M K]

Dear Friends,

Need your kind support.

In a single sheet I created 10 Pivots for same data.In all pivots have same
option is *Customer name*.When I change the customer name  as "Rajesh" in a
first pivot, automatically should be change the same name "Rajesh" in other
9 pivots.PLease, give suggestion on this...

awaiting your response.

Regards,
Santhosh

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---