Re: $$Excel-Macros$$ Query 3

[saravanan R]

Hi Kalyan,

PFA the file updated with formula . I use index and Match Function to get
the results.

thanks,
Sarva

Thanks & Regards,

*Saravanan Raju*

Mob: +91 8807708842

+91 9449716334

On Tue, Nov 15, 2016 at 4:24 PM, Kal xcel  wrote:

> Dear Experts,
>
> Please help me to solve this query.
>
> Thanks in advance
>
>
> --
> *Kalyan Chattopadhyay*
>
>
> *Executive Corporate MIS*
>
> *Joy Cosmetics*
>
> --
> 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 https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Query 3.xlsx
Description: MS-Excel 2007 spreadsheet

$$Excel-Macros$$ Macro to extend the table to have next year

[saravanan R]

Hi Friends,

I need your help to build macro to extend the table with next year data in
the same table(Range).

Please attached the file , column B:D is the input table, and column F:H is
the output table.

1> I need to copy the vendor A data(B5:D7) from 2016 (Latest) and insert
this below the "2016" row and change Year to 2017

2> Also the row & Column range should be dynamic

Thanks in advance!


Thanks & Regards,

*Saravanan Raju*

Mob: +91 8807708842

+91 9449716334

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


EXTEND TABLE.xlsx
Description: MS-Excel 2007 spreadsheet

Re: $$Excel-Macros$$ Urgent need for Sharepoint Architech --Pittsburg ,PAb

[saravanan R]

Bvhcgh you are yycyucbd

-- 
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/d/optout.

Re: $$Excel-Macros$$ Urgent need for Sharepoint Architech --Pittsburg ,PAb

[saravanan R]

Bvhcgh you are yycyucbdb

-- 
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/d/optout.

$$Excel-Macros$$ Excel Books

[saravanan R]

Hello Experts,

Please provide me the sites for excel VBA 2013 books.


Thanks & Regards,

*Saravanan Raju*

Mob: +91 8807708842

+91 9449716334

-- 
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/d/optout.

Re: $$Excel-Macros$$ HArddisc Space Utility charts

[saravanan R]

On 28-Sep-2015 11:50 am, "saravanan R" <sarva0...@gmail.com> wrote:

> Hi Experts,
>
> I need your help on plotting an chart for HArd disc space utility.
> Please find the scenario below,
> I have 2 servers, each server as 3 drives and details of Space utilization
> of ech drive is given in the Attached excel file. Can you please advise me
> how to plot the chart for the given condition and also which type of Chart
> will be meaningful to report.
>
>
> Thanks & Regards,
>
> *Saravanan Raju*
>
> Mob: +91 8807708842
>
> +91 9449716334
>
> --
> 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/d/optout.
>

-- 
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/d/optout.

$$Excel-Macros$$ HArddisc Space Utility charts

[saravanan R]

Hi Experts,

I need your help on plotting an chart for HArd disc space utility.
Please find the scenario below,
I have 2 servers, each server as 3 drives and details of Space utilization
of ech drive is given in the Attached excel file. Can you please advise me
how to plot the chart for the given condition and also which type of Chart
will be meaningful to report.


Thanks & Regards,

*Saravanan Raju*

Mob: +91 8807708842

+91 9449716334

-- 
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/d/optout.


SERVER.xlsx
Description: MS-Excel 2007 spreadsheet

Re: $$Excel-Macros$$ Excel to Pdf

[saravanan R]

Hi Paul,
I found macros to export all the sheets to PDF, but I need to select only
the specified sheets into PDF.  If you have any references please share. It
will be very useful for me to make this task bit easier.

Thanks,
Saravanan R
On 13-Aug-2015 7:44 pm, Paul Schreiner schreiner_p...@att.net wrote:

 Are you familiar with macros?
 This is fairly straight forward with a simple macro.
 Especially if you're using Excel2007, 2010 or 2013.
 Earlier versions it's a bit more difficult.

 *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:* saravanan R sarva0...@gmail.com
 *To:* excel-macros@googlegroups.com
 *Sent:* Thursday, August 13, 2015 5:41 AM
 *Subject:* $$Excel-Macros$$ Excel to Pdf

 Hi,

 I have an query about exporting each sheet(multiple sheets but not all) of
 the excel workbook to Pdf and save this PDF by name provided in the list.

 This task should be automated, because there are 20 to 45 sheets in the
 report.
 Please help me sort out this time consuming task.

 thanks in advance.


 Thanks  Regards,
 *Saravanan Raju*
 Mob: +91 8807708842
 +91 9449716334
 --
 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/d/optout.


 --
 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/d/optout.


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

$$Excel-Macros$$ Excel to Pdf

[saravanan R]

Hi,

I have an query about exporting each sheet(multiple sheets but not all) of
the excel workbook to Pdf and save this PDF by name provided in the list.

This task should be automated, because there are 20 to 45 sheets in the
report.
Please help me sort out this time consuming task.

thanks in advance.


Thanks  Regards,

*Saravanan Raju*

Mob: +91 8807708842

+91 9449716334

-- 
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/d/optout.

Fwd: $$Excel-Macros$$ PIVOT TABLE CHART TAKE SCREEN SHOT

[saravanan R]

Hello Team,

I have an requirement where the data from Pivot table  chart as to be
copied into the Power point slide(or in the excel itself as bitmap image) .
In the same pivot table i have multiple filter(values) to select.

since I have to take 12(conditions) print screen from same pivot table and
chart, i need macro to automate these task.

thanks in advance.

Thanks  Regards,

*Saravanan Raju*

Mob: +91 8807708842

+91 9449716334

-- 
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/d/optout.

-- 
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/d/optout.

$$Excel-Macros$$ PIVOT TABLE CHART TAKE SCREEN SHOT

[saravanan R]

Hello Team,

I have an requirement where the data from Pivot table  chart as to be
copied into the Power point slide(or in the excel itself as bitmap image) .
In the same pivot table i have multiple filter(values) to select.

since I have to take 12(conditions) print screen from same pivot table and
chart, i need macro to automate these task.

thanks in advance.

Thanks  Regards,

*Saravanan Raju*

Mob: +91 8807708842

+91 9449716334

-- 
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/d/optout.

Re: $$Excel-Macros$$ Re: Query Regarding Duplicate and Update Status

[saravanan R]

On Wed, Mar 18, 2015 at 5:31 PM, saravanan R sarva0...@gmail.com wrote:

 Hi Mandeep,

 Thanks a Million.

 I have one more query related to the same file, is it possible to split
 the file based on Status OK wrt to each Coleague.
 and file name should be QueryDup-FK  QueryDup-BD (colleague name will be
 dyanmic)

 thanks in advance.


 On Wed, Mar 18, 2015 at 5:25 PM, Mandeep baluja mandeepbal...@gmail.com
 wrote:

 Try this ..


 Regards,
 MandeepBaluja
 Learningzmypassion.
 https://www.facebook.com/VBAEXCELSQL?ref=hl
 https://www.linkedin.com/profile/view?id=312532939

 On Wednesday, 18 March 2015 16:59:17 UTC+5:30, saravanan R wrote:

 Hello Team,

 I have an Query regarding Duplicate check for certain Criteria in
 filter. I need this  to be in VBA Code . Please see the details below and
 find the sample attached file with expected result mentioned.

 I have to filter for FK (Column B), Then find duplicate DOC.no for
 this colleague only. If the DOC no. is Duplicating then Update Status as
 OK, if it is Unique then update as NOT OK

 thanks in advance,

 Saravanan R
 +91 8807708842
 +91 9449716334

  --
 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/d/optout.




-- 
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/d/optout.

$$Excel-Macros$$ Query Regarding Duplicate and Update Status

[saravanan R]

Hello Team,

I have an Query regarding Duplicate check for certain Criteria in filter. I
need this  to be in VBA Code . Please see the details below and find the
sample attached file with expected result mentioned.

I have to filter for FK (Column B), Then find duplicate DOC.no for this
colleague only. If the DOC no. is Duplicating then Update Status as OK,
if it is Unique then update as NOT OK

thanks in advance,

Saravanan R
+91 8807708842
+91 9449716334

-- 
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/d/optout.


QUERY_DUP.xlsx
Description: MS-Excel 2007 spreadsheet

Re: $$Excel-Macros$$ Re: Query Regarding Duplicate and Update Status

[saravanan R]

Hi Mandeep,

Thanks a Million.

I have one more query related to the same file, is it possible to split the
file based on Status OK wrt to each Coleague.
and file name should be QueryDup-FK  QueryDup-BD (colleague name will be
dyanmic)

thanks in advance.


On Wed, Mar 18, 2015 at 5:25 PM, Mandeep baluja mandeepbal...@gmail.com
wrote:

 Try this ..


 Regards,
 MandeepBaluja
 Learningzmypassion.
 https://www.facebook.com/VBAEXCELSQL?ref=hl
 https://www.linkedin.com/profile/view?id=312532939

 On Wednesday, 18 March 2015 16:59:17 UTC+5:30, saravanan R wrote:

 Hello Team,

 I have an Query regarding Duplicate check for certain Criteria in filter.
 I need this  to be in VBA Code . Please see the details below and find the
 sample attached file with expected result mentioned.

 I have to filter for FK (Column B), Then find duplicate DOC.no for this
 colleague only. If the DOC no. is Duplicating then Update Status as OK,
 if it is Unique then update as NOT OK

 thanks in advance,

 Saravanan R
 +91 8807708842
 +91 9449716334

  --
 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/d/optout.


-- 
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/d/optout.

Re: $$Excel-Macros$$ Re: Import file from Text Fil

[saravanan R]

Hi Mandeep,

Thanks For your quick response, This is what actually i needed.

Thanks a Lot

Regrads,
Saravanan


On Mon, Dec 29, 2014 at 11:35 AM, Mandeep Baluja rockerna...@gmail.com
wrote:

 Sub Macro1()

 Dim fName As String

 fName = Application.GetOpenFilename(Text Files (*.txt), *.txt)
 If fName = False Then Exit Sub
 With ActiveSheet.QueryTables.Add(Connection:=TEXT;  fName, _
 Destination:=Range($A$1))
 .Name = IO Data1 (2)
 .FieldNames = True
 .RowNumbers = False
 .FillAdjacentFormulas = False
 .PreserveFormatting = True
 .RefreshOnFileOpen = False
 .RefreshStyle = xlInsertDeleteCells
 .SavePassword = False
 .SaveData = True
 .AdjustColumnWidth = True
 .RefreshPeriod = 0
 .TextFilePromptOnRefresh = False
 .TextFilePlatform = 437
 .TextFileStartRow = 1
 .TextFileParseType = xlDelimited
 .TextFileTextQualifier = xlTextQualifierDoubleQuote
 .TextFileConsecutiveDelimiter = False
 .TextFileTabDelimiter = True
 .TextFileSemicolonDelimiter = False
 .TextFileCommaDelimiter = False
 .TextFileSpaceDelimiter = False
 .TextFileColumnDataTypes = Array(1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
 1, 1, 1, 1, 1, 1, 1, 1, 1)
 .TextFileTrailingMinusNumbers = True
 .Refresh BackgroundQuery:=False
 End With

 End Sub



 Try this macro.



 Regards,
 Mandeep Baluja
 LearningZmyPassion
 https://www.linkedin.com/profile/view?id=312532939
 https://www.facebook.com/VBAEXCELSQL?ref=hl

 --
 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/d/optout.


-- 
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/d/optout.

$$Excel-Macros$$ Date format

[saravanan R]

Hi Team,

I have an query on replace . with / in the Data pulled from SAP .

Actually Format is,
 01.12.2014  17.12.2014 WHen I Do Manually Find  Replace,

It show me as ,
1/Dec/14
17/Dec/14.

But when I do through VBA COde,
I replace as,
12/Jan/14
INVALID DATE FORMAT)
Can You please check in and guide how i can make same format as Manual
Replace in VBA.

-- 
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/d/optout.

$$Excel-Macros$$ VBA to Vlookup from other Source!

[saravanan R]

Hi Team,

Please help me on Vlookup function where I will need to refer the file(by
browsing the path) and update the correponding data in the current file.

requirement as below:
col x=vlookup(col A current working file, rng, 2,0)

Col x  A refers to the current working file
but range I have to select from otherfile.

thanks  regards,
Saravanan

-- 
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/d/optout.

Re: $$Excel-Macros$$ VBA to Vlookup from other Source!

[saravanan R]

i am looking for VBA Macro for this , reference file to opened by browse
option then select the range.

thanks  regards,
Saravanan

On Mon, Dec 29, 2014 at 6:45 PM, saravanan R sarva0...@gmail.com wrote:

 Hi Team,

 Please help me on Vlookup function where I will need to refer the file(by
 browsing the path) and update the correponding data in the current file.

 requirement as below:
 col x=vlookup(col A current working file, rng, 2,0)

 Col x  A refers to the current working file
 but range I have to select from otherfile.

 thanks  regards,
 Saravanan

 --
 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/d/optout.


-- 
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/d/optout.

Re: $$Excel-Macros$$ VBA to Vlookup from other Source!

[saravanan R]

Reason behind is,
I am Working on a multiple manual task in one report, like already
enquired, pulling data from Text file, changing data formats, based on this
data pull information from other source, clean up templates.  etc

regards,
saravanan R

On Tue, Dec 30, 2014 at 12:33 PM, Mandeep Baluja rockerna...@gmail.com
wrote:

 Haha, Same question from my side too Vabz but i was still trying to get
 it. Too much logical by calling it with udf because whenever you're writing
 a function the excel files during browsing cant be opened.


 Trying this Macro to achieve  the result.


 Option Explicit


 Public Sub Test4vlookup()
 Dim lookupvalue As Variant
 MsgBox Welcome to vlookup Function

 lookupvalue = Application.InputBox(Please provide the Lookup value)

 Dim Filename As Variant
 Dim fld As Variant
 Set fld = Application.FileDialog(msoFileDialogFilePicker)
 fld.Show
 Filename = fld.SelectedItems(1)
 Workbooks.Open (Filename)

 Dim Workrng As Range
 Set Workrng = Application.Selection
 Set Workrng = Application.InputBox(Select the Range for Vlookup,
 Vlookup, Workrng.Address, Type:=8)
 Dim columnnumber As Long
 columnnumber = Application.InputBox(Enter the Column no, Vlookup,
 Type:=2)
 MsgBox lookupvalue
 MsgBox columnnumber
 MsgBox Workrng.Address

 ActiveCell.Formula = =vlookup(lookupvalue.value,Filename
 Workrng.address,columnnumber.value,0)

 'Myvlookup=Application.WorksheetFunction.VLookup(FilenameSheet1!lookupvalue,Workrng
 ActiveCell.Value = Myvlookup

 End Sub


 Regards,
 Mandeep Baluja
 LearningZmyPassion
 https://www.linkedin.com/profile/view?id=312532939
 https://www.facebook.com/VBAEXCELSQL?ref=hl

 --
 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/d/optout.


-- 
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/d/optout.

Re: $$Excel-Macros$$ Re: Import file from Text Fil

[saravanan R]

Hi Mandeep,

This what I needed, but through VBA code. Because i Have to get this
imported Data into other excel Template.
Can you please share how we can proceed through VBA.

thanks  regards,
Saravanan R

On Fri, Dec 26, 2014 at 5:28 PM, Mandeep Baluja rockerna...@gmail.com
wrote:

 Want this result ?
 Regards,
 Mandeep Baluja
 LearningZmyPassion
 https://www.linkedin.com/profile/view?id=312532939
 https://www.facebook.com/VBAEXCELSQL?ref=hl


 On Friday, December 26, 2014 4:33:13 PM UTC+5:30, saravanan R wrote:

 Hi Team,

 I have an query on Importing text file , delimit by Seperator and make
 particular column to be text, and import the same data into excel update
 those data from Row 2.

 thanks  regards,
 saravanan R

  --
 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/d/optout.


-- 
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/d/optout.

$$Excel-Macros$$ Import file from Text Fil

[saravanan R]

Hi Team,

I have an query on Importing text file , delimit by Seperator and make
particular column to be text, and import the same data into excel update
those data from Row 2.

thanks  regards,
saravanan R

-- 
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/d/optout.

Re: $$Excel-Macros$$ Re: Import file from Text Fil

[saravanan R]

here it is

On Fri, Dec 26, 2014 at 4:55 PM, Mandeep Baluja rockerna...@gmail.com
wrote:

 send file

 On Friday, December 26, 2014 4:33:13 PM UTC+5:30, saravanan R wrote:

 Hi Team,

 I have an query on Importing text file , delimit by Seperator and make
 particular column to be text, and import the same data into excel update
 those data from Row 2.

 thanks  regards,
 saravanan R

  --
 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/d/optout.


-- 
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/d/optout.
000707  SAR VAOOWJO (MWX)   600660.06.2014  6000802776  
8   XXIOW666T60 OW666\T60   6800,000600,000 6600,000
6,872668,00 6600,0002668,00 0,000   0,0006.62.2014   N\A
06.62.2014
000707  SAR VAOOWJO (MWX)   600670.00.2014  6000868766  
00022   XXIRZ7XT60  RZ7X\T600060,000200,000 0760,000
0,707682,00 7220,0000660,00 0,000   0,0028.66.2014   N\A
67.62.2014
000707  SAR VAOOWJO (MWX)   600670.00.2014  6000868766  
00068   XXIOW666T60 OW666\T60   6800,0000,000   6800,000
6,877766,00 0,000   0,006800,0007766,00 26.62.2014  0 or 
OWss   . .
000707  SAR VAOOWJO (MWX)   600606.06.2014  6000876266  
7   XXIOW686T60 OW686\T60   7600,0002200,000
6600,0006,602760,00 6600,0002760,00 0,000   0,00
00.62.2014   N\A27.66.2014
000707  SAR VAOOWJO (MWX)   600620.06.2014  6000870866  
2   XXXWON7077  WON7\0776080,0000,000   6080,000
6,08,60 6080,000,60 0,000   0,0027.62.2014   N\A
27.62.2014
000707  SAR VAOOWJO (MWX)   600627.06.2014  6000878668  
6   XXIRZ7XT60  RZ7X\T602000,0000,000   2000,000
0,706000,00 2000,0006000,00 0,000   0,0028.66.2014   N\A
06.62.2014
000707  SAR VAOOWJO (MWX)   600627.06.2014  6000878666  
0   XXIOW676T60 OW676\T60   0600,0002800,000
2600,0006,706000,00 2600,0006000,00 0,000   0,00
66.66.2014   N\A66.62.2014
000707  SAR VAOOWJO (MWX)   600620.07.2014  6000888670  
00062   XXIOW006T60 OW006\T60   6800,000600,000 6600,000
0,866676,00 6200,0007602,00 0,000   0,0008.62.2014   N\A
66.62.2014
000707  SAR VAOOWJO (MWX)   600620.07.2014  6000888670

Re: $$Excel-Macros$$ Fwd: Excel Spellcheck Help.

[saravanan R]

Hi Frnds,

Any Idea for the given below Reuqest?


*Thanks  Regards,*

*Saravanan R*

*BDI India Private Limited*

“Shreeshyla”, Doddakallasandra,

Kanakapura Road, Bangalore 560 062 INDIA

Ph: 91-80-22560418/19

Fax: 91-80-22560420

Cell: +919449716334

sarava...@bdi-india.com

* *

[image: BDI 75 yr]

*www.bdiworldwide.com*

On Mon, Jan 21, 2013 at 2:44 PM, saravanan R sarva0...@gmail.com wrote:

  Hi Excites,

 ** **

 ** **

 I need your help on using the Spell check in the Excel File.

 I have around 4 line items, where I want to use the spell check for
 the complete Column. If I go through the Spell Check Process (Press F7), *
 ***

 there are some words which are don’t correct require no changes(Ignore
 all) but some words require changes. 

 In this case I want to mark out those word in the adjacent(Separate)
 column.

 **

 ** **

 *Thanks  Regards,*

 *Saravanan R*

 *BDI India Private Limited*

 “Shreeshyla”, Doddakallasandra,

 Kanakapura Road, Bangalore 560 062 INDIA

 Ph: 91-80-22560418/19

 Fax: 91-80-22560420

 Cell: +919449716334

 sarava...@bdi-india.com

 *  *

 [image: BDI 75 yr]

  *www.bdiworldwide.com***

 ** **

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


image001.jpg

Re: $$Excel-Macros$$ Help need to get multiple values by vlookup

[saravanan R]

Hi Xlts,

Thanks for all your Inputs and suggestions.
Finally I could able to Sort it Out by Countif and Vlookup Function.
Please refer the file attached.


thanks,
Saravanan

On Thu, Oct 25, 2012 at 10:11 AM, अनिल नारायण गवली
gawlianil8...@gmail.comwrote:

 Pl Share a sample sheet with us


 On Thu, Oct 25, 2012 at 9:52 AM, David Grugeon da...@grugeon.com.auwrote:

 It seems to me that sorting might be a better approach than a vlookup.

 Regards
 David Grugeon


 On 25 October 2012 14:15, Saravanan sarva0...@gmail.com wrote:
  Hi
 
  I need this because need to know which are all the items belongs to one
  value. By this values I can assign the items need to work.
 
  Thanks,
  Saravanan.
 
  On Oct 25, 2012, at 12:13 AM, Paul Schreiner schreiner_p...@att.net
 wrote:
 
  Are you saying that your VLookup Value occurs in multiple rows in your
  table?
  or that you want to return multiple values from the single match?
 
  Then.. what do you want to do with the results?
 
 
  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: Saravanan sarva0...@gmail.com
  To: excel-macros@googlegroups.com excel-macros@googlegroups.com
  Sent: Wed, October 24, 2012 2:36:05 PM
  Subject: $$Excel-Macros$$ Help need to get multiple values by vlookup
 
  Hi xlts,
 
  Please help me, on how to get the all the associated items In the range
  where it as more than 1 lookupvalue.
 
  Thanks,
  Saravanan
 
  --
  Join official facebook page of this forum @
  https://www.facebook.com/discussexcel
 
  FORUM RULES (1120+ members already BANNED for violation)
 
  1) Use concise, accurate thread titles. Poor thread titles, like Please
  Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will
  not get quick attention or may not be answered.
 
  2) Don't post a question in the thread of another member.
 
  3) Don't post questions regarding breaking or bypassing any security
  measure.
 
  4) Acknowledge the responses you receive, good or bad.
 
  5)  Cross-promotion of, or links to, forums competitive to this forum in
  signatures are prohibited.
 
  6) Jobs posting is not allowed.
 
  7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
  NOTE  : Don't ever post personal or confidential data in a workbook.
 Forum
  owners and members are not responsible for any loss.
  ---
  You received this message because you are subscribed to the Google
 Groups
  MS EXCEL AND VBA MACROS group.
  To post to this group, send email to excel-macros@googlegroups.com.
  To unsubscribe from this group, send email to
  excel-macros+unsubscr...@googlegroups.com.
 
 
  --
  Join official facebook page of this forum @
  https://www.facebook.com/discussexcel
 
  FORUM RULES (1120+ members already BANNED for violation)
 
  1) Use concise, accurate thread titles. Poor thread titles, like Please
  Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will
  not get quick attention or may not be answered.
 
  2) Don't post a question in the thread of another member.
 
  3) Don't post questions regarding breaking or bypassing any security
  measure.
 
  4) Acknowledge the responses you receive, good or bad.
 
  5) Cross-promotion of, or links to, forums competitive to this forum in
  signatures are prohibited.
 
  6) Jobs posting is not allowed.
 
  7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
  NOTE : Don't ever post personal or confidential data in a workbook.
 Forum
  owners and members are not responsible for any loss.
  ---
  You received this message because you are subscribed to the Google
 Groups
  MS EXCEL AND VBA MACROS group.
  To post to this group, send email to excel-macros@googlegroups.com.
  To unsubscribe from this group, send email to
  excel-macros+unsubscr...@googlegroups.com.
 
 
 
  --
  Join official facebook page of this forum @
  https://www.facebook.com/discussexcel
 
  FORUM RULES (1120+ members already BANNED for violation)
 
  1) Use concise, accurate thread titles. Poor thread titles, like Please
  Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will
  not get quick attention or may not be answered.
 
  2) Don't post a question in the thread of another member.
 
  3) Don't post questions regarding breaking or bypassing any security
  measure.
 
  4) Acknowledge the responses you receive, good or bad.
 
  5) Cross-promotion of, or links to, forums competitive to this forum in
  signatures are prohibited.
 
  6) Jobs posting is not allowed.
 
  7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
  NOTE : Don't ever post personal or confidential data in a workbook.
 Forum
  owners and members are not 

$$Excel-Macros$$ Sorting option in Filter Disable-Shortcut Key.Excel 2007

[saravanan R]

Hi Excelates,

I need an Urgent help on disabling the Sort in the filter dropdown.
Is there a way to disable only the short cut key i.e only the letter s
 a in the Filter Drop down list.(available in the Excell 2007)

thanks  regards,
Saravanan

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel