Re: $$Excel-Macros$$ Microsoft Excel based application that digitizes data from pictures

2013-08-21 Thread Sam Mathai Chacko
Did you try http://www.ozgrid.com/Services/excel-charts-digitized.htm
On Aug 21, 2013 11:04 AM, P.VIJAYKUMAR vijay.4...@gmail.com wrote:

 Respected Mog-Godiva,

 You can find the digitizer from the following links,
 http://digitizer.sourceforge.net/
 http://www.mathtools.net/Excel/Graphics_and_Visualization/


 Regards,
 Vijaykumar


 On Wed, Aug 21, 2013 at 5:43 AM, Mog Godiva-Man osaze...@gmail.comwrote:

 Anyone know where I can get some Addin for digitizing data from graphical
 line/chart images in excel.

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

 FORUM RULES

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

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




 --









 P.VIJAY KUMAR

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

 FORUM RULES

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

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


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

FORUM RULES

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

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


Re: $$Excel-Macros$$ Charts Title Font Size Change via VBA

2013-08-21 Thread xlstime
Try This

Sub Chart_Titles()

Dim ch As ChartObject

  For Each ch In ActiveSheet.ChartObjects

ch.Activate
ch.Chart.ChartTitle.Select
Selection.Format.TextFrame2.TextRange.Font.Name = Arial
Selection.Format.TextFrame2.TextRange.Font.Size = 14
 Next


End Sub





.

Enjoy
Team XLS



On Wed, Aug 21, 2013 at 10:34 AM, Prafull Jadhav
prafulltjad...@gmail.comwrote:

  Dear All,

 Very Good Morning,

 I have made 10 charts and now I want to change the  Size of Font  14 to 9
 for Chart Title.

 is it possible to change it through the VBA

 for example

 For each

 For Next

 Do until
   if yes , Please  provide the same

   Thanks in Advance

 Regards,

 Prafull Jadhav.

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

 FORUM RULES

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

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


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

FORUM RULES

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

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


Re: $$Excel-Macros$$ Charts Title Font Size Change via VBA

2013-08-21 Thread Prafull Jadhav
Thanks a lot Sir...It working Fine


On Wed, Aug 21, 2013 at 1:12 PM, xlstime xlst...@gmail.com wrote:

 Try This

 Sub Chart_Titles()

 Dim ch As ChartObject

   For Each ch In ActiveSheet.ChartObjects

 ch.Activate
 ch.Chart.ChartTitle.Select
 Selection.Format.TextFrame2.TextRange.Font.Name = Arial
 Selection.Format.TextFrame2.TextRange.Font.Size = 14
  Next


 End Sub





 .

 Enjoy
 Team XLS



 On Wed, Aug 21, 2013 at 10:34 AM, Prafull Jadhav prafulltjad...@gmail.com
  wrote:

   Dear All,

 Very Good Morning,

 I have made 10 charts and now I want to change the  Size of Font  14 to
 9  for Chart Title.

 is it possible to change it through the VBA

 for example

 For each

 For Next

 Do until
   if yes , Please  provide the same

   Thanks in Advance

 Regards,

 Prafull Jadhav.

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

 FORUM RULES

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

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


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

 FORUM RULES

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

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


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

FORUM RULES

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

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


Re: $$Excel-Macros$$ How to split Data based on last comm,

2013-08-21 Thread Andrew Mangozho
Another simpler but rather long method to get the same result


On Tue, Jul 30, 2013 at 4:31 AM, Waseem Saifi waseemsa...@gmail.com wrote:

 Dear Rajkumar,

 Please find attached file with solution.

 Regards,
 Waseem Saifi


 On Tue, Jul 30, 2013 at 3:48 PM, Raj Kumar rajlu...@gmail.com wrote:

 Dear Group,

 We have lots of records and Segregate the data based on only last comma
 and consider the same

 Like,
 *Data   Result Shold be*

 Raj, Kumar, Bharti   Bharti
 Sadan, Kumar, SinhaSinha
 Madan, Kumar, Sinha  Sinha

 Regards
 Raj Bharti


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

 FORUM RULES

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

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




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

 FORUM RULES

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

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




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

FORUM RULES

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

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


Extract Last word.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet


Re: $$Excel-Macros$$ Sum between two different data.

2013-08-21 Thread अनिल नारायण गवली
Dear Manok,

Find attached herewith .

Warm Regards,
Gawli Anil.
Thanks  Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd


On Wed, Aug 21, 2013 at 2:30 PM, Manoj Kumar manoj.11...@gmail.com wrote:

 Please help me.

 I have a data like details mention below.

 xxx  a  b  c

 jan2  3 1
 feb1  1 2
 jan2  2 1
 jan4  1 2
 mar  1   3 1

 I have a able

 xxx  Jan Feb Mar

 a  81  1
 b  61  3
 c  12  4

 any body provide me a formule.

 Regard
 Manoj

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

 FORUM RULES

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

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

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

FORUM RULES

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

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


Manoj Kumar Prob sol.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet


Re: $$Excel-Macros$$ How to split Data based on last comm,

2013-08-21 Thread अनिल नारायण गवली
 Dear Rajkumar,


U can use text to columns option .
click on comma checkbox and finish it.

Warm Regads,
Gawli Anil
Thanks  Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd


On Wed, Aug 21, 2013 at 2:42 PM, Andrew Mangozho
andrew.mango...@gmail.com wrote:
 Another simpler but rather long method to get the same result


 On Tue, Jul 30, 2013 at 4:31 AM, Waseem Saifi waseemsa...@gmail.com wrote:

 Dear Rajkumar,

 Please find attached file with solution.

 Regards,
 Waseem Saifi


 On Tue, Jul 30, 2013 at 3:48 PM, Raj Kumar rajlu...@gmail.com wrote:

 Dear Group,

 We have lots of records and Segregate the data based on only last comma
 and consider the same

 Like,
 Data   Result Shold be

 Raj, Kumar, Bharti   Bharti
 Sadan, Kumar, SinhaSinha
 Madan, Kumar, Sinha  Sinha

 Regards
 Raj Bharti


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

 FORUM RULES

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

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




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

 FORUM RULES

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

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




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

 FORUM RULES

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

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

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

FORUM RULES

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

Re: $$Excel-Macros$$ How to split Data based on last comm,

2013-08-21 Thread Andrew Mangozho
Yes, thats great and faster.


On Wed, Aug 21, 2013 at 2:36 AM, अनिल नारायण गवली
gawlianil8...@gmail.comwrote:

  Dear Rajkumar,


 U can use text to columns option .
 click on comma checkbox and finish it.

 Warm Regads,
 Gawli Anil
 Thanks  Regards,
 Gawli Anil Narayan
 Software Developer,
 Abacus Software Services Pvt Ltd


 On Wed, Aug 21, 2013 at 2:42 PM, Andrew Mangozho
 andrew.mango...@gmail.com wrote:
  Another simpler but rather long method to get the same result
 
 
  On Tue, Jul 30, 2013 at 4:31 AM, Waseem Saifi waseemsa...@gmail.com
 wrote:
 
  Dear Rajkumar,
 
  Please find attached file with solution.
 
  Regards,
  Waseem Saifi
 
 
  On Tue, Jul 30, 2013 at 3:48 PM, Raj Kumar rajlu...@gmail.com wrote:
 
  Dear Group,
 
  We have lots of records and Segregate the data based on only last comma
  and consider the same
 
  Like,
  Data   Result Shold be
 
  Raj, Kumar, Bharti   Bharti
  Sadan, Kumar, SinhaSinha
  Madan, Kumar, Sinha  Sinha
 
  Regards
  Raj Bharti
 
 
  --
  Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
 It’s
  =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
  https://www.facebook.com/discussexcel
 
  FORUM RULES
 
  1) Use concise, accurate thread titles. Poor thread titles, like Please
  Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
 Advice will
  not get quick attention or may not be answered.
  2) Don't post a question in the thread of another member.
  3) Don't post questions regarding breaking or bypassing any security
  measure.
  4) Acknowledge the responses you receive, good or bad.
  5) Jobs posting is not allowed.
  6) Sharing copyrighted material and their links is not allowed.
 
  NOTE : Don't ever post confidential data in a workbook. Forum owners
 and
  members are not responsible for any loss.
  ---
  You received this message because you are subscribed to the Google
 Groups
  MS EXCEL AND VBA MACROS group.
  To unsubscribe from this group and stop receiving emails from it, send
 an
  email to excel-macros+unsubscr...@googlegroups.com.
  To post to this group, send email to excel-macros@googlegroups.com.
  Visit this group at http://groups.google.com/group/excel-macros.
  For more options, visit https://groups.google.com/groups/opt_out.
 
 
 
 
  --
  Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
 It’s
  =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
  https://www.facebook.com/discussexcel
 
  FORUM RULES
 
  1) Use concise, accurate thread titles. Poor thread titles, like Please
  Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will
  not get quick attention or may not be answered.
  2) Don't post a question in the thread of another member.
  3) Don't post questions regarding breaking or bypassing any security
  measure.
  4) Acknowledge the responses you receive, good or bad.
  5) Jobs posting is not allowed.
  6) Sharing copyrighted material and their links is not allowed.
 
  NOTE : Don't ever post confidential data in a workbook. Forum owners and
  members are not responsible for any loss.
  ---
  You received this message because you are subscribed to the Google
 Groups
  MS EXCEL AND VBA MACROS group.
  To unsubscribe from this group and stop receiving emails from it, send
 an
  email to excel-macros+unsubscr...@googlegroups.com.
  To post to this group, send email to excel-macros@googlegroups.com.
  Visit this group at http://groups.google.com/group/excel-macros.
  For more options, visit https://groups.google.com/groups/opt_out.
 
 
 
 
  --
  Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
  =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
  https://www.facebook.com/discussexcel
 
  FORUM RULES
 
  1) Use concise, accurate thread titles. Poor thread titles, like Please
  Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will
  not get quick attention or may not be answered.
  2) Don't post a question in the thread of another member.
  3) Don't post questions regarding breaking or bypassing any security
  measure.
  4) Acknowledge the responses you receive, good or bad.
  5) Jobs posting is not allowed.
  6) Sharing copyrighted material and their links is not allowed.
 
  NOTE : Don't ever post confidential data in a workbook. Forum owners and
  members are not responsible for any loss.
  ---
  You received this message because you are subscribed to the Google Groups
  MS EXCEL AND VBA MACROS group.
  To unsubscribe from this group and stop receiving emails from it, send an
  email to excel-macros+unsubscr...@googlegroups.com.
  To post to this group, send email to excel-macros@googlegroups.com.
  Visit this group at http://groups.google.com/group/excel-macros.
  For more options, visit https://groups.google.com/groups/opt_out.

 --
 Are you 

Re: $$Excel-Macros$$ Charts Title Font Size Change via VBA

2013-08-21 Thread Prafull Jadhav
Dear Sir,

I have  querys 

1) I have not used  Dim Declaration and run below vba it working fine..

is there need to use Dim here?

Dim x As ChartObject

For Each x In ActiveSheet.ChartObjects
x.Activate
x.Chart.ChartTitle.Select
Selection.Format.TextFrame2.TextRange.Font.Name = Arial
Selection.Format.TextFrame2.TextRange.Font.Size = 5
Next x


2) while i am using recording macro below two lines are not reflecting in
Recorded Statement

 Selection.Format.TextFrame2.TextRange.Font.Name = Arial
Selection.Format.TextFrame2.TextRange.Font.Size = 5

then  how i could i get further property
for example .
if

When i type Range( then it's properly is reflecting

when when i type

Selection.format ...further properly is not reflecting ..

Is there any way to show properly . such as ...when i type Range(). it show
properly..
Regards,
Prafull





End Sub


On Wed, Aug 21, 2013 at 2:25 PM, Prafull Jadhav prafulltjad...@gmail.comwrote:

 Thanks a lot Sir...It working Fine


 On Wed, Aug 21, 2013 at 1:12 PM, xlstime xlst...@gmail.com wrote:

 Try This

 Sub Chart_Titles()

 Dim ch As ChartObject

   For Each ch In ActiveSheet.ChartObjects

 ch.Activate
 ch.Chart.ChartTitle.Select
 Selection.Format.TextFrame2.TextRange.Font.Name = Arial
 Selection.Format.TextFrame2.TextRange.Font.Size = 14
  Next


 End Sub





 .

 Enjoy
 Team XLS



 On Wed, Aug 21, 2013 at 10:34 AM, Prafull Jadhav 
 prafulltjad...@gmail.com wrote:

   Dear All,

 Very Good Morning,

 I have made 10 charts and now I want to change the  Size of Font  14 to
 9  for Chart Title.

 is it possible to change it through the VBA

 for example

 For each

 For Next

 Do until
   if yes , Please  provide the same

   Thanks in Advance

 Regards,

 Prafull Jadhav.

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

 FORUM RULES

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

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


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

 FORUM RULES

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

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




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

FORUM RULES

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

$$Excel-Macros$$ help needed urgent

2013-08-21 Thread thameem
Dear all,
file is in server, but no one is using that file, but stil showing file is
use.. please help me wat to do...

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

FORUM RULES

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

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


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

2013-08-21 Thread vba
See any hidden temp file is created or not.

Try revoking shared access for particular folder n re share.

Thanks
On 21 Aug 2013 17:26, thameem thamee...@gmail.com wrote:

 Dear all,
 file is in server, but no one is using that file, but stil showing file is
 use.. please help me wat to do...

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

 FORUM RULES

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

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


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

FORUM RULES

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

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


Re: $$Excel-Macros$$ How to split Data based on last comm,

2013-08-21 Thread De Premor

Another simple and short
=TRIM(RIGHT(SUBSTITUTE(A2,,,REPT( ,99)),99))

Pada 21/08/2013 16:12, Andrew Mangozho menulis:

Another simpler but rather long method to get the same result


On Tue, Jul 30, 2013 at 4:31 AM, Waseem Saifi waseemsa...@gmail.com 
mailto:waseemsa...@gmail.com wrote:


Dear Rajkumar,

Please find attached file with solution.

Regards,
Waseem Saifi


On Tue, Jul 30, 2013 at 3:48 PM, Raj Kumar rajlu...@gmail.com
mailto:rajlu...@gmail.com wrote:

Dear Group,
We have lots of records and Segregate the data based on only
last comma and consider the same
Like,
*Data Result Shold be*
Raj, Kumar, Bharti   Bharti
Sadan, Kumar, SinhaSinha
Madan, Kumar, Sinha  Sinha
Regards
Raj Bharti
-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you

wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook
page of this forum @ https://www.facebook.com/discussexcel

FORUM RULES

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

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



-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna

be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this
forum @ https://www.facebook.com/discussexcel

FORUM RULES

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

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



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


FORUM RULES

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

2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security 
measure.

4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

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

---
You received this message because you are subscribed to the Google 
Groups MS EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send 
an email to excel-macros+unsubscr...@googlegroups.com.

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

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

2013-08-21 Thread thameem
thanks.. its done


On Wed, Aug 21, 2013 at 4:05 PM, vba v...@vabs.in wrote:

 See any hidden temp file is created or not.

 Try revoking shared access for particular folder n re share.

 Thanks
 On 21 Aug 2013 17:26, thameem thamee...@gmail.com wrote:

 Dear all,
 file is in server, but no one is using that file, but stil showing file
 is use.. please help me wat to do...

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

 FORUM RULES

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

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

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

 FORUM RULES

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

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


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

FORUM RULES

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

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


Re: $$Excel-Macros$$ I need to delete entire rows which contain exact matches from a static list on a seperate sheet

2013-08-21 Thread svenyarl
I sample of the file I receive is as follows:

 25727861 GM DLT 1 
20130716  17091432 GM NS 8 
20121227  12527740 GM NS 8 
20121221  10328906 GM NS 0 

 89018306 GM NS 12 

 12617309 GM RB 44 

 12365265 GM NS 10 
20121026  12588318 GM RB 18 
20120301  16631629 GM NS 11 

 
the comparing file is only a single column of part numbers by which need to 
be removed. In this example it would find part number 10328906 and delete 
it and the entire row containing it. Currently I insert a column and do a 
vlookup to match against the second list and then filter everything but 
#N/A and delete all matches then once are all removed I delete the added 
column. As I said before, I'm sure a easier way exists, but that I am 
simply not aware of it.

   25735380  25735405  25735406  25735601  25735602

 25735604  11519347  11519349  25736491  25736492
10328906
 25736678  25736711  25736714  25737609  25738783  25739412   
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 


On Wednesday, August 21, 2013 12:52:14 AM UTC-7, Ravinder Negi wrote:

 pls give some example file so we can do somthing..

   --
  *From:* sven...@gmail.com javascript: sven...@gmail.comjavascript:
 
 *To:* excel-...@googlegroups.com javascript: 
 *Sent:* Wednesday, August 21, 2013 7:09 AM
 *Subject:* $$Excel-Macros$$ I need to delete entire rows which contain 
 exact matches from a static list on a seperate sheet
  
 I am open to suggestions on how best to go about this and am aware this 
 might be a fairly simple request but I either lack the expertise or the 
 correct vernacular to find the answer myself. 

 On a daily basis I receive files of approximately 56000 rows of part 
 numbers along with each parts pertinent data. From this I must remove parts 
 located on a separate list of about 8000 parts from the original in order 
 for the files to load correctly. So far I have been solving this by VLOOKUP 
 and then manually deleting but I am aware there must be a quicker and 
 easier way either by VBA, Macro, or SQL scripting. I am open to any 
 suggestions as to how best to do this.

 Ultimately I would like the result to be that by selecting a particular 
 column and for instance running a macro it would delete the matching part 
 numbers and their corresponding rows being that the column the part number 
 is located on changes from file to file.

 I do not expect anyone to do the work for me (although if you do I will be 
 eternally grateful) if you could give me the correct syntax for what I am 
 trying to do so I can appropriately find the answer this would be extremely 
 helpful.

 Thank you in advance. 
 -- 
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
 https://www.facebook.com/discussexcel
  
 FORUM RULES
  
 1) Use concise, accurate thread titles. Poor thread titles, like Please 
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security 
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.
  
 NOTE : Don't ever post confidential data in a workbook. Forum owners and 
 members are not responsible for any loss.
 --- 
 You received this message because you are subscribed to the Google Groups 
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an 
 email to excel-macros...@googlegroups.com javascript:.
 To post to this group, send email to excel-...@googlegroups.comjavascript:
 .
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.


 

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Microsoft Excel based application that digitizes data from pictures

2013-08-21 Thread Mog Godiva-Man
Yes Thanks guys. this was very helpful.




On Wed, Aug 21, 2013 at 1:49 AM, Sam Mathai Chacko samde...@gmail.comwrote:

 Did you try http://www.ozgrid.com/Services/excel-charts-digitized.htm
 On Aug 21, 2013 11:04 AM, P.VIJAYKUMAR vijay.4...@gmail.com wrote:

 Respected Mog-Godiva,

 You can find the digitizer from the following links,
 http://digitizer.sourceforge.net/
  http://www.mathtools.net/Excel/Graphics_and_Visualization/


 Regards,
 Vijaykumar


 On Wed, Aug 21, 2013 at 5:43 AM, Mog Godiva-Man osaze...@gmail.comwrote:

 Anyone know where I can get some Addin for digitizing data from
 graphical line/chart images in excel.

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

 FORUM RULES

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

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




 --









 P.VIJAY KUMAR

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

 FORUM RULES

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

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

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

 FORUM RULES

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

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


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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses 

$$Excel-Macros$$ Re: clubbing 200 excel files

2013-08-21 Thread svenyarl
Try the following macro.


Sub Macro1()


For i = 2 To 200

Sheets(i).Select

Range(A1:M99).Select
Selection.Copy


Sheets(Sheet1).Select

Range(A  CStr(i * 100)).Select
ActiveSheet.Paste


Next i

End Sub



On Saturday, August 17, 2013 5:54:38 AM UTC-7, summu wrote:

 Hi ,

 I have more than 200 excel files .i would like to merge all files into 
 one but i would like to have 200 sheets in one excel .i need your help 
 thank you 


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

FORUM RULES

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

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


Re: $$Excel-Macros$$ Formula or UDF to do Vlookup for values delimited with ]

2013-08-21 Thread prkhan56
Thanks De Premor,
Your code works on any sheet.
Regards
Rashid Khan

On Wednesday, August 21, 2013 3:22:48 AM UTC+4, De Premor wrote:

  try to replace current code with this

 Function LookForCode(Str As String, Data As Range, Colx As Integer, 
 Optional Delim As String = ])
 Dim Kode, Tmp As String
 For Each Kode In Split(Str, Delim)
 If Kode   Then Tmp = Tmp 
 WorksheetFunction.VLookup(Kode, Data, Colx, 0)
 Next
 LookForCode = Trim(Tmp)
 End Function

  Pada 20/08/2013 22:56, prkhan56 menulis:
  
  Thanks Ravinder,
 Couple of things if you would kindly rectify it please.
  
 1) For some reason, the UDF does not work for codes which is not on the 
 active sheet.  I had posted my problem for sake of explanation on the same 
 sheet but in reality it is on other sheet.  
 2) If you could please convert it to a macro so that I can *select the 
 codes* on any sheet in the  active workbook and run the macro then it 
 would *replace the codes with the answer on the same cell.*
   
 Really appreciate your help as it would save me lot of time.
 Regards
 Rashid Khan
  

 On Monday, August 19, 2013 11:49:04 AM UTC+4, Ravinder Negi wrote:

  
  PFA.There are three argument in UDF first lookup value , 
 lookarea(range),colnum
   --
  *From:* Rashid Khan prkh...@gmail.com
 *To:* excel-...@googlegroups.com 
 *Sent:* Sunday, August 18, 2013 9:32 PM
 *Subject:* $$Excel-Macros$$ Formula or UDF to do Vlookup for values 
 delimited with ]
  
  Hello All,
 I am attaching a sample of my problem.
 I need to do Vlookup from a Range which has Codes in Col A and Text in 
 Col B.
  
 I want to have the output required (highlighted in Yellow) on Col D based 
 on the Answers Col C.
  
 My problem is that the Codes are delimited with ].
 I do not want to separate the Answers using Text to Column.
  
 I tried the following and got the desired result if there is only one 
 code in the Answers Column.
 =VLOOKUP(LEFT(C2,FIND(],C2)-1),RangeCodes,2,0)
  
 As you can see in the attached sheet if there are many Codes combined 
 together then I cannot get the desired result.
  
   
  
 Is there a formula or a UDF which can give me the desired result.
  
 Please note that there are several Columns with the Codes combined.  I 
 have just used a sample column to demonstrate my problem.
  
 TIA
  
 Rashid Khan
  -- 
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
 https://www.facebook.com/discussexcel
  
 FORUM RULES
  
 1) Use concise, accurate thread titles. Poor thread titles, like Please 
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security 
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.
  
 NOTE : Don't ever post confidential data in a workbook. Forum owners and 
 members are not responsible for any loss.
 --- 
 You received this message because you are subscribed to the Google Groups 
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an 
 email to excel-macros...@googlegroups.com.
 To post to this group, send email to excel-...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.
  

 -- 
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
 https://www.facebook.com/discussexcel
  
 FORUM RULES
  
 1) Use concise, accurate thread titles. Poor thread titles, like Please 
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security 
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.
  
 NOTE : Don't ever post confidential data in a workbook. Forum owners and 
 members are not responsible for any loss.
 --- 
 You received this message because you are subscribed to the Google Groups 
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an 
 email to excel-macros...@googlegroups.com javascript:.
 To post to this group, send email to excel-...@googlegroups.comjavascript:
 .
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.


 

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? 

Re: $$Excel-Macros$$ Formula or UDF to do Vlookup for values delimited with ]

2013-08-21 Thread prkhan56
Hello Ravinder,
I have installed the Add-In as per your instruction but unfortunately it 
only works on the *Active Sheet* and not on any other sheet.
Please see if you could test your Add-in and fix the problem.
Thanks for your time and help once again.
Rashid Khan

On Wednesday, August 21, 2013 9:24:55 AM UTC+4, Ravinder Negi wrote:

 Hi, If this is working on correctly on active sheets then you can use 
 attached file (Addin), I have made this as addins now you can you this in 
 any of file but first you have to add this in your addins excel.

 first step:- save attached (addin File) where you want to save.
 second step :-go in file  --options--addins --click on go 
 button---browse and then select attached file where have u have 
 saved.pls revert if not working.

 Thanks  Regards
 Ravinder Negi


   --
  *From:* prkhan56 prkh...@gmail.com javascript:
 *To:* excel-...@googlegroups.com javascript: 
 *Cc:* ravinder negi ravi_c...@yahoo.com javascript: 
 *Sent:* Tuesday, August 20, 2013 9:26 PM
 *Subject:* Re: $$Excel-Macros$$ Formula or UDF to do Vlookup for values 
 delimited with ]
  
 Thanks Ravinder,
 Couple of things if you would kindly rectify it please.
  
 1) For some reason, the UDF does not work for codes which is not on the 
 active sheet.  I had posted my problem for sake of explanation on the same 
 sheet but in reality it is on other sheet.  
 2) If you could please convert it to a macro so that I can *select the 
 codes* on any sheet in the  active workbook and run the macro then it 
 would *replace the codes with the answer on the same cell.*
   
 Really appreciate your help as it would save me lot of time.
 Regards
 Rashid Khan
  

 On Monday, August 19, 2013 11:49:04 AM UTC+4, Ravinder Negi wrote:


 PFA.There are three argument in UDF first lookup value , 
 lookarea(range),colnum
   --
  *From:* Rashid Khan prkh...@gmail.com
 *To:* excel-...@googlegroups.com 
 *Sent:* Sunday, August 18, 2013 9:32 PM
 *Subject:* $$Excel-Macros$$ Formula or UDF to do Vlookup for values 
 delimited with ]
  
 Hello All,
 I am attaching a sample of my problem.
 I need to do Vlookup from a Range which has Codes in Col A and Text in Col 
 B.
  
 I want to have the output required (highlighted in Yellow) on Col D based 
 on the Answers Col C.
  
 My problem is that the Codes are delimited with ].
 I do not want to separate the Answers using Text to Column.
  
 I tried the following and got the desired result if there is only one code 
 in the Answers Column.
 =VLOOKUP(LEFT(C2,FIND(],C2)- 1),RangeCodes,2,0)
  
 As you can see in the attached sheet if there are many Codes combined 
 together then I cannot get the desired result.
  
  
  
 Is there a formula or a UDF which can give me the desired result.
  
 Please note that there are several Columns with the Codes combined.  I 
 have just used a sample column to demonstrate my problem.
  
 TIA
  
 Rashid Khan
 -- 
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
 https://www.facebook.com/ 
 discussexcel https://www.facebook.com/discussexcel
  
 FORUM RULES
  
 1) Use concise, accurate thread titles. Poor thread titles, like Please 
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security 
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.
  
 NOTE : Don't ever post confidential data in a workbook. Forum owners and 
 members are not responsible for any loss.
 --- 
 You received this message because you are subscribed to the Google Groups 
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an 
 email to excel-macros...@ googlegroups.com.
 To post to this group, send email to excel-...@googlegroups.com.
 Visit this group at http://groups.google.com/ 
 group/excel-macroshttp://groups.google.com/group/excel-macros
 .
 For more options, visit https://groups.google.com/ 
 groups/opt_outhttps://groups.google.com/groups/opt_out
 .


  

 

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

FORUM RULES

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

$$Excel-Macros$$ Extract Names which are not common

2013-08-21 Thread santosh subudhi
Hi Group,

Is it possible to extract the data which are not common between two coloums

Attached is sample sheet with problem

-- 
Regards
Santosh
santoshkumar.subu...@gmail.com

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

FORUM RULES

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

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


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


Re: $$Excel-Macros$$ I need to delete entire rows which contain exact matches from a static list on a seperate sheet

2013-08-21 Thread अनिल नारायण गवली
Dear svenyarl,

Pls share a worksheet with us.

Warm Regards,
Gawli Anil

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


On Wed, Aug 21, 2013 at 8:13 PM, sveny...@gmail.com wrote:

 I sample of the file I receive is as follows:

  25727861 GM DLT 1
 20130716  17091432 GM NS 8
 20121227  12527740 GM NS 8
 20121221  10328906 GM NS 0

  89018306 GM NS 12

  12617309 GM RB 44

  12365265 GM NS 10
 20121026  12588318 GM RB 18
 20120301  16631629 GM NS 11


 the comparing file is only a single column of part numbers by which need
 to be removed. In this example it would find part number 10328906 and
 delete it and the entire row containing it. Currently I insert a column and
 do a vlookup to match against the second list and then filter everything
 but #N/A and delete all matches then once are all removed I delete the
 added column. As I said before, I'm sure a easier way exists, but that I am
 simply not aware of it.

25735380  25735405  25735406  25735601  25735602

  25735604  11519347  11519349  25736491  25736492
 10328906
  25736678  25736711  25736714  25737609  25738783  25739412


























 On Wednesday, August 21, 2013 12:52:14 AM UTC-7, Ravinder Negi wrote:

 pls give some example file so we can do somthing..

   --
  *From:* sven...@gmail.com sven...@gmail.com
 *To:* excel-...@googlegroups.com
 *Sent:* Wednesday, August 21, 2013 7:09 AM
 *Subject:* $$Excel-Macros$$ I need to delete entire rows which contain
 exact matches from a static list on a seperate sheet

 I am open to suggestions on how best to go about this and am aware this
 might be a fairly simple request but I either lack the expertise or the
 correct vernacular to find the answer myself.

 On a daily basis I receive files of approximately 56000 rows of part
 numbers along with each parts pertinent data. From this I must remove parts
 located on a separate list of about 8000 parts from the original in order
 for the files to load correctly. So far I have been solving this by VLOOKUP
 and then manually deleting but I am aware there must be a quicker and
 easier way either by VBA, Macro, or SQL scripting. I am open to any
 suggestions as to how best to do this.

 Ultimately I would like the result to be that by selecting a particular
 column and for instance running a macro it would delete the matching part
 numbers and their corresponding rows being that the column the part number
 is located on changes from file to file.

 I do not expect anyone to do the work for me (although if you do I will
 be eternally grateful) if you could give me the correct syntax for what I
 am trying to do so I can appropriately find the answer this would be
 extremely helpful.

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

 FORUM RULES

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

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

 Visit this group at 
 http://groups.google.com/**group/excel-macroshttp://groups.google.com/group/excel-macros
 .
 For more options, visit 
 https://groups.google.com/**groups/opt_outhttps://groups.google.com/groups/opt_out
 .


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

 FORUM RULES

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

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