date:20121120

Re: $$Excel-Macros$$ Re: Split a cell into multiple cells in Excel 2010

2012-11-20 Thread chhajersandeep

Dear Rakesh,

Do you want a text to be divided into different column based on some operators? 
Then you can use "Text to column" to split a cell (read a cell containing text) 
to many cells (i.e. Columns).
If this help is not sufficient then please share workbook with us as Anil bhai 
has suggested.

Sandeep Kumar Chhajer.

Sent on my BlackBerry® from Vodafone

-Original Message-
From: Rakesh Kumar Sharma 
Sender: excel-macros@googlegroups.com
Date: Wed, 21 Nov 2012 12:21:11 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: Split a cell into multiple cells in Excel 2010

Hi Anil,
Pls find the attached sample sheet.



On Wed, Nov 21, 2012 at 11:53 AM, अनिल नारायण गवली
wrote:

> dear Rakesh,
>
> Pl specify you query to understand better.Or share a sample workbook with
> us
>
> Regards,
> Gawli Anil
>
>
>
>
> On Wed, Nov 21, 2012 at 11:47 AM, Prince  wrote:
>
>> Hi Rakesh,
>>
>> Do you want to split data of a cell into multiple cell or somthing else
>> ???
>>
>> Regards
>> Prince.
>>
>> On Wednesday, November 21, 2012 11:43:59 AM UTC+5:30, rakesh sharma wrote:
>>>
>>> Hi experts,
>>> I want to split a cell to multiple cells. Pls help me.
>>>
>>> --
>>> Regards,
>>>
>>> Rakesh Kumar Sharma
>>> Contact: +91-9971024741
>>>
>>>
>>>  --
>> Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>
>>
>>
>
>
>
> --
> Thanks & Regards,
> Gawli Anil Narayan
> Software Developer,
> Abacus Software Services Pvt Ltd
>
>  --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>



-- 
Regards,

Rakesh Kumar Sharma
Contact: +91-9971024741

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

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



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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or

Re: $$Excel-Macros$$ Re: Split a cell into multiple cells in Excel 2010

2012-11-20 Thread Rakesh Kumar Sharma

Hi Anil,
Pls find the attached sample sheet.



On Wed, Nov 21, 2012 at 11:53 AM, अनिल नारायण गवली
wrote:

> dear Rakesh,
>
> Pl specify you query to understand better.Or share a sample workbook with
> us
>
> Regards,
> Gawli Anil
>
>
>
>
> On Wed, Nov 21, 2012 at 11:47 AM, Prince  wrote:
>
>> Hi Rakesh,
>>
>> Do you want to split data of a cell into multiple cell or somthing else
>> ???
>>
>> Regards
>> Prince.
>>
>> On Wednesday, November 21, 2012 11:43:59 AM UTC+5:30, rakesh sharma wrote:
>>>
>>> Hi experts,
>>> I want to split a cell to multiple cells. Pls help me.
>>>
>>> --
>>> Regards,
>>>
>>> Rakesh Kumar Sharma
>>> Contact: +91-9971024741
>>>
>>>
>>>  --
>> Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>
>>
>>
>
>
>
> --
> Thanks & Regards,
> Gawli Anil Narayan
> Software Developer,
> Abacus Software Services Pvt Ltd
>
>  --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>



-- 
Regards,

Rakesh Kumar Sharma
Contact: +91-9971024741

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

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




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

Re: $$Excel-Macros$$ Re: Split a cell into multiple cells in Excel 2010

2012-11-20 Thread अनिल नारायण गवली

dear Rakesh,

Pl specify you query to understand better.Or share a sample workbook with us

Regards,
Gawli Anil




On Wed, Nov 21, 2012 at 11:47 AM, Prince  wrote:

> Hi Rakesh,
>
> Do you want to split data of a cell into multiple cell or somthing else ???
>
> Regards
> Prince.
>
> On Wednesday, November 21, 2012 11:43:59 AM UTC+5:30, rakesh sharma wrote:
>>
>> Hi experts,
>> I want to split a cell to multiple cells. Pls help me.
>>
>> --
>> Regards,
>>
>> Rakesh Kumar Sharma
>> Contact: +91-9971024741
>>
>>
>>  --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>



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

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

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

$$Excel-Macros$$ Re: Split a cell into multiple cells in Excel 2010

2012-11-20 Thread Prince

Hi Rakesh,

Do you want to split data of a cell into multiple cell or somthing else ???

Regards
Prince.

On Wednesday, November 21, 2012 11:43:59 AM UTC+5:30, rakesh sharma wrote:
>
> Hi experts,
> I want to split a cell to multiple cells. Pls help me.
>
> -- 
> Regards,
>
> Rakesh Kumar Sharma
> Contact: +91-9971024741
>
>
>

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

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

Re: $$Excel-Macros$$ dear experts is there any solution for pick the step value in certain table

2012-11-20 Thread jeet singh

PFA

On Tue, Nov 20, 2012 at 10:20 PM, renuka chari  wrote:

> hi Excel beginner,
> i don't know your name?
> but you gave me a wonderful solution
> thanks allot.
> but is there any easy formula for that..
> this mega formula usage in my sheet every time is difficult for me...
> is there any alternate solution for that...
> i mean that make it simple.
>
> but any way thanks allot..:)
>
> Hi Paul,
> thanks for speed response.
> i am expecting this only...
>
>
>
>
> On Tuesday, 20 November 2012 01:15:43 UTC+5:30, Excel Beginner wrote:
>
>> Hi Renu,
>>
>>   please find the attachment.
>>
>>
>>
>>
>>
>> --
>> *Regards,*
>> *
>> *
>> *Excel Beginner*
>> *
>> *
>> On Mon, Nov 19, 2012 at 10:35 PM, Renukachari Kasee wrote:
>>
>>> Dear experts,
>>> is there any solution for pick the step value in certain table?
>>>
>>> please see above attached workbook
>>> here i need formula for pick the value
>>>
>>> thanks
>>>
>>>  --
>>> Join official Facebook page of this forum @ https://www.facebook.com/**
>>> discussexcel 
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To post to this group, send email to excel-...@googlegroups.com.
>>> To unsubscribe from this group, send email to excel-macros...@**
>>> googlegroups.com.
>>>
>>> Visit this group at 
>>> http://groups.google.com/**group/excel-macros?hl=en
>>> .
>>>
>>>
>>>
>>
>>
>>
>>
>>   --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

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




All1(solved).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Re: Duplicate line based on column

2012-11-20 Thread Prince

Hi Viswanathan,

Just Copy And paste the following code in the module and run it.

Sub RemoveDuplcate()

Dim rngData As Range

With ThisWorkbook.Worksheets("Sheet1")
Set rngData = .Range("A1:E" & .Range("E" & 
.Rows.Count).End(xlUp).Row)
rngData.RemoveDuplicates 5, xlYes
End With
End Sub


hope this will help you 
Regards
Prince



On Wednesday, November 21, 2012 2:43:37 AM UTC+5:30, Viswanathan Yoganathan 
wrote:
>
>  HI,
>
>  
>
> In the attached excel, I need to remove the duplicate lines based on the 
> “Column E”.
>
>  
>
> Example:
>
>  
>
> The first line and the second line have same value in the “Column E”.  The 
> first line should remain same and second line should be deleted, no matter 
> what the other cell value has in the same line.
>
>  
>
> Thanks,
>
> Vishwa.
>
>  
>
>  
>  
> "CONFIDENTIALITY NOTICE: This message and any attachment are confidential 
> and may also be privileged. If you are not the intended recipient of this 
> e-mail you may not copy, forward, disclose or otherwise use it or any part 
> of it in any form whatsoever. If you are not the intended recipient please 
> telephone or e-mail the sender and delete this message and any attachment 
> from your system."
>

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

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

Re: $$Excel-Macros$$ Need invoicing Tool

2012-11-20 Thread Anoop K Sharma

The Invoicing are different for different organization. Better to attach
your excel sheet.

Regards,
Anoop
Sr. Developer


On Tue, Nov 20, 2012 at 3:49 PM, Amresh Maurya wrote:

> Hi Everyone,
>
> I Need invoicing Tool for Printing Invoice. Please share if you have
> any kind of  tools for invoicing in excel.
>
> Regards
> Amresh
>
> --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE  : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>


-- 
Regards,
Anoop

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

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

$$Excel-Macros$$ Re: Event - Worksheet Change

2012-11-20 Thread Prince

Hi Raj,

Just copy and paste this code on worksheet1 code window 

Private Sub Worksheet_Change(ByVal Target As Range)
If Trim(Target.Value) = Trim("2 City") Then
ThisWorkbook.Worksheets("Sheet1").Range("F13").Interior.ColorIndex 
= 6
ElseIf Trim(Target.Value) = Trim("1 City") Then
ThisWorkbook.Worksheets("Sheet1").Range("F13").Interior.ColorIndex 
= 5
End If
End Sub


Regards

Prince

On Monday, November 19, 2012 11:15:19 PM UTC+5:30, Raj Mahapatra wrote:

> Dear Friends,
>
> kindly help out on below macro,  i am not able to get output.
>
> I Wants to auto change Cell color Range "F13" to Blue when Range "F11" is 
> as "1 City" and cell color Range "F13" to Yellow when range "F11" is as "2 
> City".
>
> I have also attached  xls for your reference.
>
> Private Sub Worksheet_Change(ByVal Target As Excel.Range)
>
> Set Target = Range("F11")
>  
> If Target.Value = "1 City" Then
> Range("F13").Interior.ColorIndex = 5
> ElseIf Target.Value = "2 City" Then
> Range("F13").Interior.ColorIndex = 6
> End If
>
> End Sub
>
>
>
>

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

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

Re: $$Excel-Macros$$ Re: Please help - How to export specific range by ID to other excel file.

2012-11-20 Thread Anoop K Sharma

It's better to attach the file and put you query there.
No one gonna study this code as different people have different logic.

Regards,
Anoop


On Tue, Nov 20, 2012 at 1:49 AM, Natron  wrote:

> This is close and might get you a kickstart.
>
> Sub selectme()
> ''
> 'Original Script Written by www.ozgrid.com
> ''
>
> Dim rRange As Range
> Dim strCriteria As String, strCriteria2 As String
> Dim lCol As Long
> Dim rHeaderCol As Range
> Dim xlCalc As XlCalculation
>
> On Error Resume Next
> Step1:
> Set rRange = Range("A1").CurrentRegion
>
> 'Cancelled or non valid rage
> If rRange Is Nothing Then Exit Sub
>  'Awlays use GoTo when selecting range so doesn't matter which
> Worksheet
>  Application.Goto rRange.Rows(1), True
>
> step2:
> lCol = 1
> 'Cancelled
> If lCol = 0 Then Exit Sub
>
> Step3:
> strCriteria = frmExport.txtStart
> strCriteria2 = frmExport.txtEnd
>
> 'Store current Calculation then switch to manual.
> 'Turn off events and screen updating
> With Application
> xlCalc = .Calculation
> .Calculation = xlCalculationManual
> .EnableEvents = False
> .ScreenUpdating = False
> End With
>
>
> 'Remove any filters
> ActiveSheet.AutoFilterMode = False
>
> With rRange 'Filter, offset(to exclude headers)
>   .AutoFilter Field:=lCol, Criteria1:=">=" & strCriteria,
> Operator:=XlAutoFilterOperator.xlAnd, Criteria2:="<=" & strCriteria2
>   .Offset(1, 0).SpecialCells(xlCellTypeVisible).EntireRow.Select
> End With
>
> 'Remove any filters
> 'ActiveSheet.AutoFilterMode = False
>
>   'Revert back
> With Application
> .Calculation = xlCalc
> .EnableEvents = True
> .ScreenUpdating = True
> End With
>On Error GoTo 0
> End Sub
>
> On Monday, November 19, 2012 1:55:03 PM UTC-5, Mangesh wrote:
>
>> Hi Friends,
>>
>> I have attached the file where I need to export specific range to another
>> excel file which to be save on C: drive.
>>
>> I have created userform for this as well.
>>
>> Need vba code to perform this task.
>>
>> Waiting for the solution.
>>
>> Please help !!!
>>
>> --
>> With regards,
>>
>> *MaNgEsH*
>>
>>  --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>



-- 
Regards,
Anoop

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

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

Re: $$Excel-Macros$$ Event - Worksheet Change

2012-11-20 Thread Paul Schreiner

Event macros do NOT go in "standard" modules.

Your change event must be in the Sheet module for the sheet you wish the event 
to "monitor".

If you want it to apply to ALL sheets, then a variation must go in the 
Thisworkbook module.

If you right-click the sheet "tab" and select "View Code",
the sheet module will open.
If you select "WorkSheet" in the left-hand pull-down in the Editor window, an 
empty SelctionChange event will be created.
If you then open the right-hand pull-down (in the Editor Window)
it will show you the available event macros.

Selecting "Change" will create your Worksheet_Change event macro.
 
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-





From: Raj Mahapatra 
To: excel-macros@googlegroups.com
Sent: Tue, November 20, 2012 11:56:17 AM
Subject: $$Excel-Macros$$ Event - Worksheet Change

Dear Friends,



kindly help out on below macro,  i am not able to get output.

I Wants to auto change Cell color Range "F13" to Blue when Range "F11" is as "1 
City" and cell color Range "F13" to Yellow when range "F11" is as "2 City".

I have also attached  xls for your reference.

Private Sub Worksheet_Change(ByVal Target As Excel.Range)

Set Target = Range("F11")

If Target.Value = "1 City" Then
    Range("F13").Interior.ColorIndex = 5
ElseIf Target.Value = "2 City" Then
    Range("F13").Interior.ColorIndex = 6
End If

End Sub


-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members 
are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

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

Re: $$Excel-Macros$$ Duplicate line based on column

2012-11-20 Thread Jaysheel Bhasme

Hi,

The Easiest way is just go to data and then to remove duplicates (Alt+A+M)

Regards,
Jaysheel Bhasme.

On Wed, Nov 21, 2012 at 2:43 AM, Viswanathan Yoganathan <
viswanathan.yoganat...@asia.xchanging.com> wrote:

>  HI,
>
> ** **
>
> In the attached excel, I need to remove the duplicate lines based on the
> “Column E”.
>
> ** **
>
> Example:
>
> ** **
>
> The first line and the second line have same value in the “Column E”.  The
> first line should remain same and second line should be deleted, no matter
> what the other cell value has in the same line.
>
> ** **
>
> Thanks,
>
> Vishwa.
>
> ** **
>
> ** **
>
> "CONFIDENTIALITY NOTICE: This message and any attachment are confidential
> and may also be privileged. If you are not the intended recipient of this
> e-mail you may not copy, forward, disclose or otherwise use it or any part
> of it in any form whatsoever. If you are not the intended recipient please
> telephone or e-mail the sender and delete this message and any attachment
> from your system."
>
> --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>



-- 
Jaysheel Bhasme.

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

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

$$Excel-Macros$$ Duplicate line based on column

2012-11-20 Thread Viswanathan Yoganathan

HI,

In the attached excel, I need to remove the duplicate lines based on the 
"Column E".

Example:

The first line and the second line have same value in the "Column E".  The 
first line should remain same and second line should be deleted, no matter what 
the other cell value has in the same line.

Thanks,
Vishwa.


"CONFIDENTIALITY NOTICE: This message and any attachment are confidential and 
may also be privileged. If you are not the intended recipient of this e-mail 
you may not copy, forward, disclose or otherwise use it or any part of it in 
any form whatsoever. If you are not the intended recipient please telephone or 
e-mail the sender and delete this message and any attachment from your system."

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

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




Book3.xlsx
Description: Book3.xlsx

Re: $$Excel-Macros$$ Please help - How to export specific range by ID to other excel file.

2012-11-20 Thread Mangesh Vimay

Thank you so much Natron.

You have made my work very easy.

Thanks again.

On Tue, Nov 20, 2012 at 6:35 PM, Natron  wrote:

> See attached, with the code I used below...there are many other ways to do
> this.
>
> 'This is hooked to your Export Specific Data Button on your form
> Private Sub cmdExport_Click()
> Dim intStart As Integer, intEnd As Integer
> On Error GoTo whoops
> intStart = Me.txtStart
> intEnd = Me.txtEnd
> If intStart > intEnd Then GoTo whoops
>
> exportme
>
> Me.Hide
>
> Exit Sub
> whoops:
> MsgBox "Please enter two integers and try again"
> End Sub
>
>
> 'This is put into a Module
> Sub exportme()
> ''
> 'Original Script Written by www.ozgrid.com
> ''
>
> Dim rRange As Range
> Dim strCriteria As String, strCriteria2 As String
> Dim lCol As Long
> Dim rHeaderCol As Range
> Dim xlCalc As XlCalculation
>
> On Error Resume Next
> Step1:
> Set rRange = Range("A1").CurrentRegion
>
> 'Cancelled or non valid rage
> If rRange Is Nothing Then Exit Sub
>  'Awlays use GoTo when selecting range so doesn't matter which
> Worksheet
>  Application.Goto rRange.Rows(1), True
>
> step2:
> lCol = 1
>
> Step3:
> strCriteria = frmExport.txtStart
> strCriteria2 = frmExport.txtEnd
>
> 'Store current Calculation then switch to manual.
> 'Turn off events and screen updating
> With Application
> xlCalc = .Calculation
> .Calculation = xlCalculationManual
> .EnableEvents = False
> .ScreenUpdating = False
> End With
>
> 'Remove any filters
> ActiveSheet.AutoFilterMode = False
>
> Dim s As Range
>
> With rRange 'Filter, offset(to exclude headers)
>   .AutoFilter Field:=lCol, Criteria1:=">=" & strCriteria,
> Operator:=XlAutoFilterOperator.xlAnd, Criteria2:="<=" & strCriteria2
>   .Offset(1, 0).SpecialCells(xlCellTypeVisible).Copy
> End With
> Workbooks.Add
> ActiveSheet.Paste
> ChDir "C:\"
> ActiveWorkbook.SaveAs Filename:="C:\YourFile.xlsx", FileFormat:= _
> xlOpenXMLWorkbook, CreateBackup:=False
>
> ActiveWorkbook.Save
> ActiveWindow.Close
> 'Remove any filters
> ActiveSheet.AutoFilterMode = False
>
>   'Revert back
> With Application
> .Calculation = xlCalc
> .EnableEvents = True
> .ScreenUpdating = True
> End With
>On Error GoTo 0
> End Sub
>
>
> --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>



-- 
With regards,

*MaNgEsH*

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

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

$$Excel-Macros$$ Event - Worksheet Change

2012-11-20 Thread Raj Mahapatra

Dear Friends,

kindly help out on below macro,  i am not able to get output.

I Wants to auto change Cell color Range "F13" to Blue when Range "F11" is
as "1 City" and cell color Range "F13" to Yellow when range "F11" is as "2
City".

I have also attached  xls for your reference.

Private Sub Worksheet_Change(ByVal Target As Excel.Range)

Set Target = Range("F11")

If Target.Value = "1 City" Then
Range("F13").Interior.ColorIndex = 5
ElseIf Target.Value = "2 City" Then
Range("F13").Interior.ColorIndex = 6
End If

End Sub

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

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




Event_worksheet change.xlsm
Description: Binary data

Re: $$Excel-Macros$$ dear experts is there any solution for pick the step value in certain table

2012-11-20 Thread renuka chari

hi Excel beginner,
i don't know your name?
but you gave me a wonderful solution
thanks allot.
but is there any easy formula for that..
this mega formula usage in my sheet every time is difficult for me...
is there any alternate solution for that...
i mean that make it simple.

but any way thanks allot..:)

Hi Paul,
thanks for speed response.
i am expecting this only...




On Tuesday, 20 November 2012 01:15:43 UTC+5:30, Excel Beginner wrote:
>
> Hi Renu,
>
>   please find the attachment.
>
>
>
>
>
> -- 
> *Regards,*
> *
> *
> *Excel Beginner*
> *
> *
> On Mon, Nov 19, 2012 at 10:35 PM, Renukachari Kasee 
> 
> > wrote:
>
>> Dear experts,
>> is there any solution for pick the step value in certain table?
>>  
>> please see above attached workbook
>> here i need formula for pick the value
>>  
>> thanks 
>>
>>  -- 
>> Join official Facebook page of this forum @ 
>> https://www.facebook.com/discussexcel
>>  
>> FORUM RULES
>>  
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security 
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>  
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and 
>> members are not responsible for any loss.
>> --- 
>> You received this message because you are subscribed to the Google Groups 
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-...@googlegroups.com
>> .
>> To unsubscribe from this group, send email to 
>> excel-macros...@googlegroups.com .
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>  
>>  
>>
>
>
>
>
>  

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

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

$$Excel-Macros$$ required formula

2012-11-20 Thread Rajesh Agarwal

Hello Every one. Please find the attachment.
rgds

-- 
*Rajesh Kumar Agarwal*
*9811063001*

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

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




need formula minimum average for non zero.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: Mandatory Field

2012-11-20 Thread Prince

Hi Shrini,

I think without macro it is not possible to do as formulas can not control 
objects and a workbook is an object. But you can do one thing by using 
conditional formatting you can intimate user to fill the cell B1 if there 
is any value into cell A1.

Regards
Prince.

On Monday, November 19, 2012 11:12:23 AM UTC+5:30, shrini wrote:
>
> Dear All
> Please help me for following problem.
> I want to make a Cell "B1" mandatory based on Cell "A1".
> Means if there is any value in Cell "A1" then "Cell "B1" can not empty 
> there should be some value .
> Eg.
> In Cell "A1" I will Enter Name of te person then Age should compulsary 
> enter in cell "B1"
> System should not allow me to close the file without entering the age in 
> Cell "B1"
> is it possible without macro?
>  
> Thanks in advance
>  
>
>
> -- 
> Shrini
>

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

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

$$Excel-Macros$$ Re: Mandatory Field

2012-11-20 Thread Natron

Not possible to disable closing the file without a Macro.

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

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

$$Excel-Macros$$ Allocation file

2012-11-20 Thread Lokesh Loki

Hi All,

I need to copy paste current dated allocation file data in to my local
drive (i.e. C:\ ) with an existing excel file called ( i.e.allocation file)
and the sheet name should be same in both files. And when i try to run the
macro the current dated data should be past in the current sheet.(i.e C:\
allocation file).

Please let me know for any clarification and attached excel file for your
reference.

Regards
Lokesh

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

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




Allocation file.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Please help - How to export specific range by ID to other excel file.

2012-11-20 Thread Natron

 See attached, with the code I used below...there are many other ways to do 
this.
 
'This is hooked to your Export Specific Data Button on your form
Private Sub cmdExport_Click()
Dim intStart As Integer, intEnd As Integer
On Error GoTo whoops
intStart = Me.txtStart
intEnd = Me.txtEnd
If intStart > intEnd Then GoTo whoops

exportme

Me.Hide

Exit Sub
whoops:
MsgBox "Please enter two integers and try again"
End Sub
 
 
'This is put into a Module
Sub exportme()
''
'Original Script Written by www.ozgrid.com
''

Dim rRange As Range
Dim strCriteria As String, strCriteria2 As String
Dim lCol As Long
Dim rHeaderCol As Range
Dim xlCalc As XlCalculation

On Error Resume Next
Step1:
Set rRange = Range("A1").CurrentRegion

'Cancelled or non valid rage
If rRange Is Nothing Then Exit Sub
 'Awlays use GoTo when selecting range so doesn't matter which Worksheet
 Application.Goto rRange.Rows(1), True

step2:
lCol = 1

Step3:
strCriteria = frmExport.txtStart
strCriteria2 = frmExport.txtEnd

'Store current Calculation then switch to manual.
'Turn off events and screen updating
With Application
xlCalc = .Calculation
.Calculation = xlCalculationManual
.EnableEvents = False
.ScreenUpdating = False
End With

'Remove any filters
ActiveSheet.AutoFilterMode = False

Dim s As Range

With rRange 'Filter, offset(to exclude headers)
  .AutoFilter Field:=lCol, Criteria1:=">=" & strCriteria, 
Operator:=XlAutoFilterOperator.xlAnd, Criteria2:="<=" & strCriteria2
  .Offset(1, 0).SpecialCells(xlCellTypeVisible).Copy
End With
Workbooks.Add
ActiveSheet.Paste
ChDir "C:\"
ActiveWorkbook.SaveAs Filename:="C:\YourFile.xlsx", FileFormat:= _
xlOpenXMLWorkbook, CreateBackup:=False

ActiveWorkbook.Save
ActiveWindow.Close
'Remove any filters
ActiveSheet.AutoFilterMode = False

  'Revert back
With Application
.Calculation = xlCalc
.EnableEvents = True
.ScreenUpdating = True
End With
   On Error GoTo 0
End Sub
 

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

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




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

Fwd: $$Excel-Macros$$ Please help - How to export specific range by ID to other excel file.

2012-11-20 Thread Mangesh Vimay

Hi Friends,

Please help me by providing the solution.

Thanks in advance.



-- Forwarded message --
From: Mangesh Vimay 
Date: Tue, Nov 20, 2012 at 12:24 AM
Subject: $$Excel-Macros$$ Please help - How to export specific range by ID
to other excel file.
To: excel-macros@googlegroups.com, Mangesh Vimay 


Hi Friends,

I have attached the file where I need to export specific range to another
excel file which to be save on C: drive.

I have created userform for this as well.

Need vba code to perform this task.

Waiting for the solution.

Please help !!!

-- 
With regards,

*MaNgEsH*

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
will not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

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





-- 
With regards,

*MaNgEsH*

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

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




ExportRange.xlsm
Description: Binary data

$$Excel-Macros$$ Need invoicing Tool

2012-11-20 Thread Amresh Maurya

Hi Everyone,

I Need invoicing Tool for Printing Invoice. Please share if you have
any kind of  tools for invoicing in excel.

Regards
Amresh

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

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

Re: $$Excel-Macros$$ Re: Split a cell into multiple cells in Excel 2010

Re: $$Excel-Macros$$ Re: Split a cell into multiple cells in Excel 2010

Re: $$Excel-Macros$$ Re: Split a cell into multiple cells in Excel 2010

$$Excel-Macros$$ Re: Split a cell into multiple cells in Excel 2010

Re: $$Excel-Macros$$ dear experts is there any solution for pick the step value in certain table

$$Excel-Macros$$ Re: Duplicate line based on column

Re: $$Excel-Macros$$ Need invoicing Tool

$$Excel-Macros$$ Re: Event - Worksheet Change

Re: $$Excel-Macros$$ Re: Please help - How to export specific range by ID to other excel file.

Re: $$Excel-Macros$$ Event - Worksheet Change

Re: $$Excel-Macros$$ Duplicate line based on column

$$Excel-Macros$$ Duplicate line based on column

Re: $$Excel-Macros$$ Please help - How to export specific range by ID to other excel file.

$$Excel-Macros$$ Event - Worksheet Change

Re: $$Excel-Macros$$ dear experts is there any solution for pick the step value in certain table

$$Excel-Macros$$ required formula

$$Excel-Macros$$ Re: Mandatory Field

$$Excel-Macros$$ Re: Mandatory Field

$$Excel-Macros$$ Allocation file

Re: $$Excel-Macros$$ Please help - How to export specific range by ID to other excel file.

Fwd: $$Excel-Macros$$ Please help - How to export specific range by ID to other excel file.

$$Excel-Macros$$ Need invoicing Tool

22 matches

Site Navigation

Mail list logo

Footer information