Re: $$Excel-Macros$$ VLOOKUP HELP NEED

[Venkatesh Narla]

Thanks a lot
On May 15, 2012 1:22 AM, "dguillett1"  wrote:

> Sub lookitup()
> Dim c As Range
> For Each c In Range("a2:a" & Cells(Rows.Count, 1).End(xlUp).Row)
> c.Offset(, 1) = Columns("F").Find(c, LookIn:=xlValues, _
> LookAt:=xlWhole, SearchOrder:=xlByRows, _
> SearchDirection:=xlNext).**Offset(, -1)
> Next
> End Sub
>
>
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
> -Original Message- From: Venkatesh Narla
> Sent: Monday, May 14, 2012 1:55 PM
> To: excel-macros@googlegroups.com
> Subject: Re: $$Excel-Macros$$ VLOOKUP HELP NEED
>
> Hi Rajan,
> Can i get VBA code for this
>
>
>
> Thanks,
> Venkatesh.
>
> On Tue, May 15, 2012 at 12:13 AM, Venkatesh Narla 
> wrote:
>
>> Thanks a lot...
>>
>> On Mon, May 14, 2012 at 11:50 PM, Rajan_Verma 
>> wrote:
>>
>>> See the attached Solution
>>> With
>>>
>>> Index/Match()
>>> Lookup()
>>>
>>>
>>> Regards
>>> Rajan verma
>>> +91 7838100659 [IM-Gtalk]
>>>
>>> -Original Message-
>>> From: excel-macros@googlegroups.com [mailto:excel-macros@**
>>> googlegroups.com ]
>>> On Behalf Of Venkatesh Narla
>>> Sent: 14 May 2012 11:30
>>> To: excel-macros@googlegroups.com
>>> Subject: $$Excel-Macros$$ VLOOKUP HELP NEED
>>>
>>> Hi All,
>>> I need help in Vlookup need formula.
>>>
>>> "Hi All,
>>> Column A has data; Column ""F"" is the range need E to pull"
>>>
>>>
>>>
>>> 10001   #N/AA   10001
>>> 10002   B   10002
>>> 10003   C   10003
>>> 10004   D   10004
>>> 10005   E   10005
>>> 10006   F   10006
>>> 10007   G   10007
>>> 10008   H   10008
>>> 10009   I   10009
>>> 10010   J   10010
>>> 10011   K   10011
>>> 10012   L   10012
>>> 10013   M   10013
>>> 10014   N   10014
>>> 10015   O   10015
>>> 10016   P   10016
>>> 10017   Q   10017
>>> 10018   R   10018
>>> 10019   S   10019
>>> 10020   T   10020
>>>
>>> --
>>> 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.
>
> -

$$Excel-Macros$$ VBA Libraries

[BNS kumar]

Hi Guyz,

I want to learn about VBA libraries (For Eg: linking VBA to other
programming languages like C/C++, writing/editing library functions etc). I
have search a lot online, but couldn't find the exact source.

Can any one share notes (if they have) or any online links?

Regards
Kumar

-- 
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$$ Require total timing

[Maries]

Hi,

Try this formula,* =TEXT(B2-A2,"[h]:mm:ss")*
*
*
*
*
On Mon, May 14, 2012 at 9:40 PM, Seraj Alam  wrote:

> Hi Expert,
>
>
> I have attached sheet in which I need total time taken in column C, I have
> applied formula but its not working properly. So please help me on this one.
>
>
> --
> Thanks & Regards
> Seraj Alam
> *+91 989 130 1776*
>
>  --
> 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$$ Form tracker and new base

[Deba Ranjan]

*Hi Experts,

   Very good morning, Dear groups and experts, i have some data base which
need to be created in userform, i have explained in the attached file.
Please help me sort out this problem. Thanks in advance.
*


Thanks & Regards,*
*

*Deba Ranjan P***

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


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

$$Excel-Macros$$ Require total timing

[Seraj Alam]

Hi Expert,


I have attached sheet in which I need total time taken in column C, I have
applied formula but its not working properly. So please help me on this one.


-- 
Thanks & Regards
Seraj Alam
*+91 989 130 1776*

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


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

Re: $$Excel-Macros$$ Find differences in two worksheets.

[Mr excel]

Nice different approach verma...thanks a lot.is there any formula to do
the same.i mean to find out the differences between the two sheets.

-- 
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$$ Re: Vlookup, Index, Match, Offset function in VBA Coading!!!!!!!!

[Chris Terrell]

These Youtube Videos my might Help

http://youtu.be/nZfySb0FI8w - A VBA Formula Trick

http://youtu.be/W82P4cxVK3M - Application.WorksheetFunction 



On Monday, May 14, 2012 4:23:28 AM UTC-6, Bullet wrote:
>
>
> Hi All,
>
> Can anyone explain how to use Vlookup, Index, Match, Offset function in 
> VBA Coading
>
> -- 
> Indrajit
>
> 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.
>

-- 
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$$ Re: Printing sheets in colour using VBA in ecel

[Asa Rossoff]

Hi Sunny,

I know it's one of those two.  To help I need to know which one.

 

Asa

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Sunny Kapoor
Sent: Monday, May 14, 2012 1:04 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: Printing sheets in colour using VBA in
ecel

 

yes. Just like that. But , the macro doesn't print in colour.

 

Sunny

On Mon, May 14, 2012 at 10:00 PM, Asa Rossoff  wrote:

Sunny, when you say "manually print in color" how do you do that?

 

Do you click on Printer Settings or Page Setup to select that option?

Asa

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Sunny Kapoor
Sent: Monday, May 14, 2012 12:55 PM 


To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: Printing sheets in colour using VBA in
ecel

 

Hmm, 

 

Well, do you think of something thats avoiding the macro from printing in
colour??

 

Sunny

On Mon, May 14, 2012 at 9:53 PM, dguillett1  wrote:

My ans was based on what you sent

 

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

 

From: Sunny Kapoor   

Sent: Monday, May 14, 2012 2:38 PM

To: excel-macros@googlegroups.com 

Subject: Re: $$Excel-Macros$$ Re: Printing sheets in colour using VBA in
ecel

 

well, Thanks for your reply.

 

However, the file is quite big with more than 25 sheets. I sent one sheet to
give an example. 

Now, the file will be  used by many people but everyone would be interested
in different sheets. The problem i am facing currently, like you must have
seen is, the macro prints only black and white  but manually you can print
in colour, I would like the macro to print in colour ...

 

Please see if you could help :)

 

Thanks again,

Sunny

On Mon, May 14, 2012 at 9:34 PM, dguillett1  wrote:

Based on the file you sent me with ONE sheet with graphs the easiest way
would be to set up an additional printer with ONLY grayscale and call it bw
or whatever and then print to that printer for bw and the other for color.

Application.Dialogs(xlDialogPrinterSetup).Show

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

 

From: Sunny Kapoor   

Sent: Monday, May 14, 2012 11:02 AM

To: excel-macros@googlegroups.com 

Subject: $$Excel-Macros$$ Re: Printing sheets in colour using VBA in ecel

 

Hi,

 

I have attached the file...Please let me know what should i do...

 

Thanks in advance,

Sunny
On Monday, 14 May 2012 16:56:25 UTC+2, Sunny Kapoor wrote:

Hi Guys,

 

I am trting to print sheets in colour using VBA. 

I am using the following code...

 



Sub Print_sheet()

With ActiveSheet

 

.PageSetup.BlackAndWhite = False


.PrintOut Copies:=1, Collate:=True

End With

 

End Sub
__

 

 

I have put Buttons on each sheet and assigned this macro to every button.
The problem is that for some sheets, the macro prints the sheets in colour
while for some others, it prints them in Black & White.

 

Ant help would be appreciated...

Cheers,

Sunny


On Monday, 14 May 2012 16:56:25 UTC+2, Sunny Kapoor wrote: 

Hi Guys,

 

I am trting to print sheets in colour using VBA. 

I am using the following code...

 



Sub Print_sheet()

With ActiveSheet

 

.PageSetup.BlackAndWhite = False


.PrintOut Copies:=1, Collate:=True

End With

 

End Sub
__

 

 

I have put Buttons on each sheet and assigned this macro to every button.
The problem is that for some sheets, the macro prints the sheets in colour
while for some others, it prints them in Black & White.

 

Ant help would be appreciated...

Cheers,

Sunny


On Monday, 14 May 2012 16:56:25 UTC+2, Sunny Kapoor wrote: 

Hi Guys,

 

I am trting to print sheets in colour using VBA. 

I am using the following code...

 



Sub Print_sheet()

With ActiveSheet

 

.PageSetup.BlackAndWhite = False


.PrintOut Copies:=1, Collate:=True

End With

 

End Sub
__

 

 

I have put Buttons on each sheet and assigned this macro to every button.
The problem is that for some sheets, the macro prints the sheets in colour
while for some others, it prints them in Black & White.

 

Ant help would be appreciated...

Cheers,

Sunny

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

Re: $$Excel-Macros$$ Vlookup, Index, Match, Offset function in VBA Coading!!!!!!!!

[Indrajit $nai]

Thanks a lot to all of you.


On Mon, May 14, 2012 at 9:44 PM, Rajan_Verma wrote:

> ** **
>
> You can put the entire Formula in Evaluate Function of VBA 
>
> ** **
>
> *Range("A1").Value=Evaluate("=Vlookup(1, D1:D5,2,0)")*
>
> *Range("A1").Value=Evaluate("=Index(D1:E5,Match(1,D1:D5,0),2)")*
>
> ** **
>
> ** **
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai
> *Sent:* 14 May 2012 7:15
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Vlookup, Index, Match, Offset function in
> VBA Coading
>
> ** **
>
> Thanks for the suggestion.I know the formula, but how can I migrate
> those formulas with VBA Coding.
>
>
> 
>
> On Mon, May 14, 2012 at 6:40 PM, Rajan_Verma 
> wrote:
>
> Hi 
>
> *You can refer Excel Formula Help to understand how they work **J*
>
>  
>
>  
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
>  
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai
> *Sent:* 14 May 2012 3:53
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Vlookup, Index, Match, Offset function in VBA
> Coading
>
>  
>
>
> 
>
> Hi All,
>
>  
>
> Can anyone explain how to use Vlookup, Index, Match, Offset function in
> VBA Coading
>
>  
>
> --
> Indrajit
>
> 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.
>
> --
> 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
>
>
>
>
> --
> Indrajit Snai
> +91 9051755745
> talk2indra...@gmail.com
>
> 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.
>
> --
> 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.
>
>
> ---

Re: $$Excel-Macros$$ How to calculate WPM (Word Per Minute) in Excel (Only for numeric keys)?

[Indrajit $nai]

@ Ranjan, thanks a lot for all of your effort, but it is not working
properly, only 1st cell is working perfectly


On Mon, May 14, 2012 at 9:35 PM, Rajan_Verma wrote:

> See the attached Sheet
>
> ** **
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai
> *Sent:* 14 May 2012 7:13
>
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ How to calculate WPM (Word Per Minute) in
> Excel (Only for numeric keys)?
>
> ** **
>
> @ Ranjan, no attachment file available.can you please forward it once
> again.
>
> 
>
> On Mon, May 14, 2012 at 6:18 PM, Rajan_Verma 
> wrote:
>
> Please find the attached Sheet
>
> *I have used Validation in that table*
>
>  
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
>  
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai
> *Sent:* 14 May 2012 4:17
>
>
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ How to calculate WPM (Word Per Minute) in
> Excel (Only for numeric keys)?
>
>  
>
>
> @Ranjan, I have attached the Numeric Typing Tutor file along with this
> mail (used your code only). I need a small favor from your end. Suppose
> someone is typing the same no. which shows in the Sample No. 1 and 2, (its
> an image), but he types some wrong no. can it possible at that time (wrong
> type) shows some error message, if its possible then please send me the
> code. 
>
>  
>
>  
>
>  
>
> On Sun, May 13, 2012 at 3:19 PM, Indrajit $nai 
> wrote:
>
> Thanks a lot Ranjan.really you are Great. :)
>
> ** **
>
> On Sun, May 13, 2012 at 11:18 AM, Rajan_Verma 
> wrote:
>
>  
>
>  
>
> Try this:
>
>  
>
> Public StartTIme
>
> Public EndTime
>
> Public ResTime As String
>
>  
>
> Sub StartTimer()
>
> MsgBox "Time Start Now"
>
> StartTIme = Time
>
> End Sub
>
>  
>
> Sub EndTimer()
>
> EndTime = Time
>
>  
>
> ResTime = Format(StartTIme - EndTime, "hh:mm:ss")
>
> MsgBox "Total " &
> Range("rngFilled").SpecialCells(xlCellTypeConstants).Cells.Count & " Filled
> In " & Minute(ResTime) & " Minute " & Second(ResTime) & " Second" & "
> Time", vbInformation
>
> StartTIme = Empty
>
> EndTime = Empty
>
> End Sub
>
>  
>
>  
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
>  
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai
> *Sent:* 13 May 2012 1:35
>
>
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ How to calculate WPM (Word Per Minute) in
> Excel (Only for numeric keys)?
>
>  
>
> @Ranjan, Unprotech sheet password = 007
>
> On Sun, May 13, 2012 at 1:21 AM, Indrajit $nai 
> wrote:
>
> @Ranjan, I have attached the file, hope you can understand actually what I
> am looking for? I have used your code in it but is displaying the count
> only, means if I filled 24 cells in 3 minutes still it is showing "Total
> cells filled in a minute is 24" can you please check it once, and
> revert me the same.
>
> ** **
>
> On Fri, May 11, 2012 at 10:53 PM, Indrajit $nai 
> wrote:
>
> Thanks Ranjan.
>
>  
>
> On Fri, May 11, 2012 at 8:46 PM, Rajan_Verma 
> wrote:
>
> Hope it will work for you 
>
>  
>
> Public blnFlag As Boolean
>
>  
>
> Sub StartTimer()
>
>  
>
> If blnFlag = True Then
>
> MsgBox "Total Cells Fillled in a minute is =" &
> Sheet1.UsedRange.SpecialCells(xlCellTypeConstants).Count
>
> 'Sheet1.UsedRange.ClearContents
>
> blnFlag = False
>
> End
>
> Else
>
> MsgBox "Time Start"
>
> blnFlag = True
>
> Application.OnTime Now + TimeValue("00:01:00"), "StartTimer"
>
> End If
>
> End Sub
>
>  
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
>  
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai
> *Sent:* 11 May 2012 4:40
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ How to calculate WPM (Word Per Minute) in
> Excel (Only for numeric keys)?
>
>  
>
> Yes, Ranjan.
>
> On Sun, May 6, 2012 at 7:52 PM, Rajan_Verma 
> wrote:
>
> You mean, You want to know how many cells you can fill in a minute?
>
>  
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
>  
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai
> *Sent:* 05 May 2012 03:57
> *To:* excel-macros@googlegroups.com
> *Subject:

Re: $$Excel-Macros$$ Re: Printing sheets in colour using VBA in ecel

[Sunny Kapoor]

yes. Just like that. But , the macro doesn't print in colour.

Sunny

On Mon, May 14, 2012 at 10:00 PM, Asa Rossoff  wrote:

>  Sunny, when you say "manually print in color" how do you do that?
>
> ** **
>
> Do you click on Printer Settings or Page Setup to select that option?
>
> Asa
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Sunny Kapoor
> *Sent:* Monday, May 14, 2012 12:55 PM
>
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Re: Printing sheets in colour using VBA
> in ecel
>
>  ** **
>
> Hmm, 
>
>  
>
> Well, do you think of something thats avoiding the macro from printing in
> colour??
>
>  
>
> Sunny
>
> On Mon, May 14, 2012 at 9:53 PM, dguillett1  wrote:*
> ***
>
> My ans was based on what you sent
>
>  
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
>
>  
>
> *From:* Sunny Kapoor  
>
> *Sent:* Monday, May 14, 2012 2:38 PM
>
> *To:* excel-macros@googlegroups.com 
>
> *Subject:* Re: $$Excel-Macros$$ Re: Printing sheets in colour using VBA
> in ecel
>
>  
>
> well, Thanks for your reply.
>
>  
>
> However, the file is quite big with more than 25 sheets. I sent one sheet
> to give an example. 
>
> Now, the file will be  used by many people but everyone would be
> interested in different sheets. The problem i am facing currently, like you
> must have seen is, the macro prints only black and white  but manually you
> can print in colour, I would like the macro to print in colour ...
>
>  
>
> Please see if you could help :)
>
>  
>
> Thanks again,
>
> Sunny
>
> On Mon, May 14, 2012 at 9:34 PM, dguillett1  wrote:*
> ***
>
> Based on the file you sent me with ONE sheet with graphs the easiest way
> would be to set up an additional printer with ONLY grayscale and call it bw
> or whatever and then print to that printer for bw and the other for color.
> 
>
> Application.Dialogs(xlDialogPrinterSetup).Show
>
>  Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
>
>  
>
> *From:* Sunny Kapoor  
>
> *Sent:* Monday, May 14, 2012 11:02 AM
>
> *To:* excel-macros@googlegroups.com 
>
> *Subject:* $$Excel-Macros$$ Re: Printing sheets in colour using VBA in
> ecel
>
>  
>
> Hi,
>
>  
>
> I have attached the file...Please let me know what should i do...
>
>  
>
> Thanks in advance,
>
> Sunny
> On Monday, 14 May 2012 16:56:25 UTC+2, Sunny Kapoor wrote:
>
>  Hi Guys,
>
>  
>
> I am trting to print sheets in colour using VBA. 
>
> I am using the following code...
>
>  
>
> 
>
> Sub Print_sheet()
>
> With ActiveSheet
>
>  
>
> .PageSetup.BlackAndWhite = False
>
>
> .PrintOut Copies:=1, Collate:=True
>
> End With
>
>  
>
> End Sub
> __
>
>  
>
>  
>
> I have put Buttons on each sheet and assigned this macro to every button.
> The problem is that for some sheets, the macro prints the sheets in colour
> while for some others, it prints them in Black & White.
>
>  
>
> Ant help would be appreciated...
>
> Cheers,
>
> Sunny
>
>
> On Monday, 14 May 2012 16:56:25 UTC+2, Sunny Kapoor wrote: 
>
> Hi Guys,
>
>  
>
> I am trting to print sheets in colour using VBA. 
>
> I am using the following code...
>
>  
>
> 
>
> Sub Print_sheet()
>
> With ActiveSheet
>
>  
>
> .PageSetup.BlackAndWhite = False
>
>
> .PrintOut Copies:=1, Collate:=True
>
> End With
>
>  
>
> End Sub
> __
>
>  
>
>  
>
> I have put Buttons on each sheet and assigned this macro to every button.
> The problem is that for some sheets, the macro prints the sheets in colour
> while for some others, it prints them in Black & White.
>
>  
>
> Ant help would be appreciated...
>
> Cheers,
>
> Sunny
>
>
> On Monday, 14 May 2012 16:56:25 UTC+2, Sunny Kapoor wrote: 
>
> Hi Guys,
>
>  
>
> I am trting to print sheets in colour using VBA. 
>
> I am using the following code...
>
>  
>
> 
>
> Sub Print_sheet()
>
> With ActiveSheet
>
>  
>
> .PageSetup.BlackAndWhite = False
>
>
> .PrintOut Copies:=1, Collate:=True
>
> End With
>
>  
>
> End Sub
> __
>
>  
>
>  
>
> I have put Buttons on each sheet and assigned this macro to every button.
> The problem is that for some sheets, the macro prints the sheets in colour
> while for some others, it prints them in Black & White.
>
>  
>
> Ant help would be appreciated...
>
> Cheers,
>
> Sunny
>
> --
> FORUM RULES (986+ members already 

RE: $$Excel-Macros$$ Re: Printing sheets in colour using VBA in ecel

[Asa Rossoff]

Sunny, when you say "manually print in color" how do you do that?

 

Do you click on Printer Settings or Page Setup to select that option?

Asa

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Sunny Kapoor
Sent: Monday, May 14, 2012 12:55 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: Printing sheets in colour using VBA in
ecel

 

Hmm, 

 

Well, do you think of something thats avoiding the macro from printing in
colour??

 

Sunny

On Mon, May 14, 2012 at 9:53 PM, dguillett1  wrote:

My ans was based on what you sent

 

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

 

From: Sunny Kapoor   

Sent: Monday, May 14, 2012 2:38 PM

To: excel-macros@googlegroups.com 

Subject: Re: $$Excel-Macros$$ Re: Printing sheets in colour using VBA in
ecel

 

well, Thanks for your reply.

 

However, the file is quite big with more than 25 sheets. I sent one sheet to
give an example. 

Now, the file will be  used by many people but everyone would be interested
in different sheets. The problem i am facing currently, like you must have
seen is, the macro prints only black and white  but manually you can print
in colour, I would like the macro to print in colour ...

 

Please see if you could help :)

 

Thanks again,

Sunny

On Mon, May 14, 2012 at 9:34 PM, dguillett1  wrote:

Based on the file you sent me with ONE sheet with graphs the easiest way
would be to set up an additional printer with ONLY grayscale and call it bw
or whatever and then print to that printer for bw and the other for color.

Application.Dialogs(xlDialogPrinterSetup).Show

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

 

From: Sunny Kapoor   

Sent: Monday, May 14, 2012 11:02 AM

To: excel-macros@googlegroups.com 

Subject: $$Excel-Macros$$ Re: Printing sheets in colour using VBA in ecel

 

Hi,

 

I have attached the file...Please let me know what should i do...

 

Thanks in advance,

Sunny
On Monday, 14 May 2012 16:56:25 UTC+2, Sunny Kapoor wrote:

Hi Guys,

 

I am trting to print sheets in colour using VBA. 

I am using the following code...

 



Sub Print_sheet()

With ActiveSheet

 

.PageSetup.BlackAndWhite = False


.PrintOut Copies:=1, Collate:=True

End With

 

End Sub
__

 

 

I have put Buttons on each sheet and assigned this macro to every button.
The problem is that for some sheets, the macro prints the sheets in colour
while for some others, it prints them in Black & White.

 

Ant help would be appreciated...

Cheers,

Sunny


On Monday, 14 May 2012 16:56:25 UTC+2, Sunny Kapoor wrote: 

Hi Guys,

 

I am trting to print sheets in colour using VBA. 

I am using the following code...

 



Sub Print_sheet()

With ActiveSheet

 

.PageSetup.BlackAndWhite = False


.PrintOut Copies:=1, Collate:=True

End With

 

End Sub
__

 

 

I have put Buttons on each sheet and assigned this macro to every button.
The problem is that for some sheets, the macro prints the sheets in colour
while for some others, it prints them in Black & White.

 

Ant help would be appreciated...

Cheers,

Sunny


On Monday, 14 May 2012 16:56:25 UTC+2, Sunny Kapoor wrote: 

Hi Guys,

 

I am trting to print sheets in colour using VBA. 

I am using the following code...

 



Sub Print_sheet()

With ActiveSheet

 

.PageSetup.BlackAndWhite = False


.PrintOut Copies:=1, Collate:=True

End With

 

End Sub
__

 

 

I have put Buttons on each sheet and assigned this macro to every button.
The problem is that for some sheets, the macro prints the sheets in colour
while for some others, it prints them in Black & White.

 

Ant help would be appreciated...

Cheers,

Sunny

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

Re: $$Excel-Macros$$ Re: Printing sheets in colour using VBA in ecel

[Sunny Kapoor]

Hmm,

Well, do you think of something thats avoiding the macro from printing in
colour??

Sunny

On Mon, May 14, 2012 at 9:53 PM, dguillett1  wrote:

>   My ans was based on what you sent
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* Sunny Kapoor 
> *Sent:* Monday, May 14, 2012 2:38 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Re: Printing sheets in colour using VBA
> in ecel
>
>   well, Thanks for your reply.
>
> However, the file is quite big with more than 25 sheets. I sent one sheet
> to give an example.
> Now, the file will be  used by many people but everyone would be
> interested in different sheets. The problem i am facing currently, like you
> must have seen is, the macro prints only black and white  but manually you
> can print in colour, I would like the macro to print in colour ...
>
> Please see if you could help :)
>
> Thanks again,
> Sunny
>
> On Mon, May 14, 2012 at 9:34 PM, dguillett1  wrote:
>
>>   Based on the file you sent me with ONE sheet with graphs the easiest
>> way would be to set up an additional printer with ONLY grayscale and call
>> it bw or whatever and then print to that printer for bw and the other for
>> color.
>>
>> Application.Dialogs(xlDialogPrinterSetup).Show
>>
>>  Don Guillett
>> Microsoft MVP Excel
>> SalesAid Software
>> dguille...@gmail.com
>>
>>  *From:* Sunny Kapoor 
>> *Sent:* Monday, May 14, 2012 11:02 AM
>>  *To:* excel-macros@googlegroups.com
>> *Subject:* $$Excel-Macros$$ Re: Printing sheets in colour using VBA in
>> ecel
>>
>>   Hi,
>>
>> I have attached the file...Please let me know what should i do...
>>
>> Thanks in advance,
>> Sunny
>> On Monday, 14 May 2012 16:56:25 UTC+2, Sunny Kapoor wrote:
>>
>>> Hi Guys,
>>>
>>> I am trting to print sheets in colour using VBA.
>>> I am using the following code...
>>>
>>> __**__
>>> Sub Print_sheet()
>>> With ActiveSheet
>>>
>>> .PageSetup.BlackAndWhite = False
>>>
>>> .PrintOut Copies:=1, Collate:=True
>>> End With
>>>
>>> End Sub
>>> __**
>>>
>>>
>>> I have put Buttons on each sheet and assigned this macro to every
>>> button. The problem is that for some sheets, the macro prints the sheets in
>>> colour while for some others, it prints them in Black & White.
>>>
>>> Ant help would be appreciated...
>>> Cheers,
>>> Sunny
>>>
>>
>> On Monday, 14 May 2012 16:56:25 UTC+2, Sunny Kapoor wrote:
>>>
>>> Hi Guys,
>>>
>>> I am trting to print sheets in colour using VBA.
>>> I am using the following code...
>>>
>>> __**__
>>> Sub Print_sheet()
>>> With ActiveSheet
>>>
>>> .PageSetup.BlackAndWhite = False
>>>
>>> .PrintOut Copies:=1, Collate:=True
>>> End With
>>>
>>> End Sub
>>> __**
>>>
>>>
>>> I have put Buttons on each sheet and assigned this macro to every
>>> button. The problem is that for some sheets, the macro prints the sheets in
>>> colour while for some others, it prints them in Black & White.
>>>
>>> Ant help would be appreciated...
>>> Cheers,
>>> Sunny
>>>
>>
>> On Monday, 14 May 2012 16:56:25 UTC+2, Sunny Kapoor wrote:
>>>
>>> Hi Guys,
>>>
>>> I am trting to print sheets in colour using VBA.
>>> I am using the following code...
>>>
>>> __**__
>>> Sub Print_sheet()
>>> With ActiveSheet
>>>
>>> .PageSetup.BlackAndWhite = False
>>>
>>> .PrintOut Copies:=1, Collate:=True
>>> End With
>>>
>>> End Sub
>>> __**
>>>
>>>
>>> I have put Buttons on each sheet and assigned this macro to every
>>> button. The problem is that for some sheets, the macro prints the sheets in
>>> colour while for some others, it prints them in Black & White.
>>>
>>> Ant help would be appreciated...
>>> Cheers,
>>> Sunny
>>>
>> --
>> 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
>> 

Re: $$Excel-Macros$$ Re: Printing sheets in colour using VBA in ecel

[dguillett1]

My ans was based on what you sent

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

From: Sunny Kapoor 
Sent: Monday, May 14, 2012 2:38 PM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Re: Printing sheets in colour using VBA in ecel

well, Thanks for your reply.

However, the file is quite big with more than 25 sheets. I sent one sheet to 
give an example. 
Now, the file will be  used by many people but everyone would be interested in 
different sheets. The problem i am facing currently, like you must have seen 
is, the macro prints only black and white  but manually you can print in 
colour, I would like the macro to print in colour ...

Please see if you could help :)

Thanks again,
Sunny


On Mon, May 14, 2012 at 9:34 PM, dguillett1  wrote:

  Based on the file you sent me with ONE sheet with graphs the easiest way 
would be to set up an additional printer with ONLY grayscale and call it bw or 
whatever and then print to that printer for bw and the other for color.
Application.Dialogs(xlDialogPrinterSetup).ShowDon Guillett
  Microsoft MVP Excel
  SalesAid Software
  dguille...@gmail.com

  From: Sunny Kapoor 
  Sent: Monday, May 14, 2012 11:02 AM
  To: excel-macros@googlegroups.com 
  Subject: $$Excel-Macros$$ Re: Printing sheets in colour using VBA in ecel

  Hi,

  I have attached the file...Please let me know what should i do...

  Thanks in advance,
  Sunny
  On Monday, 14 May 2012 16:56:25 UTC+2, Sunny Kapoor wrote:
Hi Guys,

I am trting to print sheets in colour using VBA. 
I am using the following code...


Sub Print_sheet()

With ActiveSheet

.PageSetup.BlackAndWhite = False

.PrintOut Copies:=1, Collate:=True
End With

End Sub
__


I have put Buttons on each sheet and assigned this macro to every button. 
The problem is that for some sheets, the macro prints the sheets in colour 
while for some others, it prints them in Black & White.

Ant help would be appreciated...
Cheers,
Sunny

  On Monday, 14 May 2012 16:56:25 UTC+2, Sunny Kapoor wrote: 
Hi Guys,

I am trting to print sheets in colour using VBA. 
I am using the following code...


Sub Print_sheet()

With ActiveSheet

.PageSetup.BlackAndWhite = False

.PrintOut Copies:=1, Collate:=True
End With

End Sub
__


I have put Buttons on each sheet and assigned this macro to every button. 
The problem is that for some sheets, the macro prints the sheets in colour 
while for some others, it prints them in Black & White.

Ant help would be appreciated...
Cheers,
Sunny

  On Monday, 14 May 2012 16:56:25 UTC+2, Sunny Kapoor wrote: 
Hi Guys,

I am trting to print sheets in colour using VBA. 
I am using the following code...


Sub Print_sheet()

With ActiveSheet

.PageSetup.BlackAndWhite = False

.PrintOut Copies:=1, Collate:=True
End With

End Sub
__


I have put Buttons on each sheet and assigned this macro to every button. 
The problem is that for some sheets, the macro prints the sheets in colour 
while for some others, it prints them in Black & White.

Ant help would be appreciated...
Cheers,
Sunny
  -- 
  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

Re: $$Excel-Macros$$ VLOOKUP HELP NEED

[dguillett1]

Sub lookitup()
Dim c As Range
For Each c In Range("a2:a" & Cells(Rows.Count, 1).End(xlUp).Row)
c.Offset(, 1) = Columns("F").Find(c, LookIn:=xlValues, _
LookAt:=xlWhole, SearchOrder:=xlByRows, _
SearchDirection:=xlNext).Offset(, -1)
Next
End Sub



Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
-Original Message- 
From: Venkatesh Narla

Sent: Monday, May 14, 2012 1:55 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ VLOOKUP HELP NEED

Hi Rajan,
Can i get VBA code for this



Thanks,
Venkatesh.

On Tue, May 15, 2012 at 12:13 AM, Venkatesh Narla  
wrote:

Thanks a lot...

On Mon, May 14, 2012 at 11:50 PM, Rajan_Verma  
wrote:

See the attached Solution
With

Index/Match()
Lookup()


Regards
Rajan verma
+91 7838100659 [IM-Gtalk]

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

On Behalf Of Venkatesh Narla
Sent: 14 May 2012 11:30
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ VLOOKUP HELP NEED

Hi All,
I need help in Vlookup need formula.

"Hi All,
Column A has data; Column ""F"" is the range need E to pull"



10001   #N/AA   10001
10002   B   10002
10003   C   10003
10004   D   10004
10005   E   10005
10006   F   10006
10007   G   10007
10008   H   10008
10009   I   10009
10010   J   10010
10011   K   10011
10012   L   10012
10013   M   10013
10014   N   10014
10015   O   10015
10016   P   10016
10017   Q   10017
10018   R   10018
10019   S   10019
10020   T   10020

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


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

RE: $$Excel-Macros$$ Need help-- Related to UDF

[Asa Rossoff]

I had a typo in the Const line.. I seem to be getting sloppy lately!  Here
the function is, corrected:

Function LookupSomething(LookupValue, TableArray)

Const ColIndex = 3, RangeLookup = True

LookupSomething = WorksheetFunction.VLookup(LookupValue, TableArray,
ColIndex, RangeLookup)

End Function

Asa

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Asa Rossoff
Sent: Monday, May 14, 2012 12:41 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Need help-- Related to UDF

 

Hello Amol,

Sounds like you are asking for something like this:

Function LookupSomething(LookupValue, TableArray)

Const ColIndex 3, RangeLookup = True

LookupSomething = WorksheetFunction.VLookup(LookupValue, TableArray,
ColIndex, RangeLookup)

End Function

Modify the Const line for the VLOOKUP presets that you want.

 

If desired, you can create defined names for all your TableArray ranges in
the other workbook, and then the function could be called like this:

=LookupSomething($C2,Where)

Where Where can be the defined name.

 

Asa

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Amol Jadhav
Sent: Monday, May 14, 2012 6:42 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need help-- Related to UDF

 

Hi Experts,

 

I need your help to create UDF

 

I want to create udf which will work as same as vlookup. Here my lookup
value will be from column C for ex. $C2, my table array range will be from
different workbook called export ,my column index no also fixed i.e 3.

 

So my lookup value is fixed column, my table array range -- my table array
range may vary so it must be dynamic and my column index no also fixed

 

I know vlook up function and its works fine for me. but issue is I have team
of 30 member they don't know anything about excel. So it will be great help
for me. so I will just put my udf and drag it and I will get output from
export sheet

 

 

-- 
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 help-- Related to UDF

[Asa Rossoff]

Hello Amol,

Sounds like you are asking for something like this:

Function LookupSomething(LookupValue, TableArray)

Const ColIndex 3, RangeLookup = True

LookupSomething = WorksheetFunction.VLookup(LookupValue, TableArray,
ColIndex, RangeLookup)

End Function

Modify the Const line for the VLOOKUP presets that you want.

 

If desired, you can create defined names for all your TableArray ranges in
the other workbook, and then the function could be called like this:

=LookupSomething($C2,Where)

Where Where can be the defined name.

 

Asa

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Amol Jadhav
Sent: Monday, May 14, 2012 6:42 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need help-- Related to UDF

 

Hi Experts,

 

I need your help to create UDF

 

I want to create udf which will work as same as vlookup. Here my lookup
value will be from column C for ex. $C2, my table array range will be from
different workbook called export ,my column index no also fixed i.e 3.

 

So my lookup value is fixed column, my table array range -- my table array
range may vary so it must be dynamic and my column index no also fixed

 

I know vlook up function and its works fine for me. but issue is I have team
of 30 member they don't know anything about excel. So it will be great help
for me. so I will just put my udf and drag it and I will get output from
export sheet

 

 

-- 
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$$ Re: Printing sheets in colour using VBA in ecel

[Sunny Kapoor]

well, Thanks for your reply.

However, the file is quite big with more than 25 sheets. I sent one sheet
to give an example.
Now, the file will be  used by many people but everyone would be interested
in different sheets. The problem i am facing currently, like you must have
seen is, the macro prints only black and white  but manually you can print
in colour, I would like the macro to print in colour ...

Please see if you could help :)

Thanks again,
Sunny

On Mon, May 14, 2012 at 9:34 PM, dguillett1  wrote:

>   Based on the file you sent me with ONE sheet with graphs the easiest
> way would be to set up an additional printer with ONLY grayscale and call
> it bw or whatever and then print to that printer for bw and the other for
> color.
>
> Application.Dialogs(xlDialogPrinterSetup).Show
>
>  Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* Sunny Kapoor 
> *Sent:* Monday, May 14, 2012 11:02 AM
>  *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Re: Printing sheets in colour using VBA in
> ecel
>
>   Hi,
>
> I have attached the file...Please let me know what should i do...
>
> Thanks in advance,
> Sunny
> On Monday, 14 May 2012 16:56:25 UTC+2, Sunny Kapoor wrote:
>
>> Hi Guys,
>>
>> I am trting to print sheets in colour using VBA.
>> I am using the following code...
>>
>> __**__
>> Sub Print_sheet()
>> With ActiveSheet
>>
>> .PageSetup.BlackAndWhite = False
>>
>> .PrintOut Copies:=1, Collate:=True
>> End With
>>
>> End Sub
>> __**
>>
>>
>> I have put Buttons on each sheet and assigned this macro to every button.
>> The problem is that for some sheets, the macro prints the sheets in colour
>> while for some others, it prints them in Black & White.
>>
>> Ant help would be appreciated...
>> Cheers,
>> Sunny
>>
>
> On Monday, 14 May 2012 16:56:25 UTC+2, Sunny Kapoor wrote:
>>
>> Hi Guys,
>>
>> I am trting to print sheets in colour using VBA.
>> I am using the following code...
>>
>> __**__
>> Sub Print_sheet()
>> With ActiveSheet
>>
>> .PageSetup.BlackAndWhite = False
>>
>> .PrintOut Copies:=1, Collate:=True
>> End With
>>
>> End Sub
>> __**
>>
>>
>> I have put Buttons on each sheet and assigned this macro to every button.
>> The problem is that for some sheets, the macro prints the sheets in colour
>> while for some others, it prints them in Black & White.
>>
>> Ant help would be appreciated...
>> Cheers,
>> Sunny
>>
>
> On Monday, 14 May 2012 16:56:25 UTC+2, Sunny Kapoor wrote:
>>
>> Hi Guys,
>>
>> I am trting to print sheets in colour using VBA.
>> I am using the following code...
>>
>> __**__
>> Sub Print_sheet()
>> With ActiveSheet
>>
>> .PageSetup.BlackAndWhite = False
>>
>> .PrintOut Copies:=1, Collate:=True
>> End With
>>
>> End Sub
>> __**
>>
>>
>> I have put Buttons on each sheet and assigned this macro to every button.
>> The problem is that for some sheets, the macro prints the sheets in colour
>> while for some others, it prints them in Black & White.
>>
>> Ant help would be appreciated...
>> Cheers,
>> Sunny
>>
> --
> 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, s

Re: $$Excel-Macros$$ Re: Printing sheets in colour using VBA in ecel

[dguillett1]

Based on the file you sent me with ONE sheet with graphs the easiest way would 
be to set up an additional printer with ONLY grayscale and call it bw or 
whatever and then print to that printer for bw and the other for color.
Application.Dialogs(xlDialogPrinterSetup).ShowDon Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com

From: Sunny Kapoor 
Sent: Monday, May 14, 2012 11:02 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Re: Printing sheets in colour using VBA in ecel

Hi,

I have attached the file...Please let me know what should i do...

Thanks in advance,
Sunny
On Monday, 14 May 2012 16:56:25 UTC+2, Sunny Kapoor wrote:
  Hi Guys,

  I am trting to print sheets in colour using VBA. 
  I am using the following code...

  
  Sub Print_sheet()

  With ActiveSheet

  .PageSetup.BlackAndWhite = False

  .PrintOut Copies:=1, Collate:=True
  End With

  End Sub
  __


  I have put Buttons on each sheet and assigned this macro to every button. The 
problem is that for some sheets, the macro prints the sheets in colour while 
for some others, it prints them in Black & White.

  Ant help would be appreciated...
  Cheers,
  Sunny

On Monday, 14 May 2012 16:56:25 UTC+2, Sunny Kapoor wrote: 
  Hi Guys,

  I am trting to print sheets in colour using VBA. 
  I am using the following code...

  
  Sub Print_sheet()

  With ActiveSheet

  .PageSetup.BlackAndWhite = False

  .PrintOut Copies:=1, Collate:=True
  End With

  End Sub
  __


  I have put Buttons on each sheet and assigned this macro to every button. The 
problem is that for some sheets, the macro prints the sheets in colour while 
for some others, it prints them in Black & White.

  Ant help would be appreciated...
  Cheers,
  Sunny

On Monday, 14 May 2012 16:56:25 UTC+2, Sunny Kapoor wrote: 
  Hi Guys,

  I am trting to print sheets in colour using VBA. 
  I am using the following code...

  
  Sub Print_sheet()

  With ActiveSheet

  .PageSetup.BlackAndWhite = False

  .PrintOut Copies:=1, Collate:=True
  End With

  End Sub
  __


  I have put Buttons on each sheet and assigned this macro to every button. The 
problem is that for some sheets, the macro prints the sheets in colour while 
for some others, it prints them in Black & White.

  Ant help would be appreciated...
  Cheers,
  Sunny
-- 
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$$ How to get sheet name with formula

[hilary lomotey]

tnks boss

On Mon, May 14, 2012 at 5:44 PM, Seraj Alam  wrote:

> Hi
>
> You can below code also
>
> Sub change_sheetName()
> Sheets(1).Activate
> ActiveSheet.Name = "New Sheet"
> End Sub
>
>
>
>
> On Mon, May 14, 2012 at 4:42 AM, hilary lomotey  wrote:
>
>> working Perfectly. thanks Maries
>>
>>
>> On Mon, May 14, 2012 at 11:35 AM, Maries  wrote:
>>
>>> Hi,
>>>
>>> It can be VBA Try below code,
>>>
>>> Sub ShNmeChng()
>>> Dim nme As String
>>> nme = InputBox("Enter sheet name here...")
>>> ActiveSheet.Name = nme
>>> End Sub
>>>
>>> Regards,
>>>
>>> MARIES.
>>>
>>> On Mon, May 14, 2012 at 4:27 AM, hilary lomotey wrote:
>>>
 EXCELLENT IT WORKED but i guess u cant change the sheet name with a
 formula

 On Mon, May 14, 2012 at 11:23 AM, Maries  wrote:

> Try it,
>
>
> =MID(CELL("filename"),FIND("]",CELL("filename"))+1,LEN(CELL("filename")))
>
>
> On Mon, May 14, 2012 at 4:16 AM, hilary lomotey wrote:
>
>> the name of the current sheet into one of the cells
>
>
>  --
> 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
>>>
>>
>>  --
>> 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
>>
>
>
>
> --
> Thanks & Regards
> Seraj Alam
> *+91 989 130 1776*
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 

Re: $$Excel-Macros$$ VLOOKUP HELP NEED

[Venkatesh Narla]

Hi Rajan,
Can i get VBA code for this



Thanks,
Venkatesh.

On Tue, May 15, 2012 at 12:13 AM, Venkatesh Narla  wrote:
> Thanks a lot...
>
> On Mon, May 14, 2012 at 11:50 PM, Rajan_Verma  
> wrote:
>> See the attached Solution
>> With
>>
>> Index/Match()
>> Lookup()
>>
>>
>> Regards
>> Rajan verma
>> +91 7838100659 [IM-Gtalk]
>>
>> -Original Message-
>> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
>> On Behalf Of Venkatesh Narla
>> Sent: 14 May 2012 11:30
>> To: excel-macros@googlegroups.com
>> Subject: $$Excel-Macros$$ VLOOKUP HELP NEED
>>
>> Hi All,
>> I need help in Vlookup need formula.
>>
>> "Hi All,
>> Column A has data; Column ""F"" is the range need E to pull"
>>
>>
>>
>> 10001   #N/A                    A       10001
>> 10002                           B       10002
>> 10003                           C       10003
>> 10004                           D       10004
>> 10005                           E       10005
>> 10006                           F       10006
>> 10007                           G       10007
>> 10008                           H       10008
>> 10009                           I       10009
>> 10010                           J       10010
>> 10011                           K       10011
>> 10012                           L       10012
>> 10013                           M       10013
>> 10014                           N       10014
>> 10015                           O       10015
>> 10016                           P       10016
>> 10017                           Q       10017
>> 10018                           R       10018
>> 10019                           S       10019
>> 10020                           T       10020
>>
>> --
>> 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$$ VLOOKUP HELP NEED

[Venkatesh Narla]

Thanks a lot...

On Mon, May 14, 2012 at 11:50 PM, Rajan_Verma  wrote:
> See the attached Solution
> With
>
> Index/Match()
> Lookup()
>
>
> Regards
> Rajan verma
> +91 7838100659 [IM-Gtalk]
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf Of Venkatesh Narla
> Sent: 14 May 2012 11:30
> To: excel-macros@googlegroups.com
> Subject: $$Excel-Macros$$ VLOOKUP HELP NEED
>
> Hi All,
> I need help in Vlookup need formula.
>
> "Hi All,
> Column A has data; Column ""F"" is the range need E to pull"
>
>
>
> 10001   #N/A                    A       10001
> 10002                           B       10002
> 10003                           C       10003
> 10004                           D       10004
> 10005                           E       10005
> 10006                           F       10006
> 10007                           G       10007
> 10008                           H       10008
> 10009                           I       10009
> 10010                           J       10010
> 10011                           K       10011
> 10012                           L       10012
> 10013                           M       10013
> 10014                           N       10014
> 10015                           O       10015
> 10016                           P       10016
> 10017                           Q       10017
> 10018                           R       10018
> 10019                           S       10019
> 10020                           T       10020
>
> --
> 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$$ VLOOKUP HELP NEED

[Venkatesh Narla]

Thanks Aamir.. thanks.

I can write simeple VBA code for this



On Mon, May 14, 2012 at 11:45 PM, Aamir Shahzad
 wrote:
> =OFFSET($F$1,MATCH(A2,$F$2:$F$21,0),-1)
>
> Aamir Shahzad
>
> On Mon, May 14, 2012 at 11:00 PM, Venkatesh Narla 
> wrote:
>>
>> Hi All,
>> I need help in Vlookup need formula.
>>
>> "Hi All,
>> Column A has data; Column ""F"" is the range need E to pull"
>>
>>
>> 10001   #N/A                    A       10001
>> 10002                           B       10002
>> 10003                           C       10003
>> 10004                           D       10004
>> 10005                           E       10005
>> 10006                           F       10006
>> 10007                           G       10007
>> 10008                           H       10008
>> 10009                           I       10009
>> 10010                           J       10010
>> 10011                           K       10011
>> 10012                           L       10012
>> 10013                           M       10013
>> 10014                           N       10014
>> 10015                           O       10015
>> 10016                           P       10016
>> 10017                           Q       10017
>> 10018                           R       10018
>> 10019                           S       10019
>> 10020                           T       10020
>>
>> --
>> 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
>
>
>
>
> --
>
> Regards,
>
> Aamir Shahzad
>
>
> --
> 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


VLOOKUP HELP NEED.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

RE: $$Excel-Macros$$ VLOOKUP HELP NEED

[Rajan_Verma]

See the attached Solution
With 

Index/Match()
Lookup()


Regards
Rajan verma
+91 7838100659 [IM-Gtalk]

-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Venkatesh Narla
Sent: 14 May 2012 11:30
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ VLOOKUP HELP NEED

Hi All,
I need help in Vlookup need formula.

"Hi All,
Column A has data; Column ""F"" is the range need E to pull"



10001   #N/AA   10001
10002   B   10002
10003   C   10003
10004   D   10004
10005   E   10005
10006   F   10006
10007   G   10007
10008   H   10008
10009   I   10009
10010   J   10010
10011   K   10011
10012   L   10012
10013   M   10013
10014   N   10014
10015   O   10015
10016   P   10016
10017   Q   10017
10018   R   10018
10019   S   10019
10020   T   10020

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


Copy of VLOOKUP HELP NEED.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ VLOOKUP HELP NEED

[Aamir Shahzad]

=OFFSET($F$1,MATCH(A2,$F$2:$F$21,0),-1)

Aamir Shahzad

On Mon, May 14, 2012 at 11:00 PM, Venkatesh Narla wrote:

> Hi All,
> I need help in Vlookup need formula.
>
> "Hi All,
> Column A has data; Column ""F"" is the range need E to pull"
>
>
> 10001   #N/AA   10001
> 10002   B   10002
> 10003   C   10003
> 10004   D   10004
> 10005   E   10005
> 10006   F   10006
> 10007   G   10007
> 10008   H   10008
> 10009   I   10009
> 10010   J   10010
> 10011   K   10011
> 10012   L   10012
> 10013   M   10013
> 10014   N   10014
> 10015   O   10015
> 10016   P   10016
> 10017   Q   10017
> 10018   R   10018
> 10019   S   10019
> 10020   T   10020
>
> --
> 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
>



-- 

Regards,

Aamir Shahzad

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


VLOOKUP HELP NEED.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ VLOOKUP HELP NEED

[Venkatesh Narla]

Hi All,
I need help in Vlookup need formula.

"Hi All,
Column A has data; Column ""F"" is the range need E to pull"



10001   #N/AA   10001
10002   B   10002
10003   C   10003
10004   D   10004
10005   E   10005
10006   F   10006
10007   G   10007
10008   H   10008
10009   I   10009
10010   J   10010
10011   K   10011
10012   L   10012
10013   M   10013
10014   N   10014
10015   O   10015
10016   P   10016
10017   Q   10017
10018   R   10018
10019   S   10019
10020   T   10020

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


VLOOKUP HELP NEED.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ How to get sheet name with formula

[Seraj Alam]

Hi

You can below code also

Sub change_sheetName()
Sheets(1).Activate
ActiveSheet.Name = "New Sheet"
End Sub




On Mon, May 14, 2012 at 4:42 AM, hilary lomotey  wrote:

> working Perfectly. thanks Maries
>
>
> On Mon, May 14, 2012 at 11:35 AM, Maries  wrote:
>
>> Hi,
>>
>> It can be VBA Try below code,
>>
>> Sub ShNmeChng()
>> Dim nme As String
>> nme = InputBox("Enter sheet name here...")
>> ActiveSheet.Name = nme
>> End Sub
>>
>> Regards,
>>
>> MARIES.
>>
>> On Mon, May 14, 2012 at 4:27 AM, hilary lomotey wrote:
>>
>>> EXCELLENT IT WORKED but i guess u cant change the sheet name with a
>>> formula
>>>
>>> On Mon, May 14, 2012 at 11:23 AM, Maries  wrote:
>>>
 Try it,


 =MID(CELL("filename"),FIND("]",CELL("filename"))+1,LEN(CELL("filename")))


 On Mon, May 14, 2012 at 4:16 AM, hilary lomotey wrote:

> the name of the current sheet into one of the cells


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



-- 
Thanks & Regards
Seraj Alam
*+91 989 130 1776*

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

RE: $$Excel-Macros$$ Vlookup, Index, Match, Offset function in VBA Coading!!!!!!!!

[Rajan_Verma]

 

You can put the entire Formula in Evaluate Function of VBA 

 

Range("A1").Value=Evaluate("=Vlookup(1, D1:D5,2,0)")

Range("A1").Value=Evaluate("=Index(D1:E5,Match(1,D1:D5,0),2)")

 

 

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Indrajit $nai
Sent: 14 May 2012 7:15
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Vlookup, Index, Match, Offset function in VBA
Coading

 

Thanks for the suggestion.I know the formula, but how can I migrate
those formulas with VBA Coding.




On Mon, May 14, 2012 at 6:40 PM, Rajan_Verma 
wrote:

Hi 

You can refer Excel Formula Help to understand how they work J

 

 

 

Regards

Rajan verma

+91 7838100659   [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Indrajit $nai
Sent: 14 May 2012 3:53
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Vlookup, Index, Match, Offset function in VBA
Coading

 




Hi All,

 

Can anyone explain how to use Vlookup, Index, Match, Offset function in VBA
Coading

 

-- 
Indrajit

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.

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




-- 
Indrajit Snai
+91 9051755745
talk2indra...@gmail.com 

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.

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

Re: $$Excel-Macros$$ Re: Printing sheets in colour using VBA in ecel

[dguillett1]

Send me your file and tell me your excel version. I’ll look a bit later.
When you say give the user an option to print. What do you mean. Be VERY 
specific.
What I did will should do it for each sheet in the file when it is printed.

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

From: Sunny Kapoor 
Sent: Monday, May 14, 2012 10:23 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Re: Printing sheets in colour using VBA in ecel

Hello Don,

Thanks for the reply. Actually, i ned to give the user an option to print the 
sheet if he/she wants. Also, the command ou provided does not work. The print 
out is still not coloured.

let me know if you could suggest something else...

Sunny
On Monday, 14 May 2012 16:56:25 UTC+2, Sunny Kapoor wrote:
  Hi Guys,

  I am trting to print sheets in colour using VBA. 
  I am using the following code...

  
  Sub Print_sheet()

  With ActiveSheet

  .PageSetup.BlackAndWhite = False

  .PrintOut Copies:=1, Collate:=True
  End With

  End Sub
  __


  I have put Buttons on each sheet and assigned this macro to every button. The 
problem is that for some sheets, the macro prints the sheets in colour while 
for some others, it prints them in Black & White.

  Ant help would be appreciated...
  Cheers,
  Sunny
-- 
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$$ Re: Printing sheets in colour using VBA in ecel

[Sunny Kapoor]

Hello Don,
 
Thanks for the reply. Actually, i ned to give the user an option to print 
the sheet if he/she wants. Also, the command ou provided does not work. The 
print out is still not coloured.
 
let me know if you could suggest something else...
 
Sunny
On Monday, 14 May 2012 16:56:25 UTC+2, Sunny Kapoor wrote:

> Hi Guys,
>  
> I am trting to print sheets in colour using VBA. 
> I am using the following code...
>  
> 
> Sub Print_sheet()
> With ActiveSheet
>  
> .PageSetup.BlackAndWhite = False
>
> .PrintOut Copies:=1, Collate:=True
> End With
>  
> End Sub
> __
>  
>  
> I have put Buttons on each sheet and assigned this macro to every button. 
> The problem is that for some sheets, the macro prints the sheets in colour 
> while for some others, it prints them in Black & White.
>  
> Ant help would be appreciated...
> Cheers,
> Sunny
>

-- 
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$$ Printing sheets in colour using VBA in ecel

[dguillett1]

Put this in the THISWORKBOOK module and delete your buttons. Now each sheet 
will print as desired.
If you don’t want ALL sheets in the file then you can restrict by UN commenting 
lines


Private Sub Workbook_BeforePrint(Cancel As Boolean)
‘if activesheet.name <> “dontdothisone” then
   ActiveSheet.PageSetup.BlackAndWhite =False
‘end if
End Sub


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

From: Sunny Kapoor 
Sent: Monday, May 14, 2012 9:56 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Printing sheets in colour using VBA in ecel

Hi Guys,

I am trting to print sheets in colour using VBA. 
I am using the following code...


Sub Print_sheet()

With ActiveSheet

.PageSetup.BlackAndWhite = False

.PrintOut Copies:=1, Collate:=True
End With

End Sub
__


I have put Buttons on each sheet and assigned this macro to every button. The 
problem is that for some sheets, the macro prints the sheets in colour while 
for some others, it prints them in Black & White.

Ant help would be appreciated...
Cheers,
Sunny
-- 
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$$ Printing sheets in colour using VBA in ecel

[Sunny Kapoor]

Hi Guys,
 
I am trting to print sheets in colour using VBA. 
I am using the following code...
 

Sub Print_sheet()
With ActiveSheet
 
.PageSetup.BlackAndWhite = False

.PrintOut Copies:=1, Collate:=True
End With
 
End Sub
__
 
 
I have put Buttons on each sheet and assigned this macro to every button. 
The problem is that for some sheets, the macro prints the sheets in colour 
while for some others, it prints them in Black & White.
 
Ant help would be appreciated...
Cheers,
Sunny

-- 
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$$ Re: Vlookup, Index, Match, Offset function in VBA Coading!!!!!!!!

[^*k#aK#U]

you can use any Excel function in vba via 

Application.WorksheetFunction.

Application.WorksheetFunction.VLookup(arg1,arg2,arg3,arg4)

arg= parameters required in excel functions

Application.WorksheetFunction.VLookup(range("A1").value,Range("B1:D7"),2,0) 


Best Regards,
Anubhav

On Monday, May 14, 2012 3:53:28 PM UTC+5:30, Bullet wrote:
>
>
> Hi All,
>
> Can anyone explain how to use Vlookup, Index, Match, Offset function in 
> VBA Coading
>
> -- 
> Indrajit
>
> 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.
>

-- 
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$$ Vlookup, Index, Match, Offset function in VBA Coading!!!!!!!!

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

Dear Indrajit

range("A1").value = WorksheetFunction.VlOOKUP(lookup_value,
table_array, col_index_num, [range_lookup)

Regards,
Lalit Mohan
https://www.facebook.com/buzinesstransformation


On Mon, May 14, 2012 at 7:54 PM, ╰» ℓαℓιт мσαнη
 wrote:
> Dear  Indrajit
>
> range("A1").value = WorksheetFunction.=VLOOKUP(lookup_value,
> table_array, col_index_num, [range_lookup)
>
>
> same for the other formula
>
>
> Regards,
> Lalit Mohan
> https://www.facebook.com/buzinesstransformation
>
>
> On Mon, May 14, 2012 at 7:15 PM, Indrajit $nai  
> wrote:
>> Thanks for the suggestion.I know the formula, but how can I migrate
>> those formulas with VBA Coding.
>>
>>
>>
>>
>> On Mon, May 14, 2012 at 6:40 PM, Rajan_Verma 
>> wrote:
>>>
>>> Hi
>>>
>>> You can refer Excel Formula Help to understand how they work J
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> Regards
>>>
>>> Rajan verma
>>>
>>> +91 7838100659 [IM-Gtalk]
>>>
>>>
>>>
>>> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
>>> On Behalf Of Indrajit $nai
>>> Sent: 14 May 2012 3:53
>>> To: excel-macros@googlegroups.com
>>> Subject: $$Excel-Macros$$ Vlookup, Index, Match, Offset function in VBA
>>> Coading
>>>
>>>
>>>
>>>
>>> Hi All,
>>>
>>>
>>>
>>> Can anyone explain how to use Vlookup, Index, Match, Offset function in
>>> VBA Coading
>>>
>>>
>>>
>>> --
>>> Indrajit
>>>
>>> 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.
>>>
>>> --
>>> 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
>>
>>
>>
>>
>> --
>> Indrajit Snai
>> +91 9051755745
>> talk2indra...@gmail.com
>>
>> 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.
>>
>> --
>> 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.
>>
>> ---

Re: $$Excel-Macros$$ Vlookup, Index, Match, Offset function in VBA Coading!!!!!!!!

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

Dear  Indrajit

range("A1").value = WorksheetFunction.=VLOOKUP(lookup_value,
table_array, col_index_num, [range_lookup)


same for the other formula


Regards,
Lalit Mohan
https://www.facebook.com/buzinesstransformation


On Mon, May 14, 2012 at 7:15 PM, Indrajit $nai  wrote:
> Thanks for the suggestion.I know the formula, but how can I migrate
> those formulas with VBA Coding.
>
>
>
>
> On Mon, May 14, 2012 at 6:40 PM, Rajan_Verma 
> wrote:
>>
>> Hi
>>
>> You can refer Excel Formula Help to understand how they work J
>>
>>
>>
>>
>>
>>
>>
>> Regards
>>
>> Rajan verma
>>
>> +91 7838100659 [IM-Gtalk]
>>
>>
>>
>> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
>> On Behalf Of Indrajit $nai
>> Sent: 14 May 2012 3:53
>> To: excel-macros@googlegroups.com
>> Subject: $$Excel-Macros$$ Vlookup, Index, Match, Offset function in VBA
>> Coading
>>
>>
>>
>>
>> Hi All,
>>
>>
>>
>> Can anyone explain how to use Vlookup, Index, Match, Offset function in
>> VBA Coading
>>
>>
>>
>> --
>> Indrajit
>>
>> 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.
>>
>> --
>> 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
>
>
>
>
> --
> Indrajit Snai
> +91 9051755745
> talk2indra...@gmail.com
>
> 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.
>
> --
> 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 qu

Re: $$Excel-Macros$$ Need help-- Related to UDF

[dguillett1]

Give a couple of examples of your vlookup formula(s)

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

From: Amol Jadhav 
Sent: Monday, May 14, 2012 8:42 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Need help-- Related to UDF

Hi Experts,

I need your help to create UDF

I want to create udf which will work as same as vlookup. Here my lookup value 
will be from column C for ex. $C2, my table array range will be from different 
workbook called export ,my column index no also fixed i.e 3.

So my lookup value is fixed column, my table array range -- my table array 
range may vary so it must be dynamic and my column index no also fixed

I know vlook up function and its works fine for me. but issue is I have team of 
30 member they don't know anything about excel. So it will be great help for 
me. so I will just put my udf and drag it and I will get output from export 
sheet


-- 
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$$ Vlookup, Index, Match, Offset function in VBA Coading!!!!!!!!

[Indrajit $nai]

Thanks for the suggestion.I know the formula, but how can I migrate
those formulas with VBA Coding.



On Mon, May 14, 2012 at 6:40 PM, Rajan_Verma wrote:

> Hi 
>
> *You can refer Excel Formula Help to understand how they work **J***
>
> ** **
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai
> *Sent:* 14 May 2012 3:53
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Vlookup, Index, Match, Offset function in VBA
> Coading
>
> ** **
>
>
> 
>
> Hi All,
>
> ** **
>
> Can anyone explain how to use Vlookup, Index, Match, Offset function in
> VBA Coading
>
> ** **
>
> --
> Indrajit
>
> 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.
>
> --
> 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
>



-- 
Indrajit Snai
+91 9051755745
talk2indra...@gmail.com

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.

-- 
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$$ Passing Values Between UserForms

[Shekhar Sharma]

Thanks all for the resolution.
YOu guyz are great.

On Fri, May 11, 2012 at 10:13 PM, Rajan_Verma wrote:

>  Also can assign the value to a public variable if wanted to unload first
> user form,
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Sam Mathai Chacko
> *Sent:* 11 May 2012 10:07
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Passing Values Between UserForms
>
> ** **
>
> This is one way to do it. Run UserForm1 first.
>
> Regards
> Sam Mathai Chacko
>
> On Fri, May 11, 2012 at 3:14 PM, Shekhar Sharma 
> wrote:
>
> Is it possible to pass Values between UserForms? If so, what's the syntax
> for doing it?
> Let's say I'm using this code
>
>  
>
> Private Sub CmdContinue_Click()
>Dim ws As Worksheet, sWCat1 As Range, sWCat2 As Range, Checker
>Set ws = Worksheets("Categories")
>Set Checker = 0
>For Each sWCat1 In ws.Range("A47:A53")
>   If sWCat1.Value = "Select" Then
>  MsgBox "Error 009: Weapon Skill Category Not Selected"
>  Checker = 1
>   End If
>   For Each sWCat2 In ws.Range("A47:A53")
>  If sWCat1.Value = sWCat2.Value Then
> MsgBox "Error 010: Weapon Skill Categories Cannot Be Repeated"
> Checker = 1
>  End If
>   Next sWCat2
>   If sWCat1.Offset(0, 1).Value <> 0 Then
>  Load CtrlCreate3A
>  Me.Hide
>  CtrlCreate3A.Show
>  Checker = 1
>   End If
>Next sWCat1
>If Checker <> 0 Then
>   End
>Else
>   Load CtrlCreate4
>   Me.Hide
>   CtrlCreate4.Show
>   Unload Me
>End If
> End Sub 
>
>  
>
>  
>
> Ideally I'd like to be able to pass the value of sWCat1.Value into
> UserForm CtrlCreate3A.
>
> --
> Shekhar Sharma
> 9910010060
> "Life consists not in holding good cards but in playing
> those  you hold well"
>  "Before you judge another, think of your own last mistake."
>
> --
> 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
>
>
>
>
> --
> Sam Mathai Chacko
>
> --
> 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
>



-- 
Shekhar Sharma
9910010060
"Life consists not in holding good cards but in playing
those  you hold well"
 "Before you judge another, think of your own last mistake."

-- 
FORUM RULES (986+ members a

Re: $$Excel-Macros$$ How to calculate WPM (Word Per Minute) in Excel (Only for numeric keys)?

[Indrajit $nai]

@ Ranjan, no attachment file available.can you please forward it once
again.


On Mon, May 14, 2012 at 6:18 PM, Rajan_Verma wrote:

> Please find the attached Sheet
>
> *I have used Validation in that table*
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai
> *Sent:* 14 May 2012 4:17
>
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ How to calculate WPM (Word Per Minute) in
> Excel (Only for numeric keys)?
>
> ** **
>
>
> @Ranjan, I have attached the Numeric Typing Tutor file along with this
> mail (used your code only). I need a small favor from your end. Suppose
> someone is typing the same no. which shows in the Sample No. 1 and 2, (its
> an image), but he types some wrong no. can it possible at that time (wrong
> type) shows some error message, if its possible then please send me the
> code. 
>
> ** **
>
> ** **
>
> ** **
>
> On Sun, May 13, 2012 at 3:19 PM, Indrajit $nai 
> wrote:
>
> Thanks a lot Ranjan.really you are Great. :)
>
>
>
> 
>
> On Sun, May 13, 2012 at 11:18 AM, Rajan_Verma 
> wrote:
>
>  
>
>  
>
> Try this:
>
>  
>
> Public StartTIme
>
> Public EndTime
>
> Public ResTime As String
>
>  
>
> Sub StartTimer()
>
> MsgBox "Time Start Now"
>
> StartTIme = Time
>
> End Sub
>
>  
>
> Sub EndTimer()
>
> EndTime = Time
>
>  
>
> ResTime = Format(StartTIme - EndTime, "hh:mm:ss")
>
> MsgBox "Total " &
> Range("rngFilled").SpecialCells(xlCellTypeConstants).Cells.Count & " Filled
> In " & Minute(ResTime) & " Minute " & Second(ResTime) & " Second" & "
> Time", vbInformation
>
> StartTIme = Empty
>
> EndTime = Empty
>
> End Sub
>
>  
>
>  
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
>  
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai
> *Sent:* 13 May 2012 1:35
>
>
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ How to calculate WPM (Word Per Minute) in
> Excel (Only for numeric keys)?
>
>  
>
> @Ranjan, Unprotech sheet password = 007
>
> On Sun, May 13, 2012 at 1:21 AM, Indrajit $nai 
> wrote:
>
> @Ranjan, I have attached the file, hope you can understand actually what I
> am looking for? I have used your code in it but is displaying the count
> only, means if I filled 24 cells in 3 minutes still it is showing "Total
> cells filled in a minute is 24" can you please check it once, and
> revert me the same.
>
>
>
> 
>
> On Fri, May 11, 2012 at 10:53 PM, Indrajit $nai 
> wrote:
>
> Thanks Ranjan.
>
> ** **
>
> On Fri, May 11, 2012 at 8:46 PM, Rajan_Verma 
> wrote:
>
> Hope it will work for you 
>
>  
>
> Public blnFlag As Boolean
>
>  
>
> Sub StartTimer()
>
>  
>
> If blnFlag = True Then
>
> MsgBox "Total Cells Fillled in a minute is =" &
> Sheet1.UsedRange.SpecialCells(xlCellTypeConstants).Count
>
> 'Sheet1.UsedRange.ClearContents
>
> blnFlag = False
>
> End
>
> Else
>
> MsgBox "Time Start"
>
> blnFlag = True
>
> Application.OnTime Now + TimeValue("00:01:00"), "StartTimer"
>
> End If
>
> End Sub
>
>  
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
>  
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai
> *Sent:* 11 May 2012 4:40
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ How to calculate WPM (Word Per Minute) in
> Excel (Only for numeric keys)?
>
>  
>
> Yes, Ranjan.
>
> On Sun, May 6, 2012 at 7:52 PM, Rajan_Verma 
> wrote:
>
> You mean, You want to know how many cells you can fill in a minute?
>
>  
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
>  
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai
> *Sent:* 05 May 2012 03:57
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ How to calculate WPM (Word Per Minute) in
> Excel (Only for numeric keys)?
>
>  
>
> Hi All,
>
> Can we calculate WPM (Word Per Minute) in Excel (Only for numeric keys)?
>
> Can anyone have Typing Practice kind of Macro in Excel, through that we
> can measure our typing speed?
>
> If anyone have this kind of thing then please send me the same.
>
> Thanks in advance.
>
> --
> Indrajit
> talk2indra...@gmail.com
>
> 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

Re: $$Excel-Macros$$ Split Large Excel file to multiple excel files and possible save the files

[Krishna Kumar]

Hi

Couple of links you may find useful

http://www.excelfox.com/forum/f12/split-unique-data-into-multiple-workbooks-33/

http://www.excelfox.com/forum/f2/split-data-into-multiple-workbooks-3-conditions-393/


Kris
ExcelFox 

-- 
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$$ Defining Same Name For ranges available in multiple tabs

[Shekhar Sharma]

Hi Rajan,

Thanks so much for the resolution. However I was looking for a Fuction
rather than VBA code.

On Mon, May 14, 2012 at 6:45 PM, Rajan_Verma wrote:

>  ** **
>
> ** **
>
> Try this:
>
> ** **
>
> *Function WorksheetName(lngIndex As Long) As String*
>
> *If lngIndex <= ThisWorkbook.Worksheets.Count Then*
>
> *WorksheetName = ThisWorkbook.Worksheets(lngIndex).Name*
>
> *End If*
>
> *End Function*
>
> ** **
>
> = WorksheetName(Row()) In A1 and Drag
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Shekhar Sharma
> *Sent:* 14 May 2012 5:46
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Defining Same Name For ranges available
> in multiple tabs
>
> ** **
>
> Thanks guys, it got resolved with the suggestion of 
>
>
> =SUMIF(sheet1!WBS,A1,sheet1!COST)+SUMIF(sheet2!WBS,A1,sheet2!COST)+SUMIF(sheet3!WBS,A1,sheet3!COST)
> 
>
>  
>
> ** **
>
> On Sat, May 12, 2012 at 6:48 PM, dguillett1  wrote:*
> ***
>
> This is very possible with an indirect formula or defined names or with a
> macro. Provide a file and your desires.
>
>  
>
>  
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
>
>  
>
> *From:* Shekhar Sharma  
>
> *Sent:* Friday, May 11, 2012 4:59 AM
>
> *To:* excel-macros@googlegroups.com 
>
> *Subject:* $$Excel-Macros$$ Defining Same Name For ranges available in
> multiple tabs
>
>  
>
> I'm wondering if it's possible to define one name for columns in multiple
> worksheet. Basically I'm working on an estimating spreadsheet with multiple
> sheets; each sheet contains hundreds of individual costs (separate lines)
> which are categorized into more generic numerical buckets. So each line has
> a column for the generic buck and the cost. I'd like to have a summary
> sheet with a column summarizing these numerical buckets and the total cost
> for each bucket which is added from each sheet.
>
> Let's say the generic bucket column in each tab is called WBS, and the
> cost column is called COST. In my summary tab, I'd like a formula such as
> =SUMIF(WBS,A1,COST)...but of course this doesn't work. Any ideas on how I
> can solve this?
>
>
>
> --
> Shekhar Sharma
> "Life consists not in holding good cards but in playing
> those  you hold well"
> "Before you judge another, think of your own last mistake."
> --
> 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
>
>
>
>
> --
> Shekhar Sharma
> 9910010060
> "Life consists not in holding good cards but in playing
> those  you hold well"
>  "Before you judge another, think of your own last mistake."
>
> --
> 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, for

RE: $$Excel-Macros$$ Defining Same Name For ranges available in multiple tabs

[Rajan_Verma]

 

 

Try this:

 

Function WorksheetName(lngIndex As Long) As String

If lngIndex <= ThisWorkbook.Worksheets.Count Then

WorksheetName = ThisWorkbook.Worksheets(lngIndex).Name

End If

End Function

 

= WorksheetName(Row()) In A1 and Drag

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Shekhar Sharma
Sent: 14 May 2012 5:46
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Defining Same Name For ranges available in
multiple tabs

 

Thanks guys, it got resolved with the suggestion of 

=SUMIF(sheet1!WBS,A1,sheet1!COST)+SUMIF(sheet2!WBS,A1,sheet2!COST)+SUMIF(she
et3!WBS,A1,sheet3!COST)

 

 

On Sat, May 12, 2012 at 6:48 PM, dguillett1  wrote:

This is very possible with an indirect formula or defined names or with a
macro. Provide a file and your desires.

 

 

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

 

From: Shekhar Sharma   

Sent: Friday, May 11, 2012 4:59 AM

To: excel-macros@googlegroups.com 

Subject: $$Excel-Macros$$ Defining Same Name For ranges available in
multiple tabs

 

I'm wondering if it's possible to define one name for columns in multiple
worksheet. Basically I'm working on an estimating spreadsheet with multiple
sheets; each sheet contains hundreds of individual costs (separate lines)
which are categorized into more generic numerical buckets. So each line has
a column for the generic buck and the cost. I'd like to have a summary sheet
with a column summarizing these numerical buckets and the total cost for
each bucket which is added from each sheet.

Let's say the generic bucket column in each tab is called WBS, and the cost
column is called COST. In my summary tab, I'd like a formula such as
=SUMIF(WBS,A1,COST)...but of course this doesn't work. Any ideas on how I
can solve this?



-- 
Shekhar Sharma
"Life consists not in holding good cards but in playing 
those  you hold well" 
"Before you judge another, think of your own last mistake."
-- 
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




-- 
Shekhar Sharma
9910010060
"Life consists not in holding good cards but in playing 
those  you hold well" 
 "Before you judge another, think of your own last mistake."

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

RE: $$Excel-Macros$$ Vlookup, Index, Match, Offset function in VBA Coading!!!!!!!!

[Rajan_Verma]

Hi 

You can refer Excel Formula Help to understand how they work J

 

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Indrajit $nai
Sent: 14 May 2012 3:53
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Vlookup, Index, Match, Offset function in VBA
Coading

 




Hi All,

 

Can anyone explain how to use Vlookup, Index, Match, Offset function in VBA
Coading

 

-- 
Indrajit

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.

-- 
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$$ urgently help required "how to get access field value into word table"

[Rajan_Verma]

Can you please explain more with Example and attach your file?

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Dhartikumar Sahu
Sent: 14 May 2012 12:59
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ urgently help required "how to get access field
value into word table"

 




hi group

 

need urgently help required, to get ACCESS field value into word table.

 

if any sample data that will also very helpful to me.

 

 

 

-- 

Regards,

Dhartikumar Sahu

Sr.Database Manager - Institutional Equities

 IDBI Capital Markets Services Ltd

5th Floor, Mafatlal Centre | Nariman Point | Mumbai - 21

Board: +91 22 4322 1212 | Dir: +91 22 4322 1169 | Cell: +91 77383 63450

 

-- 
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$$ Vlookup, Index, Match, Offset function in VBA Coading!!!!!!!!

[dguillett1]

I suggest you look in the vba help index for FIND  and FINDNEXT. Find the value 
and then use offset to get data.

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

From: Indrajit $nai 
Sent: Monday, May 14, 2012 5:23 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Vlookup, Index, Match, Offset function in VBA 
Coading


Hi All,

Can anyone explain how to use Vlookup, Index, Match, Offset function in VBA 
Coading

-- 
Indrajit

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.
-- 
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$$ Query for Merging two excel sheets using Command Prompt

[Rajan_Verma]

If all sheets have data in same format 

 

Sub CompileWOrksheets()

Dim wksSheet As Worksheet

With ThisWorkbook

.Worksheets.Add.Name = "Compiled"

For Each wksSheet In .Worksheets

If wksSheet.Name <> "Compiled" Then

wksSheet.UsedRange.Copy .Worksheets("Compiled").Range("A" &
.Worksheets("Compiled").Range("A" & Rows.Count).End(xlUp).Row + 1)

End If

Next wksSheet

End With

End Sub

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prajakt Pande
Sent: 14 May 2012 12:32
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Query for Merging two excel sheets using
Command Prompt

 

Dear Rakesh,

you can use following code

Sub CommandButton1()
Sheets("your sheet name").Select 'first sheet from you will copy the data

Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select
Selection.Copy
Sheets("your sheet name").Select ' where you want to paste

Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False

Sheets("your sheet name").Select 'second sheet from you will copy the data

Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select
Selection.Copy

Range("a1").End(xlDown).Offset(1).Select

Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False

End Sub
regards,
Prajakt 
Skype :- prajaktpande

On Monday, May 14, 2012 10:46:03 AM UTC+4, Prajakt Pande wrote:

Dear Rakesh,

Can you provide a sample sheet.



Thanks & Regards,
Prajakt Pande
+971551388482





On Mon, May 14, 2012 at 10:19 AM, Rakesh Kumar Sharma
 wrote:

Hi,

Plz suggest me how i can merge two excel files data to single sheet using
command prompt.


-- 
Thanks & Regards,
Rakesh Kumar Sharma





-- 
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$$ Delete Zero subtotal blocks

[dguillett1]

Provide a file with an explanation and example. One or many??

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

From: sreenivas kammari 
Sent: Monday, May 14, 2012 3:25 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Delete Zero subtotal blocks

Hi,

Is there anyone help me please on the below one.

If the subtotal value is zero..copy to those block to another sheet and delete 
the entire subtotal block.

Thank you,
Srini
-- 
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$$ Find differences in two worksheets.

[Rajan_Verma]

Try this:

Please remove Replace all error by 0 or other Characters with in Ranges
before Compare 

 

 

Sub ShowDifferen()



Dim Arr1

Dim Arr2

Dim rng1 As Range

Dim rng2 As Range



Dim lngRow As Long

Dim intCol As Integer

Set rng1 = Application.InputBox("Please select First Range", , , , , , ,
8)

Set rng2 = Application.InputBox("Please select Second Range", , , , , ,
, 8)



Arr1 = rng1

Arr2 = rng2



If UBound(Arr1, 1) = UBound(Arr2, 1) And UBound(Arr1, 2) = UBound(Arr2,
2) Then

For lngRow = LBound(Arr1) To UBound(Arr1)

For intCol = LBound(Arr1, 2) To UBound(Arr1, 2)

If Arr1(lngRow, intCol) <> Arr2(lngRow, intCol) Then

rng1.Cells(lngRow, intCol).Interior.Color = 682978

rng2.Cells(lngRow, intCol).Interior.Color = 682978

End If

Next intCol

Next lngRow

Else

MsgBox "Ranges are not same", vbInformation

End If



 

End Sub

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Mr excel
Sent: 14 May 2012 7:49
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Find differences in two worksheets.

 

I want to know  the differences between the two sheets.i.e. Main
worksheet(Master SHEET) and the Current Month(Apr'12) Worksheet.

Please give me any formula or code for finding out the differences between
the two sheets.
I m attaching the worksheet as an example..

Thanks

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


Copy of excel (2).xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ hii i need copy a row to another based on condition

[dguillett1]

Provide a file with a complete explanation.
I am a retired regional manager for ING and held a series 7 brokers license but 
have never heard of “nifty” stocks.

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

From: coolguy 
Sent: Sunday, May 13, 2012 11:35 PM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ hii i need copy a row to another based on condition

Hiii 


i need a help ..

i have an excel sheet which changes dyamically and gives the word "BUY" in a 
cell C3

when C3 = buy i need to copy the values A3 B3 and D3 to another sheet .. ( like 
a call generate page)  


and also a pop up alert when there is a buy condition


i need this for tracking nifty 50 stocks


thankyou



-- 
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$$ How to calculate WPM (Word Per Minute) in Excel (Only for numeric keys)?

[Rajan_Verma]

Please find the attached Sheet

I have used Validation in that table

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Indrajit $nai
Sent: 14 May 2012 4:17
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ How to calculate WPM (Word Per Minute) in
Excel (Only for numeric keys)?

 


@Ranjan, I have attached the Numeric Typing Tutor file along with this mail
(used your code only). I need a small favor from your end. Suppose someone
is typing the same no. which shows in the Sample No. 1 and 2, (its an
image), but he types some wrong no. can it possible at that time (wrong
type) shows some error message, if its possible then please send me the
code. 

 

 

 

On Sun, May 13, 2012 at 3:19 PM, Indrajit $nai 
wrote:

Thanks a lot Ranjan.really you are Great. :)





On Sun, May 13, 2012 at 11:18 AM, Rajan_Verma 
wrote:

 

 

Try this:

 

Public StartTIme

Public EndTime

Public ResTime As String

 

Sub StartTimer()

MsgBox "Time Start Now"

StartTIme = Time

End Sub

 

Sub EndTimer()

EndTime = Time

 

ResTime = Format(StartTIme - EndTime, "hh:mm:ss")

MsgBox "Total " &
Range("rngFilled").SpecialCells(xlCellTypeConstants).Cells.Count & " Filled
In " & Minute(ResTime) & " Minute " & Second(ResTime) & " Second" & " Time",
vbInformation

StartTIme = Empty

EndTime = Empty

End Sub

 

 

 

Regards

Rajan verma

+91 7838100659   [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Indrajit $nai
Sent: 13 May 2012 1:35


To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ How to calculate WPM (Word Per Minute) in
Excel (Only for numeric keys)?

 

@Ranjan, Unprotech sheet password = 007

On Sun, May 13, 2012 at 1:21 AM, Indrajit $nai 
wrote:

@Ranjan, I have attached the file, hope you can understand actually what I
am looking for? I have used your code in it but is displaying the count
only, means if I filled 24 cells in 3 minutes still it is showing "Total
cells filled in a minute is 24" can you please check it once, and
revert me the same.





On Fri, May 11, 2012 at 10:53 PM, Indrajit $nai 
wrote:

Thanks Ranjan.

 

On Fri, May 11, 2012 at 8:46 PM, Rajan_Verma 
wrote:

Hope it will work for you 

 

Public blnFlag As Boolean

 

Sub StartTimer()

 

If blnFlag = True Then

MsgBox "Total Cells Fillled in a minute is =" &
Sheet1.UsedRange.SpecialCells(xlCellTypeConstants).Count

'Sheet1.UsedRange.ClearContents

blnFlag = False

End

Else

MsgBox "Time Start"

blnFlag = True

Application.OnTime Now + TimeValue("00:01:00"), "StartTimer"

End If

End Sub

 

 

Regards

Rajan verma

+91 7838100659   [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Indrajit $nai
Sent: 11 May 2012 4:40
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ How to calculate WPM (Word Per Minute) in
Excel (Only for numeric keys)?

 

Yes, Ranjan.

On Sun, May 6, 2012 at 7:52 PM, Rajan_Verma 
wrote:

You mean, You want to know how many cells you can fill in a minute?

 

 

Regards

Rajan verma

+91 7838100659   [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Indrajit $nai
Sent: 05 May 2012 03:57
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ How to calculate WPM (Word Per Minute) in Excel
(Only for numeric keys)?

 

Hi All,

Can we calculate WPM (Word Per Minute) in Excel (Only for numeric keys)?

Can anyone have Typing Practice kind of Macro in Excel, through that we can
measure our typing speed?

If anyone have this kind of thing then please send me the same.

Thanks in advance.

-- 
Indrajit
talk2indra...@gmail.com 

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.

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

Re: $$Excel-Macros$$ Defining Same Name For ranges available in multiple tabs

[dguillett1]

Not the BEST solution.

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

From: Shekhar Sharma 
Sent: Monday, May 14, 2012 7:16 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Defining Same Name For ranges available in 
multiple tabs

Thanks guys, it got resolved with the suggestion of 
=SUMIF(sheet1!WBS,A1,sheet1!COST)+SUMIF(sheet2!WBS,A1,sheet2!COST)+SUMIF(sheet3!WBS,A1,sheet3!COST)





On Sat, May 12, 2012 at 6:48 PM, dguillett1  wrote:

  This is very possible with an indirect formula or defined names or with a 
macro. Provide a file and your desires.


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

  From: Shekhar Sharma 
  Sent: Friday, May 11, 2012 4:59 AM
  To: excel-macros@googlegroups.com 
  Subject: $$Excel-Macros$$ Defining Same Name For ranges available in multiple 
tabs

  I'm wondering if it's possible to define one name for columns in multiple 
worksheet. Basically I'm working on an estimating spreadsheet with multiple 
sheets; each sheet contains hundreds of individual costs (separate lines) which 
are categorized into more generic numerical buckets. So each line has a column 
for the generic buck and the cost. I'd like to have a summary sheet with a 
column summarizing these numerical buckets and the total cost for each bucket 
which is added from each sheet.

  Let's say the generic bucket column in each tab is called WBS, and the cost 
column is called COST. In my summary tab, I'd like a formula such as 
=SUMIF(WBS,A1,COST)...but of course this doesn't work. Any ideas on how I can 
solve this?



  -- 
  Shekhar Sharma
  "Life consists not in holding good cards but in playing 
  those  you hold well" 
  "Before you judge another, think of your own last mistake."
  -- 
  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




-- 
Shekhar Sharma
9910010060
"Life consists not in holding good cards but in playing 
those  you hold well" 
"Before you judge another, think of your own last mistake."
-- 
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

Re: $$Excel-Macros$$ Split Large Excel file to multiple excel files and possible save the files

[dguillett1]

You may send to my personal email with an example. If you need to email or 
print you shouldn’t need to create at file for each. Simply create a report for 
each or email each. Details of your NEED for a separate file..

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

From: Shekhar Sharma 
Sent: Monday, May 14, 2012 7:37 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Split Large Excel file to multiple excel files and 
possible save the files

Hello Frndz,

I have a killing task to create for all students specified xls for each parent 
with grades etc..

The data is retrieved from a large database.

1. I want to create specific sheets for each student from the massive excel file

I want to create the sheet name by the name in A5 and H5
The data i want to retrive is in A to U columns until a new name comes in 
Column A
I have three headers that needs also to come along too
.

2. Then I want to save the new sheets with the students name and class in a 
folder X:\students


Sorry in my office, I don't have permission to upload any file, so request you 
to help by creating your own dummy data or provide me your mail id, so that I 
can fwd from any other source.

Thanks,



-- 
Shekhar Sharma
9910010060
"Life consists not in holding good cards but in playing 
those  you hold well" 
"Before you judge another, think of your own last mistake."

-- 
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$$ Defining Same Name For ranges available in multiple tabs

[Shekhar Sharma]

Thanks guys, it got resolved with the suggestion of

=SUMIF(sheet1!WBS,A1,sheet1!COST)+SUMIF(sheet2!WBS,A1,sheet2!COST)+SUMIF(sheet3!WBS,A1,sheet3!COST)


** **

On Sat, May 12, 2012 at 6:48 PM, dguillett1  wrote:

>   This is very possible with an indirect formula or defined names or with
> a macro. Provide a file and your desires.
>
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* Shekhar Sharma 
>  *Sent:* Friday, May 11, 2012 4:59 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Defining Same Name For ranges available in
> multiple tabs
>
>  I'm wondering if it's possible to define one name for columns in
> multiple worksheet. Basically I'm working on an estimating spreadsheet with
> multiple sheets; each sheet contains hundreds of individual costs (separate
> lines) which are categorized into more generic numerical buckets. So each
> line has a column for the generic buck and the cost. I'd like to have a
> summary sheet with a column summarizing these numerical buckets and the
> total cost for each bucket which is added from each sheet.
>
> Let's say the generic bucket column in each tab is called WBS, and the
> cost column is called COST. In my summary tab, I'd like a formula such as
> =SUMIF(WBS,A1,COST)...but of course this doesn't work. Any ideas on how I
> can solve this?
>
>
>
> --
> Shekhar Sharma
> "Life consists not in holding good cards but in playing
> those  you hold well"
> "Before you judge another, think of your own last mistake."
> --
> 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
>



-- 
Shekhar Sharma
9910010060
"Life consists not in holding good cards but in playing
those  you hold well"
 "Before you judge another, think of your own last mistake."

-- 
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$$ urgently help required "how to get access field value into word table"

[dguillett1]

Why is your request more urgent than other requests

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

From: Dhartikumar Sahu 
Sent: Monday, May 14, 2012 2:28 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ urgently help required "how to get access field value 
into word table"


hi group

need urgently help required, to get ACCESS field value into word table.

if any sample data that will also very helpful to me.



-- 

Regards,

Dhartikumar Sahu

Sr.Database Manager - Institutional Equities

 IDBI Capital Markets Services Ltd

5th Floor, Mafatlal Centre | Nariman Point | Mumbai – 21

Board: +91 22 4322 1212 | Dir: +91 22 4322 1169 | Cell: +91 77383 63450


-- 
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$$ How to get sheet name with formula

[hilary lomotey]

working Perfectly. thanks Maries

On Mon, May 14, 2012 at 11:35 AM, Maries  wrote:

> Hi,
>
> It can be VBA Try below code,
>
> Sub ShNmeChng()
> Dim nme As String
> nme = InputBox("Enter sheet name here...")
> ActiveSheet.Name = nme
> End Sub
>
> Regards,
>
> MARIES.
>
> On Mon, May 14, 2012 at 4:27 AM, hilary lomotey  wrote:
>
>> EXCELLENT IT WORKED but i guess u cant change the sheet name with a
>> formula
>>
>> On Mon, May 14, 2012 at 11:23 AM, Maries  wrote:
>>
>>> Try it,
>>>
>>> =MID(CELL("filename"),FIND("]",CELL("filename"))+1,LEN(CELL("filename")))
>>>
>>>
>>> On Mon, May 14, 2012 at 4:16 AM, hilary lomotey wrote:
>>>
 the name of the current sheet into one of the cells
>>>
>>>
>>>  --
>>> 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
>

-- 
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$$ How to get sheet name with formula

[Maries]

Hi,

It can be VBA Try below code,

Sub ShNmeChng()
Dim nme As String
nme = InputBox("Enter sheet name here...")
ActiveSheet.Name = nme
End Sub

Regards,

MARIES.

On Mon, May 14, 2012 at 4:27 AM, hilary lomotey  wrote:

> EXCELLENT IT WORKED but i guess u cant change the sheet name with a
> formula
>
> On Mon, May 14, 2012 at 11:23 AM, Maries  wrote:
>
>> Try it,
>>
>> =MID(CELL("filename"),FIND("]",CELL("filename"))+1,LEN(CELL("filename")))
>>
>>
>> On Mon, May 14, 2012 at 4:16 AM, hilary lomotey wrote:
>>
>>> the name of the current sheet into one of the cells
>>
>>
>>  --
>> 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$$ How to get sheet name with formula

[hilary lomotey]

EXCELLENT IT WORKED but i guess u cant change the sheet name with a formula

On Mon, May 14, 2012 at 11:23 AM, Maries  wrote:

> Try it,
>
> =MID(CELL("filename"),FIND("]",CELL("filename"))+1,LEN(CELL("filename")))
>
>
> On Mon, May 14, 2012 at 4:16 AM, hilary lomotey  wrote:
>
>> the name of the current sheet into one of the cells
>
>
>  --
> 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$$ How to get sheet name with formula

[Maries]

Try it,

=MID(CELL("filename"),FIND("]",CELL("filename"))+1,LEN(CELL("filename")))

On Mon, May 14, 2012 at 4:16 AM, hilary lomotey  wrote:

> the name of the current sheet into one of the cells

-- 
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$$ How to get sheet name with formula

[hilary lomotey]

Hello Guys,

is there any way to get the name of the current sheet into one of the cells
WITHOUT vb code? thanks

-- 
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$$ Vlookup, Index, Match, Offset function in VBA Coading!!!!!!!!

[Indrajit $nai]

Hi All,

Can anyone explain how to use Vlookup, Index, Match, Offset function in VBA
Coading

-- 
Indrajit

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.

-- 
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$$ একটি নতুন সামাজিক আয়ের সাইট

[B M Zakaria Sajib]

বন্ধুরা আজকে আপনাদের সবাইকে একটি নতুন সামাজিক আয় করার সাইটের সাথে পরিচয় 
করিয়ে দিব। জেনে খুশি হবেন যে সাইটটি বাংলাদেশীদের এবং দারুন একটি সাইট। 
সাইটটি Facebook এবং Odesk এর সমন্বয়ে তৈরি করা। মানে হল আপনার এই সাইটটিতে 
Facebook এর মত করে নতুন বন্ধুর তৈরি করতে পারবেন আবার Odesk এর মত আয়ও করতে 
পারবেন।

কি দারুন না সইটটি? আপনি একবার ঘুরে আসুন সইটটি থেকে, দারুন ভাল লাগবে। শুধু 
তাই নয়, আপনি ইচ্ছা করলে Grameen Phone এর Cell Bazaar এর মত করে পন্য আপলোড ও 
করতে পারবেন বিক্রির জন্য।

এছাড়া গান আপলোড করতে পারবেন, সাথে সাথে নিজের প্রোফাইল তৈরি করতে পারবেন, আছে 
Blog, Forum এর সকল সুবিধা এবংএছাড়া ও অনেক অনেক নতুন কিছু আছে, যা সাধারনত 
একটি সাইটে পাওয়া যায় না।

সবচেয়ে বড় কথা হল সাইটটি বাংলাদেশের তৈরি সাইট এবং আমাদের জন্যই সাইটটি তৈরি 
করা হয়েছে। তাই চলুন সবাই মিলে তাদের সহায্য করি এবং আমাদের নিজেদেরকে সবার 
সামনে তুলে ধরি।

 দয়া করে ভিজিট করুন- 
http://www.fbcaffe.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$$ Find differences in two worksheets.

[Anil Gawli]

PLs see attached file

On Mon, May 14, 2012 at 7:49 AM, Mr excel  wrote:

> I want to know  the differences between the two sheets.i.e. Main
> worksheet(Master SHEET) and the Current Month(Apr'12) Worksheet.
>
> Please give me any formula or code for finding out the differences between
> the two sheets.
> I m attaching the worksheet as an example..
>
> Thanks
>
> --
> 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
>



-- 
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd

-- 
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.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Delete Zero subtotal blocks

[sreenivas kammari]

Hi,
 
Is there anyone help me please on the below one.
 
If the subtotal value is zero..copy to those block to another sheet and 
delete the entire subtotal block.
 
Thank you,
Srini

-- 
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$$ urgently help required "how to get access field value into word table"

[Dhartikumar Sahu]

hi group

need urgently help required, to get ACCESS field value into word table.

if any sample data that will also very helpful to me.



-- 

*Regards,*

*Dhartikumar Sahu*

Sr.Database Manager - Institutional Equities

* **IDBI Capital Markets Services Ltd*

5th Floor, Mafatlal Centre | Nariman Point | Mumbai – 21

Board: +91 22 4322 1212 | Dir: +91 22 4322 1169 | Cell: +91 77383 63450

-- 
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$$ Query for Merging two excel sheets using Command Prompt

[Prajakt Pande]

Dear Rakesh,

you can use following code

Sub CommandButton1()
Sheets("your sheet name").Select 'first sheet from you will copy the data

Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select
Selection.Copy
Sheets("your sheet name").Select ' where you want to paste

Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False

Sheets("your sheet name").Select 'second sheet from you will copy the data

Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select
Selection.Copy

Range("a1").End(xlDown).Offset(1).Select

Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False

End Sub
regards,
Prajakt 
Skype :- prajaktpande

On Monday, May 14, 2012 10:46:03 AM UTC+4, Prajakt Pande wrote:
>
> Dear Rakesh,
>
> Can you provide a sample sheet.
>
> Thanks & Regards,
> Prajakt Pande
> +971551388482
> **
>
>
>
> On Mon, May 14, 2012 at 10:19 AM, Rakesh Kumar Sharma <
> rakeshks@gmail.com> wrote:
>
>> Hi,
>>
>> Plz suggest me how i can merge two excel files data to single sheet using 
>> command prompt.
>>
>>
>> -- 
>> Thanks & Regards,
>> Rakesh Kumar Sharma
>>
>>
>>
>>
>>  -- 
>> 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