Re: $$Excel-Macros$$ Unsubscribing due to unsolicited emails

[Eugene Bernard]

Noted Paul...

Thanks'
Eugene

On Thu, Aug 9, 2018 at 8:51 PM Paul Schreiner 
wrote:

> Dear fellow programmers,
> I have been a member of this group for a number of years, but the extreme
> abundance of unsolicited SPAM in the form of job postings (which is
> specifically disallowed in the forum rules) has forced me to choose to
> unsubscribe from this group.
>
> For those I have worked with in the past, feel free to hang onto my email
> address and contact me directly.
> I would enjoy keeping in touch.
>
> I'm sure you'll find me on other VBA help sites!
>
> Paul Schreiner
>
> --
> 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.

Re: $$Excel-Macros$$ Macros for screenshot

[Eugene Bernard]

use

ActiveSheet.Paste

to paste the content from excel clipboard.

Regards
Eugene

On Thu, Mar 23, 2017 at 1:43 PM, suresh k  wrote:

> Hi All,
>
> I have 10 files in my c drive. I have to capture other applications
> screenshot and paste in all 10 files.
>
> I am able to capture screenshot, but not able to paste in 10 excel file.
>
> Please suggest macro to paste screenshot in all files
>
> Regards,
> Suresh
>
> --
> 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.

Re: $$Excel-Macros$$ Accessing a function of another Workbook.

[Eugene Bernard]

Thank you Mr Paul.

Regards
Eugene

On Mon, Nov 21, 2016 at 6:36 PM, Paul Schreiner <schreiner_p...@att.net>
wrote:

> Yes:
>
> First, make sure the functions are defined as "public".
> As in:
> In Book1.xlsb:
> Public Function Test_Calc(iVal)
> Test_Calc = iVal + 10
> End Function
>
> In Book2, use:
> =Book1.xlsb!Test_Calc(A2)
>
> *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*
> -----
>
>
> On Monday, November 21, 2016 3:31 AM, Eugene Bernard <
> eugene.bern...@gmail.com> wrote:
>
>
> I have two open workbooks A and B, in my system, and I like to use the
> function available in Workbook A from Workbook B.
>
> Is it possible.
>
> Regards
> Eugene
> --
> 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.
>

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

$$Excel-Macros$$ Accessing a function of another Workbook.

[Eugene Bernard]

I have two open workbooks A and B, in my system, and I like to use the
function available in Workbook A from Workbook B.

Is it possible.

Regards
Eugene

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

Re: $$Excel-Macros$$ Re: ExcelQuery

[Eugene Bernard]

Thanks Mark !!!

Regards
Eugene

On Wed, Apr 20, 2016 at 7:06 AM, noodnutt  wrote:

> Hi Eugene
>
> This link provides an example of extracting data from multiple workbooks
> and condensing it into 1 file:
>
> https://msdn.microsoft.com/en-us/library/gg549168.aspx
>
> As a side note, Ron De Bruin's website has some great examples:
>
> http://www.rondebruin.nl/windows_articles.htm
>
> HTH
> Mark.
>
> --
> 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.

$$Excel-Macros$$ ExcelQuery

[Eugene Bernard]

Hi All,

Please find attached Book1.xls, where in I am using an ExcelQuery Script to
extract data from 12 different files and saving it in 12 sheets.
I like to save the data in single sheet.

Regards
Eugene

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


Book1.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Correction required in highlet cell & refresh d15 automatically when last any entry of any raw change

[Eugene Bernard]

Please remove the $ from the formuala

=AND(F5<>"",F5 wrote:

>
>
>
> Respected All
>
> I have attached excel files too  It has some still issue . I think there
> is some correction required   in the formula  1]  When  F column falls
> under 15 days before today -- only that time full raw should be yellow  Today
> is 9/1/2016  so any date from 9/1/2016 to 24/1/16 -- then only full raw
> should be yellow  But at present it happens even if due date is before
> today also -- ex  f6 is  15/12/2015  then also it become yellow 2] In
> Cell - D 15  not work according to my question  If I make any changes in
> any cell   ex -- If I make the change in Raw 9 In stead of mediclaim I
> put shop in e9 also  change in R 9 -- some change  Then all the details
> pertaining -- respectively  change in D 15 at present it not change for D
> 15 3] I have to refesh my cell entry then It show change I want that if I
> make any changes in any raw  then last updated raw details  then it
> should automatically updates all  details of that raw  & show it on Cell
> D15 Thanks 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+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.

$$Excel-Macros$$ Split a row based on a condition

[Eugene Bernard]

Hi all,

Please find below a snap, My requirment scenario is, I have components like
"A001","C001" and  "B001" going thro 3 production process, i call it

here as Stages as "S1","S2" and "S3".

If I release a work order to produce a component "A001" on 25th Aug, it
goes thro 3 stages on various days and gets completed on 29th Aug.
For the component "A001", I have no issue in capturing the production flow
pattern.
 where as if you look at the flow pattern for the component B001, only
partial quantity is taken for processing on 17th July.
There fore whenever partial quantities are taken in the down stream
processes, I want to split the original WO row into two as shown in
rows 10 and 12.

Can anybody help me to split the rows using VBA whenever partial quantities
taken during susequent processes.




TIA
Eugene

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


Example_1.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Formula to Display Latest PO number Using date and emp ID

[Eugene Bernard]

Hi Van,

Excellent sample, Thanks.

Eugene

On Wed, Jul 22, 2015 at 12:47 AM, Bé Trần Văn betnmtdongna...@gmail.com
wrote:

 B3 selected in the drop down list, View Results.

 2015-07-21 19:08 GMT+07:00 Paul Schreiner schreiner_p...@att.net:

 First:
 Your EMP ID field is mixed with text and numbers.
 Probably because this list was imported from another source.
 (generated a report as a text file and opened it in Excel?)

 then, if you click in one of the cells, or remove spaces, or interact
 with the cell in several other ways, Excel reinterprets the cell contents
 as numeric.

 (that's why some of your cells have a green triangle in the top-left.
 It indicates that the cell format is different than the previous)

 this is significant because when you type the EMP ID in Sheet9, Excel
 will automatically treat it as a NUMBER.
 then, when you look up and compare the values in Data with the value in
 Sheet9, a text 123 does NOT equal a NUMBER 123..

 So you need to make them the same format.

 What *I* did was select column B and replace 2 with 2.
 Excel then converted the entire column to a numeric.

 NEXT:

 the =VLOOKUP() function has the format:
 VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

 In this, the [range_lookup] flag indicates if you want an EXACT MATCH
 or APPROXIMATE MATCH.

 To use this properly, your Data needs to be sorted by EMP ID and then by
 Period To.

 Then, in Sheet9 use the formula:
 =VLOOKUP(E2,Data!B:E,4,TRUE)

 Interestingly enough, if you use Range_Lookup = FALSE, Vlookup will
 return the FIRST line that exactly matches the EMP_ID.
 If you set it to TRUE, it'll return the LAST record.

 So, if you sort the data by EMP_ID and Newest-to-oldest of the Period
 To, you would use Range_Lookup = FALSE.
 if you sorted by EMP_ID and oldest-to-newest of Period To, you would
 use Range_Lookup = TRUE.

 I also added an indicator to the Data sheet to see which PRF is selected
 (for testing purposes)

 Hope this helps.

 *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:* SridharBL sridhar@gmail.com
 *To:* excel-macros@googlegroups.com
 *Sent:* Tuesday, July 21, 2015 7:39 AM
 *Subject:* $$Excel-Macros$$ Formula to Display Latest PO number Using
 date and emp ID

 Dear Friends,

 I need help in creating the formula in attached file.

 In attached sheet. I have Sheet9 and  Data Sheets.

 In Sheep 9, If I type the Emp ID in the cell, its should look for data in
 Data sheet for the Emp ID and Latest Date for in column Period To and
 get the New PO number that will be displayed in next cell.

 Attache file is self explanatory.

 Request you help.

 Thanks
 Sridhar BL
  --
 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 

Re: $$Excel-Macros$$ What will be the best code to count the number of visible rows after autofilter.

[Eugene Bernard]

Hi Mandeep,

Just check the attached example.

Regards
Eugene

On Fri, Mar 20, 2015 at 11:59 PM, Mandeep Baluja rockerna...@gmail.com
wrote:

 Hey Eugene,,not easy as you're thinking

 This code will not give the correct result end -start +1 will never be
 equal to no of hide rows with filter, because these variable dont know the
 actual no of hidden rows between the data.

 for example see data  if i hide 2 and 4, first visible row will be 2 and
 last visible row will be 6 , total values visible are 3 left(1,3,6)

 6-2+1 = 5

 Data-A1
 1-A2
 2-A3
 3-A4
 4-A5
 5-A6

 Created this one working effectively on huge amount of data without taking
 time. :)

 ActiveSheet.UsedRange.Columns(1).Copy
 Sheets(2).Range(a1).PasteSpecial
 lr = Sheets(2).Cells(Rows.Count, 1).End(xlUp).Row
 Debug.Print Sheets(2).UsedRange.Rows.Count - 1

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





 On Friday, March 20, 2015 at 9:35:43 PM UTC+5:30, Eugene Bernard wrote:

 The below code already given in this group by Mr Asish Kumar

 start= ActiveSheet.UsedRange.Offset(1).SpecialCells(
 xlCellTypeVisible).Row
 end= ActiveSheet.UsedRange.SpecialCells(xlCellTypeLastCell).Row
 norows=end-start+1

 Regards
 Eugene

 On Thu, Mar 19, 2015 at 12:56 PM, Mandeep baluja mandee...@gmail.com
 wrote:


 any other code ?? excep this one

 For Each rngarea In .SpecialCells(xlCellTypeVisible).Areas
 lcount = lcount + rngarea.Rows.Count
 Next

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

Re: $$Excel-Macros$$ What will be the best code to count the number of visible rows after autofilter.

[Eugene Bernard]

The below code already given in this group by Mr Asish Kumar

start= ActiveSheet.UsedRange.Offset(1).SpecialCells(xlCellTypeVisible).Row
end= ActiveSheet.UsedRange.SpecialCells(xlCellTypeLastCell).Row
norows=end-start+1

Regards
Eugene

On Thu, Mar 19, 2015 at 12:56 PM, Mandeep baluja mandeepbal...@gmail.com
wrote:


 any other code ?? excep this one

 For Each rngarea In .SpecialCells(xlCellTypeVisible).Areas
 lcount = lcount + rngarea.Rows.Count
 Next

  --
 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$$ Finding Start and End visible Row numbers

[Eugene Bernard]

Hi Asish,

Thank you, The two line code is very useful for me.


Thanks again.

Eugene


On Fri, Mar 6, 2015 at 5:04 PM, Ashish Kumar kumar.ashish...@gmail.com
wrote:

 Hi Eugene,


 PFA, Filter your data then after hit the button


 Regards
 Ashish


  --
 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$$ Finding Start and End visible Row numbers

[Eugene Bernard]

Dear Vaibhav,

When I hit the button, I am getting the below error.

[image: Inline image 1]
Regards
Eugene

On Sat, Mar 7, 2015 at 4:00 PM, Vaibhav Joshi v...@vabs.in wrote:

 Check this..

 Cheers!!

 On Fri, Mar 6, 2015 at 5:04 PM, Ashish Kumar kumar.ashish...@gmail.com
 wrote:

 Hi Eugene,


 PFA, Filter your data then after hit the button


 Regards
 Ashish


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

Re: $$Excel-Macros$$ Re: Finding Start and End visible Row numbers

[Eugene Bernard]

Mandeep,

Thanks for the reply. But this is not my requirement.

Please see the below macro.

Sub test()
ThisWorkbook.Activate
mynum = Application.InputBox(Enter a Code)
Cells(1, 25).Value = (mynum)
ActiveSheet.ListObjects(Table1).Range.AutoFilter Field:=1,
Criteria1:=mynum
End Sub

The user input will be starting strings of the codes available in the first
column of the file.

for example if i give input like DW*, i should get/know  the start and end
row values as 14 and 19 as shown below using

VBA.

[image: Inline image 1]

Regards
Eugene









On Thu, Mar 5, 2015 at 12:02 PM, Mandeep baluja mandeepbal...@gmail.com
wrote:

  check this there are many method but i am using this.


 Regards,
 Mandeep Baluja

 --
 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: Finding Start and End visible Row numbers

[Eugene Bernard]

Thank you Mandeep !!!

Now i got it.

Regards
Eugene

On Thu, Mar 5, 2015 at 4:49 PM, Mandeep baluja mandeepbal...@gmail.com
wrote:

 giving correct results which is going in g7 and g8 what else do you want

 Sub test()
 ThisWorkbook.Activate
 mynum = dw*
 Cells(1, 25).Value = (mynum)
 ActiveSheet.ListObjects(Table1).Range.AutoFilter Field:=1,
 Criteria1:=mynum
 lr = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row

 For i = 2 To lr
 If Range(A  i).EntireRow.Hidden = False Then
 firstrow = i
 GoTo Deco
 End If
 Next

 Deco:
 For j = lr To 1 Step -1
 Debug.Print j
 If Range(A  j).EntireRow.Hidden = False Then
 lastrow = j
 Exit For
 End If

 Next

 Range(G7).Value = firstrow
 Range(G8).Value = lastrow

 End Sub


  --
 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$$ Finding Start and End visible Row numbers

[Eugene Bernard]

Hi all,

Please find attached a sample file , where I use a macro test to filter
code.

I like to get the Start and End row numbers of the filtered rows.

For example if I give the filter value of CP*, the start and end row
numbers for the

visbile rows are 7 and 13 respectively.

How to get these values using VBA.

TIA.

Regards
Eugene

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


Prices.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Worksheet Function

[Eugene Bernard]

Thank you Mr Paul, for the detailed explanation. I missed to include the
keyword Range and the Quotes.
It works now.

Regards
Eugene

On Fri, Jan 9, 2015 at 12:58 AM, Paul Schreiner schreiner_p...@att.net
wrote:

 OK,
 In your macro, you're trying to the use the Subtotal worksheet function.

 First, you need to understand the requirements for the Subtotal function.

 In Excel, the function looks like:
 Subtotal(function_num,range1,range2, etc.)
 (at least 1 range is required)

 In your case, you tried:
 MsgBox WorksheetFunction.Subtotal(9, B2, B9)

 In VBA, you've just said to use the number 9 as the function number (which
 is for SUM)
 but you said to use a VARIABLE called B2 and B9 as the first and second
 ranges.

 Now, if you've done something like:

 Dim B2 as Range
 Dim B9 as Range

 Then something like:

 Set B2 = Range(B2:B8)
 Set B9 = Range(B9)

 Then your statement:
 MsgBox WorksheetFunction.Subtotal(9, B2, B9)
 would work.

 However, I SUSPECT that what you were trying to do is get the subtotal of
 B2 THRU B9
 which would be like B2:B9

 Even the, B2:B9 doesn't define a RANGE, it defines a STRING.

 you need to tell VBA to interpret the string as a range.

 MsgBox WorksheetFunction.Subtotal(9, Range(B2:B9))

 should work.


 *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:* Eugene Bernard eugene.bern...@gmail.com
 *To:* excel-macros@googlegroups.com
 *Sent:* Thursday, January 8, 2015 11:50 AM
 *Subject:* $$Excel-Macros$$ Worksheet Function

 Please find attached a sheet, where i am facing a error in the

 one liner macro.

 TIA

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

$$Excel-Macros$$ Worksheet Function

[Eugene Bernard]

Please find attached a sheet, where i am facing a error in the

one liner macro.

TIA

Regards
Eugene

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


Book1.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Happy New 2015

[Eugene Bernard]

Hi all,

Happy new year to you all.

Regards
Eugene

On Wed, Dec 31, 2014 at 7:54 PM, Vaibhav Joshi v...@vabs.in wrote:

 Joyous January –Fabulous February

 Magical March –Adorable April

 Magnificent May –Jolly June

 Jubilant July –Awesome August

 ScintillatingSeptember –Outstanding October

 Naughty November –Dazzling December

 This is how I sincerely wish your New Year to be!

 Yu Year – Happy Year..

 A Very Happy New Year 2015! To all group members.

 Cheers!!

 --
 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$$ Put Text Strings from Excel file to Outlook calander

[Eugene Bernard]

Hi Vaibhav,

Thanks for your time and effort. I too accomplished by using
Outlook/File/Import and Export, available in Outlook menu.

Anyway, your code will help me go indepth.

Thanks again.
Eugene


On Sat, Dec 13, 2014 at 8:29 PM, Vaibhav Joshi v...@vabs.in wrote:

 Hi

 Add a reference to the Microsoft Outlook Object Library (Tools 
 References... in the VBA editor)

 Check this..

 +
 *I did not do this for you. God is here working through me for you.*

 On Fri, Dec 12, 2014 at 10:31 PM, Eugene Bernard eugene.bern...@gmail.com
  wrote:

 Just like put a string inside a day box, for each day in the excel sheet,
 where ever test columns have some entries.

 Eugene

 On Fri, Dec 12, 2014 at 10:27 PM, Vaibhav Joshi v...@vabs.in wrote:

 Is it appointment? What is start time? Duration?

 Check this helps:
 http://www.mrexcel.com/forum/excel-questions/553718-excel-visual-basic-applications-update-create-delete-appointments.html

 +
 *I did not do this for you. God is here working through me for you.*

 On Fri, Dec 12, 2014 at 9:52 PM, Eugene Bernard 
 eugene.bern...@gmail.com wrote:

 I like to put the strings from the column test of attached excel file
 in the Outlook calander (month format), based on date values. Is it
 possible.

 TIA
 Eugene

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

$$Excel-Macros$$ Put Text Strings from Excel file to Outlook calander

[Eugene Bernard]

I like to put the strings from the column test of attached excel file in
the Outlook calander (month format), based on date values. Is it possible.

TIA
Eugene

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


Date and Texts.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Put Text Strings from Excel file to Outlook calander

[Eugene Bernard]

Just like put a string inside a day box, for each day in the excel sheet,
where ever test columns have some entries.

Eugene

On Fri, Dec 12, 2014 at 10:27 PM, Vaibhav Joshi v...@vabs.in wrote:

 Is it appointment? What is start time? Duration?

 Check this helps:
 http://www.mrexcel.com/forum/excel-questions/553718-excel-visual-basic-applications-update-create-delete-appointments.html

 +
 *I did not do this for you. God is here working through me for you.*

 On Fri, Dec 12, 2014 at 9:52 PM, Eugene Bernard eugene.bern...@gmail.com
 wrote:

 I like to put the strings from the column test of attached excel file
 in the Outlook calander (month format), based on date values. Is it
 possible.

 TIA
 Eugene

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

$$Excel-Macros$$ To find ADO object reference

[Eugene Bernard]

How to find programattically using VBA, whether Ms-ADO object is already
referenced in my excel vba project.

TIA
Eugene


[image: Inline image 1]



On Mon, Dec 8, 2014 at 4:51 PM, Rakesh rksharma...@gmail.com wrote:

 hello Experts,

 Need an index formula which combined the index which have na data

 reference sheet attached

 thanks in advance.


 Br//​

 RAKESH SHARMA
 NPI –Team
 Ericsson India Pvt. Ltd.
 4th Floor, Gupta Towers, Commercial Block, Rail Head
 Jammu  Kashmir, INDIA
 Phone 01912477440/ 01912477473/441
 Fax 01912477442
 Mobile +91 9906115140 #14a29a1bcf8d394b_
 rakesh.kumar.d.sha...@ericsson.com
 www.ericsson.com

 “If You fall, fall like a seed to germinate, not like a leaf to die.”

  --
 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$$ Tandem filtering

[Eugene Bernard]

Paul,

Thank you very much, for the detailed explanation.

Regards
Eugene

On Wed, Nov 19, 2014 at 6:27 PM, Paul Schreiner schreiner_p...@att.net
wrote:

 In the Orders file, you have:

 ActiveSheet.ListObjects(Table1).Range.AutoFilter Field:=2,
 Criteria1:=MYNUM

 Breaking this down:
 ListObjects is a property of the Worksheet Object.
 That means that it needs a Worksheet in order to operate.

 In your case, you've specified that you want the ListObjects property of
 the Activesheet.

 Activesheet actually a short way of saying
 the active sheet of the active workbook

 Instead, you COULD have said something like:

 Workbooks(Orders.xls).Sheets(1)
 which specifies the first sheet of the workbook called Orders.xls

 or
 Workbooks(Orders.xls).Sheets(Sheet1)
 specifies the sheet called Sheet1 in the workbook called Orders.xls

 So, if you specify a sheet in ANOTHER workbook, you can use something like:

 Workbooks(Orders.xls).Sheets(Sheet1).ListObjects(Table1).Range.AutoFilter
 _
Field:=2, Criteria1:=MYNUM
 Workbooks(Stocks.xls).Sheets(Sheet1).ListObjects(Table1).Range.AutoFilter
 _
Field:=1, Criteria1:=MYNUM

 (notice that your ITEM field in the Stocks workbook is column 1
 instead of 2)

 hope this helps

 *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:* Eugene Bernard eugene.bern...@gmail.com
 *To:* excel-macros@googlegroups.com
 *Sent:* Tuesday, November 18, 2014 11:13 AM
 *Subject:* $$Excel-Macros$$ Tandem filtering

 Hi all,

 I have attached two workbooks, Orders and Stocks.

 In the Orders workbook, I have a macro, which filters Itemwise once I run
 the macro and enter the filter values like A001, A002 etc.,.

 I like to have a slight modifications in the same macro, so that, when I
 run the macro, filtering should  happen simultaneously in the both
 workbooks Orders and Stock

 TIA

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

$$Excel-Macros$$ Tandem filtering

[Eugene Bernard]

Hi all,

I have attached two workbooks, Orders and Stocks.

In the Orders workbook, I have a macro, which filters Itemwise once I run
the macro and enter the filter values like A001, A002 etc.,.

I like to have a slight modifications in the same macro, so that, when I
run the macro, filtering should  happen simultaneously in the both
workbooks Orders and Stock

TIA

Regards
Eugene

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


Orders.xls
Description: MS-Excel spreadsheet


Stocks.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Re: Fix the Shape

[Eugene Bernard]

Thank you, Vaibhav !!!

Regards
Eugene

On Sat, Nov 15, 2014 at 8:30 PM, Vaibhav Joshi v...@vabs.in wrote:

 Hey Eugene,


 Check this...

 Pres alt + tab twice to type data in sheet  will send form in
 background...

 When form is in background, press Ctr + Shft + U to close floating image...

 Cheers!!


 +
 *I did not do this for you. God is here working through me for you.*

 On Sat, Nov 15, 2014 at 7:05 PM, Vaibhav Joshi v...@vabs.in wrote:

 Hi

 You can add floating form with image!!

 Cheers!!

 +
 *I did not do this for you. God is here working through me for you.*

 On Sat, Nov 15, 2014 at 10:50 AM, Eugene Bernard 
 eugene.bern...@gmail.com wrote:

 Thanks, I am, temporarily doing by this mehod only.
 regards
 Eugene

 On Sat, Nov 15, 2014 at 9:49 AM, Mandeep Baluja rockerna...@gmail.com
 wrote:

 Try Freeze panes


 On Thursday, November 13, 2014 4:38:49 PM UTC+5:30, Eugene Bernard
 wrote:

 Hi all,

 FInd attached an excel sheet, where in i pasted a circular shape in
 that sheet.

 Whenever i scroll down the row, or move accross the column, I want
 keep the

 circle on the same position. ie i want to see the same always still i
 close the sheet.

 Regards
 Eugene

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

Re: $$Excel-Macros$$ Re: Fix the Shape

[Eugene Bernard]

Thanks, I am, temporarily doing by this mehod only.
regards
Eugene

On Sat, Nov 15, 2014 at 9:49 AM, Mandeep Baluja rockerna...@gmail.com
wrote:

 Try Freeze panes


 On Thursday, November 13, 2014 4:38:49 PM UTC+5:30, Eugene Bernard wrote:

 Hi all,

 FInd attached an excel sheet, where in i pasted a circular shape in that
 sheet.

 Whenever i scroll down the row, or move accross the column, I want keep
 the

 circle on the same position. ie i want to see the same always still i
 close the sheet.

 Regards
 Eugene

  --
 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$$ Fix the Shape

[Eugene Bernard]

Hi all,

FInd attached an excel sheet, where in i pasted a circular shape in that
sheet.

Whenever i scroll down the row, or move accross the column, I want keep the

circle on the same position. ie i want to see the same always still i close
the sheet.

Regards
Eugene

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


Shape.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Moving Completed rows to sheet2

[Eugene Bernard]

Thank you, Joshi.

Regards
Eugene

On Wed, Sep 24, 2014 at 10:48 AM, Vaibhav Joshi v...@vabs.in wrote:

 Try this...


 Cheers!!

 +
 *I did not do this for you. God is here working through me for you.*

 On Tue, Sep 23, 2014 at 11:54 PM, Vaibhav Joshi v...@vabs.in wrote:

 Yes..

 Remove line which clears existing data in sheet 2 from code..

 If you need help then do tell me.

 Cheers
 On Sep 23, 2014 9:42 PM, Eugene Bernard eugene.bern...@gmail.com
 wrote:

 Exactly. Thank you so much Joshi.

 Is it possible to add the rows in sheet2, without removing existing rows
 in sheet2.

 Regards
 Eugene

 On Tue, Sep 23, 2014 at 12:07 PM, Vaibhav Joshi v...@vabs.in wrote:

 Ok, chk this..

 Cheers!!

 +
 *I did not do this for you. God is here working through me for you.*

 On Mon, Sep 22, 2014 at 9:38 PM, Eugene Bernard 
 eugene.bern...@gmail.com wrote:

 Dear Joshi,

 Thanks for your reply.

 As already explained in my first post, rows having code with 11 is
 not to be treated as completed, since 3 rows having
 codes as 11 is with status tag blank. The logic for moving the
 rows from sheet1 to sheet2 is rows with status tag with C
 if it has unique code, or else if it has same code for 3 rows, then
 all 3 rows should have status with C

 Regards
 Eugene



 On Mon, Sep 22, 2014 at 5:30 PM, Vaibhav Joshi v...@vabs.in wrote:

 Hi

 FA,

 Click blue button to Run Macro..

 Cheers!!

 +
 *I did not do this for you. God is here working through me for you.*

 On Sun, Sep 21, 2014 at 8:55 PM, Eugene Bernard 
 eugene.bern...@gmail.com wrote:


 -- Forwarded message --
 From: Eugene Bernard eugene.bern...@gmail.com
 Date: Sun, Sep 21, 2014 at 8:54 PM
 Subject: $$Excel-Macros$$ Moving Completed rows to sheet2
 To: excel-macros@googlegroups.com


 Dear all,

 Please find attached a sample worksheet, where in i like to move
 the completed rows to sheet 2 from sheet 1.

 In the attached example, rows having code 12 is completed which
 needs to be moved to sheet2. where as 11 is not to be moved
 since 3 more rows with code 11 is having the status without status
 updated as C.

 Please help me with macro to do this activity.

 TIA
 Eugene

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

Re: $$Excel-Macros$$ Moving Completed rows to sheet2

[Eugene Bernard]

Exactly. Thank you so much Joshi.

Is it possible to add the rows in sheet2, without removing existing rows in
sheet2.

Regards
Eugene

On Tue, Sep 23, 2014 at 12:07 PM, Vaibhav Joshi v...@vabs.in wrote:

 Ok, chk this..

 Cheers!!

 +
 *I did not do this for you. God is here working through me for you.*

 On Mon, Sep 22, 2014 at 9:38 PM, Eugene Bernard eugene.bern...@gmail.com
 wrote:

 Dear Joshi,

 Thanks for your reply.

 As already explained in my first post, rows having code with 11 is
 not to be treated as completed, since 3 rows having
 codes as 11 is with status tag blank. The logic for moving the rows
 from sheet1 to sheet2 is rows with status tag with C
 if it has unique code, or else if it has same code for 3 rows, then all
 3 rows should have status with C

 Regards
 Eugene



 On Mon, Sep 22, 2014 at 5:30 PM, Vaibhav Joshi v...@vabs.in wrote:

 Hi

 FA,

 Click blue button to Run Macro..

 Cheers!!

 +
 *I did not do this for you. God is here working through me for you.*

 On Sun, Sep 21, 2014 at 8:55 PM, Eugene Bernard 
 eugene.bern...@gmail.com wrote:


 -- Forwarded message --
 From: Eugene Bernard eugene.bern...@gmail.com
 Date: Sun, Sep 21, 2014 at 8:54 PM
 Subject: $$Excel-Macros$$ Moving Completed rows to sheet2
 To: excel-macros@googlegroups.com


 Dear all,

 Please find attached a sample worksheet, where in i like to move the
 completed rows to sheet 2 from sheet 1.

 In the attached example, rows having code 12 is completed which
 needs to be moved to sheet2. where as 11 is not to be moved since
 3 more rows with code 11 is having the status without status updated as
 C.

 Please help me with macro to do this activity.

 TIA
 Eugene

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

Re: $$Excel-Macros$$ Moving Completed rows to sheet2

[Eugene Bernard]

Dear Joshi,

Thanks for your reply.

As already explained in my first post, rows having code with 11 is not
to be treated as completed, since 3 rows having
codes as 11 is with status tag blank. The logic for moving the rows
from sheet1 to sheet2 is rows with status tag with C
if it has unique code, or else if it has same code for 3 rows, then all 3
rows should have status with C

Regards
Eugene



On Mon, Sep 22, 2014 at 5:30 PM, Vaibhav Joshi v...@vabs.in wrote:

 Hi

 FA,

 Click blue button to Run Macro..

 Cheers!!

 +
 *I did not do this for you. God is here working through me for you.*

 On Sun, Sep 21, 2014 at 8:55 PM, Eugene Bernard eugene.bern...@gmail.com
 wrote:


 -- Forwarded message --
 From: Eugene Bernard eugene.bern...@gmail.com
 Date: Sun, Sep 21, 2014 at 8:54 PM
 Subject: $$Excel-Macros$$ Moving Completed rows to sheet2
 To: excel-macros@googlegroups.com


 Dear all,

 Please find attached a sample worksheet, where in i like to move the
 completed rows to sheet 2 from sheet 1.

 In the attached example, rows having code 12 is completed which
 needs to be moved to sheet2. where as 11 is not to be moved since 3
 more rows with code 11 is having the status without status updated as
 C.

 Please help me with macro to do this activity.

 TIA
 Eugene

 --
 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 this group at http://groups.google.com/group

Fwd: $$Excel-Macros$$ Moving Completed rows to sheet2

[Eugene Bernard]

Dear Joshi,

Thanks for your reply.

As already explained in my first post, rows having code with 11 is not
to be treated as completed, since 3 rows having
codes as 11 is with status tag blank. The logic for moving the rows
from sheet1 to sheet2 is rows with status tag with C
if it has unique code, or else if it has same code for 3 rows, then all 3
rows should have status with C

Regards
Eugene



On Mon, Sep 22, 2014 at 5:30 PM, Vaibhav Joshi v...@vabs.in wrote:

 Hi

 FA,

 Click blue button to Run Macro..

 Cheers!!

 +
 *I did not do this for you. God is here working through me for you.*

 On Sun, Sep 21, 2014 at 8:55 PM, Eugene Bernard eugene.bern...@gmail.com
 wrote:


 -- Forwarded message --
 From: Eugene Bernard eugene.bern...@gmail.com
 Date: Sun, Sep 21, 2014 at 8:54 PM
 Subject: $$Excel-Macros$$ Moving Completed rows to sheet2
 To: excel-macros@googlegroups.com


 Dear all,

 Please find attached a sample worksheet, where in i like to move the
 completed rows to sheet 2 from sheet 1.

 In the attached example, rows having code 12 is completed which
 needs to be moved to sheet2. where as 11 is not to be moved since 3
 more rows with code 11 is having the status without status updated as
 C.

 Please help me with macro to do this activity.

 TIA
 Eugene

 --
 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 this group at http://groups.google.com/group

$$Excel-Macros$$ Moving Completed rows to sheet2

[Eugene Bernard]

Dear all,

Please find attached a sample worksheet, where in i like to move the
completed rows to sheet 2 from sheet 1.

In the attached example, rows having code 12 is completed which needs
to be moved to sheet2. where as 11 is not to be moved since 3 more rows
with code 11 is having the status without status updated as C.

Please help me with macro to do this activity.

TIA
Eugene

-- 
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$$ Moving Completed rows to sheet2

[Eugene Bernard]

-- Forwarded message --
From: Eugene Bernard eugene.bern...@gmail.com
Date: Sun, Sep 21, 2014 at 8:54 PM
Subject: $$Excel-Macros$$ Moving Completed rows to sheet2
To: excel-macros@googlegroups.com


Dear all,

Please find attached a sample worksheet, where in i like to move the
completed rows to sheet 2 from sheet 1.

In the attached example, rows having code 12 is completed which needs
to be moved to sheet2. where as 11 is not to be moved since 3 more rows
with code 11 is having the status without status updated as C.

Please help me with macro to do this activity.

TIA
Eugene

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


Example.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Help required for changing the file name in a query programmatically

[Eugene Bernard]

Mr Basole,

Thanks for the attachements,

I am getting an error msg as in the attachment, even after adding Ms-ado
object library.

[image: Inline image 1]

TIA.

Eugene



On Fri, Aug 29, 2014 at 11:06 PM, Ricardo® ricardo...@gmail.com wrote:

 Ok, is attached files.
 To test, hold the 2 files in the same folder

 Regards,

 Basole.


 2014-08-29 11:58 GMT-03:00 Eugene Bernard eugene.bern...@gmail.com:

 Basole,

 Thanks for your solution.

 Can you please send me the working example along with excel file with
 sample data.

 I tried your code with my data, and i am getting an error message.

 Regards
 Eugene


 On Saturday, August 23, 2014 7:04:59 PM UTC+5:30, Basole wrote:

 Hi,

 See this example extracts the data from your file T2308.xls (T  date:
 and change the name according to the current(or system date)), using
 ADO and SQL statement.

 regards.


 Basole



 2014-08-23 8:55 GMT-03:00 Eugene Bernard eugene@gmail.com:

 Dear all,

 I am daily using the attached sample query file to extract data from an
 excel file stored in my windows desktop.

 I am pasting below a part of code from the test.dqy file, where I am
 daily changing the file name based on the date on which it is being run.

 Instead of changing it manually, is there any possibility to change it
 based on the system date.

 ie T2408 in place of T2308 if I run the query on 23/08/2014.

 SELECT `Sheet1$`.Date, `Sheet1$`.DptNo, `Sheet1$`.Empno, `Sheet1$`.Leave
 FROM `C:\Users\jeb501\Desktop\T2308.xls`.`Sheet1$` `Sheet1$`  WHERE
 (`Sheet1$`.DptNo='01')
  Note : I am using EXCEL 2007

 TIA

 Eugene

 --
 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/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 a topic in the
 Google Groups MS EXCEL

Re: $$Excel-Macros$$ Help required for changing the file name in a query programmatically

[Eugene Bernard]

Dear Basole,

Please ignore my earlier mail,

I removed the slash in between dd/mm from the below statement from your
example

fileXLS = T  Replace(Format(Date, dd/mm), /, )  .xls  like
below,

fileXLS = T  Replace(Format(Date, ddmm), /, )  .xls and example
sent by you

started working.

Thank you very much.

Eugene








On Fri, Aug 29, 2014 at 11:06 PM, Ricardo® ricardo...@gmail.com wrote:

 Ok, is attached files.
 To test, hold the 2 files in the same folder

 Regards,

 Basole.


 2014-08-29 11:58 GMT-03:00 Eugene Bernard eugene.bern...@gmail.com:

 Basole,

 Thanks for your solution.

 Can you please send me the working example along with excel file with
 sample data.

 I tried your code with my data, and i am getting an error message.

 Regards
 Eugene


 On Saturday, August 23, 2014 7:04:59 PM UTC+5:30, Basole wrote:

 Hi,

 See this example extracts the data from your file T2308.xls (T  date:
 and change the name according to the current(or system date)), using
 ADO and SQL statement.

 regards.


 Basole



 2014-08-23 8:55 GMT-03:00 Eugene Bernard eugene@gmail.com:

 Dear all,

 I am daily using the attached sample query file to extract data from an
 excel file stored in my windows desktop.

 I am pasting below a part of code from the test.dqy file, where I am
 daily changing the file name based on the date on which it is being run.

 Instead of changing it manually, is there any possibility to change it
 based on the system date.

 ie T2408 in place of T2308 if I run the query on 23/08/2014.

 SELECT `Sheet1$`.Date, `Sheet1$`.DptNo, `Sheet1$`.Empno, `Sheet1$`.Leave
 FROM `C:\Users\jeb501\Desktop\T2308.xls`.`Sheet1$` `Sheet1$`  WHERE
 (`Sheet1$`.DptNo='01')
  Note : I am using EXCEL 2007

 TIA

 Eugene

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

Re: $$Excel-Macros$$ Help required for changing the file name in a query programmatically

[Eugene Bernard]

Basole,

Thanks for your solution.

Can you please send me the working example along with excel file with 
sample data.

I tried your code with my data, and i am getting an error message.

Regards
Eugene

On Saturday, August 23, 2014 7:04:59 PM UTC+5:30, Basole wrote:

 Hi, 

 See this example extracts the data from your file T2308.xls (T  date: and 
 change the name according to the current(or system date)), using ADO and 
 SQL statement.

 regards.


 Basole



 2014-08-23 8:55 GMT-03:00 Eugene Bernard eugene@gmail.com 
 javascript::

 Dear all,
  
 I am daily using the attached sample query file to extract data from an 
 excel file stored in my windows desktop.
  
 I am pasting below a part of code from the test.dqy file, where I am 
 daily changing the file name based on the date on which it is being run.
  
 Instead of changing it manually, is there any possibility to change it 
 based on the system date.
  
 ie T2408 in place of T2308 if I run the query on 23/08/2014.
  
 SELECT `Sheet1$`.Date, `Sheet1$`.DptNo, `Sheet1$`.Empno, `Sheet1$`.Leave  
 FROM `C:\Users\jeb501\Desktop\T2308.xls`.`Sheet1$` `Sheet1$`  WHERE 
 (`Sheet1$`.DptNo='01')
 Note : I am using EXCEL 2007
  
 TIA
  
 Eugene

 -- 
 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.com 
 javascript:.
 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$$ Help required for changing the file name in a query programmatically

[Eugene Bernard]

Dear all,

I am daily using the attached sample query file to extract data from an
excel file stored in my windows desktop.

I am pasting below a part of code from the test.dqy file, where I am daily
changing the file name based on the date on which it is being run.

Instead of changing it manually, is there any possibility to change it
based on the system date.

ie T2408 in place of T2308 if I run the query on 23/08/2014.

SELECT `Sheet1$`.Date, `Sheet1$`.DptNo, `Sheet1$`.Empno, `Sheet1$`.Leave
FROM `C:\Users\jeb501\Desktop\T2308.xls`.`Sheet1$` `Sheet1$`  WHERE
(`Sheet1$`.DptNo='01')
Note : I am using EXCEL 2007

TIA

Eugene

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


Test.dqy
Description: Binary data

Re: $$Excel-Macros$$ Re: find duplicate rows of data between sheets macro

[Eugene Bernard]

Hi Paul,

The code given above works well for the sheets in same workbook.
send me the code for data in two different work books.

Regards
Eugene


On Fri, Apr 25, 2014 at 9:15 PM, Paul Schreiner schreiner_p...@att.netwrote:

 It works perfectly in my workbook.
 Row 6 is unhighlighted in sheet1
 and 6 and 13 are unhighlighted in sheet2.

 better check to make sure the macro was copied correctly,
 here it is from my workbook:

 Option Explicit
 Public Dict_Data1, Dict_Data2
 Sub Compare()
 Dim Sht1, Sht2
 Dim nRows, r, sData, rArray, inx
 Dim tstart, tstop, TElapsed, TMin, TSec, msg

 '-
 Application.ScreenUpdating = False
 '-
 tstart = Timer
 Set Dict_Data1 = CreateObject(Scripting.Dictionary)
 Set Dict_Data2 = CreateObject(Scripting.Dictionary)
 Dict_Data1.RemoveAll
 Dict_Data2.RemoveAll
 '-
 'Identify sheets to compare
 '-
 Sht1 = Sheet1
 Sht2 = Sheet2
 '-
 ' Clear Highlighting
 '-
 Sheets(Sht1).Select
 With Cells.Interior
 .Pattern = xlNone
 .TintAndShade = 0
 .PatternTintAndShade = 0
 End With
 Sheets(Sht2).Select
 With Cells.Interior
 .Pattern = xlNone
 .TintAndShade = 0
 .PatternTintAndShade = 0
 End With
 '-
 ' Load data from Sht1 into Dictionary Object
 '-
 nRows = Application.WorksheetFunction.CountA(Sheets(Sht1).Range(A1:A
  Sheets(Sht1).Rows.Count))
 For r = 2 To nRows
 If (r Mod 1000 = 0) Then Application.StatusBar = Loading   Sht1
   row   r   of   nRows
 sData = Trim(Sheets(Sht1).Cells(r, A).Value)
 sData = sData  |  Trim(Sheets(Sht1).Cells(r, B).Value)
 sData = sData  |  Trim(Sheets(Sht1).Cells(r, C).Value)
 sData = sData  |  Trim(Sheets(Sht1).Cells(r, D).Value)
 sData = sData  |  Trim(Sheets(Sht1).Cells(r, F).Value)
 sData = sData  |  Trim(Sheets(Sht1).Cells(r, H).Value)
 sData = sData  |  Trim(Sheets(Sht1).Cells(r, I).Value)
 If (Not Dict_Data1.exists(sData)) Then
 Dict_Data1.Add sData, r
 '--
 Else '  In case of duplicate rows, collect all row numbers
 '--
 Dict_Data1.Item(sData) = Dict_Data1.Item(sData)  ,  r
 End If
 Next
 '-
 ' Process Sht2 data, compare to sht1
 '-
 nRows = Application.WorksheetFunction.CountA(Sheets(Sht2).Range(A1:A
  Sheets(Sht2).Rows.Count))
 For r = 2 To nRows
 If (r Mod 1000 = 0) Then Application.StatusBar = Processing  
 Sht2   row   r   of   nRows
 sData = Trim(Sheets(Sht2).Cells(r, A).Value)
 sData = sData  |  Trim(Sheets(Sht2).Cells(r, B).Value)
 sData = sData  |  Trim(Sheets(Sht2).Cells(r, C).Value)
 sData = sData  |  Trim(Sheets(Sht2).Cells(r, D).Value)
 sData = sData  |  Trim(Sheets(Sht2).Cells(r, F).Value)
 sData = sData  |  Trim(Sheets(Sht2).Cells(r, H).Value)
 sData = sData  |  Trim(Sheets(Sht2).Cells(r, I).Value)
 If (Dict_Data1.exists(sData)) Then
 '---
 'highlight row in sht2
 '---
 Sheets(Sht2).Select
 With Sheets(Sht2).Range(Cells(r, A), Cells(r, I)).Interior
 .Pattern = xlSolid
 .PatternColorIndex = xlAutomatic
 .Color = 65535
 .TintAndShade = 0
 .PatternTintAndShade = 0
 End With
 '---
 'highlight rows in sht1
 '---
 Sheets(Sht1).Select
 rArray = Split(Dict_Data1.Item(sData), ,)
 For inx = 0 To UBound(rArray)
 With Sheets(Sht1).Range(Cells(rArray(inx), A),
 Cells(rArray(inx), I)).Interior
 .Pattern = xlSolid
 .PatternColorIndex = xlAutomatic
 .Color = 65535
 .TintAndShade = 0
 .PatternTintAndShade = 0
 End With
 Next inx
 End If
 Next
 Application.StatusBar = False
 Application.ScreenUpdating = True
 '
 msg = 

Re: $$Excel-Macros$$ Need help to find the missing emp id on particular date

[Eugene Bernard]

Thankyou again, Mr Paul, for the detailed explanation.

Regards
Eugene


On Tue, Apr 15, 2014 at 5:10 PM, Paul Schreiner schreiner_p...@att.netwrote:

 I use it for a wide variety of purposes.

 Sometimes I use it like a pseudo-index.
 Say I have a large number of records (I routinely have lists of 90,000
 rows)
 and I'm attempting to report on a series of entries.
 looping through these rows multiple times is very time consuming.
 I used to load the records into an array and search the array (which is
 much faster, but still time consuming).
 If I load the dictionary with a keyword, the value can be an array of
 row numbers.
 Let's say the records are transaction records in which the invoice number
 appears several times.
 (when it is created, each update and when closed)
 I loop through the records, and the first time an invoice is found, add it
 (and the row) to the dictionary:
 if it already has been loaded, append the Row Number:

 If (not dict_inv.exists(invNo)) then
   dict_inv.add invNo, RowNo
 else
   dict_inv.item(invNo) = dict_inv.item(InvNo)  |  RowNo
 end if

 once I've loaded the data into my dictionary, then I need to find the rows
 for the specific invoice, they are found quickly.

 --
 Another application:
 I have machine data (names, location, etc) (16,000 records)
 and manufacturing part numbers (22,000) in an Oracle database.

 during some reporting functions, the database is queried multiple times
 for information from these tables.
 Some reports may include loops that may result in 10-20,000 queries to
 these tables.
 This doesn't necessarily pose a problem with hard network connections,
 but wireless connections sometimes are very slow.
 If I load these tables into a Dictionary once, then the repeated queries
 do not depend on the network connection to the database.

 --
 For the most part, just about any case in which I may have used an array,
 I prefer to use a Dictionary Object.

 unless, duplicates are allowed.

 hope this helps.



 *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:* Eugene Bernard eugene.bern...@gmail.com
 *To:* excel-macros@googlegroups.com
 *Sent:* Monday, April 14, 2014 12:39 PM

 *Subject:* Re: $$Excel-Macros$$ Need help to find the missing emp id on
 particular date

 Thank you paul, for exposing us to the scripting.dictionary object.
 Can you please share, some more details  and uses of the dictionary Object.

 Regards
 Eugene


 On Tue, Apr 8, 2014 at 7:33 PM, Paul Schreiner schreiner_p...@att.netwrote:

 I did it two different ways.
 You IMPLIED that you wanted a macro (hence, the button)
 So, I used a technique in which I loaded a Dictionary object with all
 empid's for the date specified, then looked through the list of all empid's
 and checked for those that did not exist in the Dictionary object.

 Next,
 I simply used a Countifs() function and had it check for the empid and
 date and place a X in the column adjacent to the missing id's.
 Using a Filter, you can display the missing id's.

 If you wanted, you could create a change event to monitor the date cell.
 When the date is changed, the countifs update, and the filter is
 re-applied.

 *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:* Ganesh N ganeshg...@gmail.com
 *To:* excel-macros@googlegroups.com excel-macros@googlegroups.com
 *Sent:* Tuesday, April 8, 2014 9:14 AM
 *Subject:* Re: $$Excel-Macros$$ Need help to find the missing emp id on
 particular date

 Hi Team,

 Any updates on the request ??

 Thanks  Regards,
 Ganesh


 On Tue, Apr 8, 2014 at 1:15 PM, Ganesh N ganeshg...@gmail.com wrote:

 Hi Team,

 Need a help in find the missed emp id list.

 Sheet1 have the actual employee ids and date. In sheet2 have overall
 employee ids in that i need to find the employee missed on particular date.
 Please find the attachment for your reference.

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

 FORUM RULES

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

Re: $$Excel-Macros$$ Need help to find the missing emp id on particular date

[Eugene Bernard]

Thank you paul, for exposing us to the scripting.dictionary object.
Can you please share, some more details  and uses of the dictionary Object.

Regards
Eugene


On Tue, Apr 8, 2014 at 7:33 PM, Paul Schreiner schreiner_p...@att.netwrote:

 I did it two different ways.
 You IMPLIED that you wanted a macro (hence, the button)
 So, I used a technique in which I loaded a Dictionary object with all
 empid's for the date specified, then looked through the list of all empid's
 and checked for those that did not exist in the Dictionary object.

 Next,
 I simply used a Countifs() function and had it check for the empid and
 date and place a X in the column adjacent to the missing id's.
 Using a Filter, you can display the missing id's.

 If you wanted, you could create a change event to monitor the date cell.
 When the date is changed, the countifs update, and the filter is
 re-applied.

 *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:* Ganesh N ganeshg...@gmail.com
 *To:* excel-macros@googlegroups.com excel-macros@googlegroups.com
 *Sent:* Tuesday, April 8, 2014 9:14 AM
 *Subject:* Re: $$Excel-Macros$$ Need help to find the missing emp id on
 particular date

 Hi Team,

 Any updates on the request ??

 Thanks  Regards,
 Ganesh


 On Tue, Apr 8, 2014 at 1:15 PM, Ganesh N ganeshg...@gmail.com wrote:

 Hi Team,

 Need a help in find the missed emp id list.

 Sheet1 have the actual employee ids and date. In sheet2 have overall
 employee ids in that i need to find the employee missed on particular date.
 Please find the attachment for your reference.

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

 FORUM RULES

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

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

$$Excel-Macros$$ Save an Excel file as XML

[Eugene Bernard]

How to save an excel table data in XML format.

TIA.
Eugene

-- 
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$$ '1004' Run Time Error when VBA Cell comment list is over 266 lines

[Eugene Bernard]

Please verify the data on 266th row, with the data above 266 rows.

Regards
Eugene


On Thu, Nov 7, 2013 at 1:59 AM, Denisetoo denise...@gmail.com wrote:

 I get a run time 1004 when the comment lines are at 266 lines.  WIth
 less than 200 comment lines the code runs fine.  The DropDownTmp variable
 list includes all 266 lines.  The comment field cuts off around 253 lines
 of code.  The program stops with the run time error.

 Any ideas on how to fix this?

 SearchRowTemp = SearchRow
 ErrorDesc = Sheets(SNLogNew).Cells(LogRowCounter, 1).Value 
 Sheets(SNLogNew).Cells(LogRowCounter, 2).Value
 Do Until ErrorDesc = 

 If Left(ErrorDesc, 3) = Or Sheets(SNLogNew).Cells(LogRowCounter,
 1).Value =  Then
 ' Add a comment
 If Not Found Then
 If NewComment Then
 Sheets(SNTD).Cells(TDRowCounter - 1,
 Tdf_Col_Error).AddComment Text:=Trim(ErrorDesc)
 Sheets(SNTD).Cells(TDRowCounter - 1,
 Tdf_Col_Error).Comment.Shape.TextFrame.AutoSize = True
 NewComment = False
 Else
 Sheets(SNTD).Cells(TDRowCounter - 1,
 Tdf_Col_Error).Comment.Text Text:=Sheets(SNTD).Cells(TDRowCounter - 1,
 Tdf_Col_Error).Comment.Text  Chr(10)  Trim(ErrorDesc)
 End If
' Determine the number of specs in the drop down list
 i_number_comments = Len(Sheets(SNTD).Cells(TDRowCounter -
 1, Tdf_Col_Error).Comment.Text) -
 Len(Replace(Sheets(SNTD).Cells(TDRowCounter _
 - 1, Tdf_Col_Error).Comment.Text, Chr(10), ))
 Debug.Print i_number_comments
 ' If this is the last entry of a comment... add the data
 validation
 If Left(ErrorDesc, 3) = And _
 (Sheets(SNLogNew).Cells(LogRowCounter + 1, 1).Value = 
 Or Left(Sheets(SNLogNew).Cells(LogRowCounter + 1, 1).Value, 3) )
 And _
 CMD_Tmp.DetailDropDown And TDRowCounter  TDRow And
 i_number_comments  250 Then


DropDownTmp = Sheets(SNTD).Cells(TDRowCounter - 1,
 Tdf_Col_Error).Comment.Text
 ' Add Drop Down Selection for Detail Cell
 With Sheets(SNTD).Cells(TDRowCounter - 1,
 Tdf_Col_Detail).Validation
 .Delete
 .Add Type:=xlValidateList,
 AlertStyle:=xlValidAlertStop, Operator:= _
 xlBetween, Formula1:=DropDownTmp
 .IgnoreBlank = True
 .InCellDropdown = True
 .InputTitle = 
 .ErrorTitle = 
 .InputMessage = 
 .ErrorMessage = 
 .IMEMode = xlIMEModeNoControl
 .ShowInput = True
 .ShowError = True
 End With

 End If

 End If

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

Re: $$Excel-Macros$$ Autofill while typing in a cell

[Eugene Bernard]

Dear Anil,

I get an error Can't find the project or library , at the second line
Dim Myconnection As Connection,
during opening of the Autodropdown.xlsm file.

Regards
Eugene




On Fri, Sep 27, 2013 at 3:13 PM, अनिल नारायण गवली
gawlianil8...@gmail.comwrote:

  Dear Pavan,

 See the attached sheet.  I have take a combobox help

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


 On Fri, Sep 27, 2013 at 2:16 PM, Pavan Valluru
 pavansai.vall...@gmail.com wrote:
  Hey VBA Buddies,
 
  Hope al iz well.
 
  Here is my query. In excel , is it possible to add auto fill while
 typing a
  particular text.
 
  I have some data somewhere in excel and i am trying to add autofill
 function
  if i am typing a cell, i just want to see suggestions those words starts
  with the text i entered.
 
  like :
 
  If i type Total, i want to get suggestions of words which starts with
  total.
 
  Thanks in ad.
 
  -Pavan
 
  --
  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.

$$Excel-Macros$$ Filter to work in tandem

[Eugene Bernard]

I have two excel workbooks in open condition. If  I filter a value of one
particular
column in first workbook, i need the same filter condition should get
applied to
the other open worksheet also. How to achieve this. Please share me the
macro or codes.

Thanks
Eugene

-- 
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$$ Re: Formula require

[Eugene Bernard]

Thanks Mr Vijay,

Using -- operator, I am able to convert Numeric Characters to Numeric
value. (Example : entered =--a1 in cell A2 to convert the
character contents from cell a1).

Similerly, is there any similler operator is available to convert it back
to character except single / double Quote.

Regards
Eugene


On Thu, Jun 6, 2013 at 12:34 PM, P.VIJAYKUMAR vijay.4...@gmail.com wrote:

 Respected Eugene Bernard,

 The double negative is used to coerce, as we say, a non-number type into
 a
 number type. Since only a number (not text, boolean, error value, etc.)
 can
 follow a minus sign, one minus sign forces the coercion to a number. The
  other just reverses the sign change caused by the first one.

 For complete explanation together with examples please see the following
 link : *http://www.mcgimpsey.com/excel/formulae/doubleneg.html*

 Regards,
 VIJAYKUMAR


 On Tue, Jun 4, 2013 at 7:43 PM, Eugene Bernard 
 eugene.bern...@gmail.comwrote:

 Hi Prince,

 What is the use of -- in the formula mentioned by you.

 The result is OK, but I do not find this of syntax in Excel Help.

 Please elaborate.

 Regards
 Eugene


 On Tue, Jun 4, 2013 at 5:16 PM, Prince prince141...@gmail.com wrote:

 may be it can help you.

 =SUMPRODUCT(--(I9:I17=Black),--(H9:H17=Cars),(J9:J17))

 Regards
 Prince

 On Tuesday, June 4, 2013 4:49:56 PM UTC+5:30, Prabhakar S H wrote:

 Hi Team,

 i want to get formula to find Total value of cars with black color
 only. pls help.

 Rgds,
 Prabhakar

  --
 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?hl=en.
 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?hl=en.
 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

$$Excel-Macros$$ Preserving OLD values

[Eugene Bernard]

I have a requirement like this

If I enter some new value in cell A2, the previous value should get copied
or backed up in cell b2. like wise for next 2000 rows.

Any help greatly appreciated.
Eugene

-- 
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$$ Re: Formula require

[Eugene Bernard]

Thanks Mr Vijaykumar.

Regards
Eugene


On Thu, Jun 6, 2013 at 12:34 PM, P.VIJAYKUMAR vijay.4...@gmail.com wrote:

 Respected Eugene Bernard,

 The double negative is used to coerce, as we say, a non-number type into
 a
 number type. Since only a number (not text, boolean, error value, etc.)
 can
 follow a minus sign, one minus sign forces the coercion to a number. The
  other just reverses the sign change caused by the first one.

 For complete explanation together with examples please see the following
 link : *http://www.mcgimpsey.com/excel/formulae/doubleneg.html*

 Regards,
 VIJAYKUMAR


 On Tue, Jun 4, 2013 at 7:43 PM, Eugene Bernard 
 eugene.bern...@gmail.comwrote:

 Hi Prince,

 What is the use of -- in the formula mentioned by you.

 The result is OK, but I do not find this of syntax in Excel Help.

 Please elaborate.

 Regards
 Eugene


 On Tue, Jun 4, 2013 at 5:16 PM, Prince prince141...@gmail.com wrote:

 may be it can help you.

 =SUMPRODUCT(--(I9:I17=Black),--(H9:H17=Cars),(J9:J17))

 Regards
 Prince

 On Tuesday, June 4, 2013 4:49:56 PM UTC+5:30, Prabhakar S H wrote:

 Hi Team,

 i want to get formula to find Total value of cars with black color
 only. pls help.

 Rgds,
 Prabhakar

  --
 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?hl=en.
 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?hl=en.
 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?hl=en.
 For more options, visit https

Re: $$Excel-Macros$$ Re: Formula require

[Eugene Bernard]

Hi Prince,

What is the use of -- in the formula mentioned by you.

The result is OK, but I do not find this of syntax in Excel Help.

Please elaborate.

Regards
Eugene


On Tue, Jun 4, 2013 at 5:16 PM, Prince prince141...@gmail.com wrote:

 may be it can help you.

 =SUMPRODUCT(--(I9:I17=Black),--(H9:H17=Cars),(J9:J17))

 Regards
 Prince

 On Tuesday, June 4, 2013 4:49:56 PM UTC+5:30, Prabhakar S H wrote:

 Hi Team,

 i want to get formula to find Total value of cars with black color only.
 pls help.

 Rgds,
 Prabhakar

  --
 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?hl=en.
 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?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Data Validation and Automation

[Eugene Bernard]

Anybody tried this !!!

Regards
Eugene


On Sat, May 18, 2013 at 8:38 PM, Eugene Bernard eugene.bern...@gmail.comwrote:

 Dear all,

 Please go through the sheet attached, where there are 4 columns.

 Column 1 is ID which is used to differentiate the component or item.

 Column 2 is Stage, which is used to designate where the component / item
 is being processed (ie) stage 1 or 2.

 Column 3 is completion quantity of component against the stage mentioned.

 And Column 4 needs to be filled automatically, when ever new data is added
 as row detail.(validation at the entry stage of column 3 of any new row
 addition)

 For example, please refer to row 8, when I enter A001 in ID, and 2 as
 stage and Qty as 20, the macro/function should check the previous entries
 in the 7 rows, with respect to ID and Stage and update

 CL_stock in row 2 and row 8. That 20 nos of item A001 is passed from Stage
 1 to Stage 2. The function / macro also should not allow the user to enter
 more than the qty 20 in Column C of row 8 and also

 Stage entry for any item should not get duplicated.

 In the above case item A001 is processed in toto. Where as for ID B001 the
 item is processed partially.

 How to achieve this using Macro/Functions.

 Regards

 Eugene



  --
 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?hl=en.
 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?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Macros Tips

[Eugene Bernard]

Very UsefulThanks to both of you.

Regards
Eugene


On Fri, May 17, 2013 at 8:36 PM, Abhishek Jain abhishek@gmail.comwrote:

 The link was shared with me by Priti. She is an active learner and finds
 such stuff.

 Priti - please share more links like this, if you have.

 Regards,

 Abhishek


 On Fri, May 17, 2013 at 7:26 PM, Prabhu Pinky prabhupin...@gmail.comwrote:

 Hi Abhishek,

 the link http://www.excel-pratique.com/en/index.php; you given is
 really useful.


 Please suggest more link like this...


 Regards,
 Prabhu R




 On 17 May 2013 17:43, Chaya chayamon...@gmail.com wrote:

 Dear Abhishek,

 Your tips are brilliant, thanks for sharing those clues. it will be
 a great inspiring, rhythm of elevation towards preparing self thorough in
 aspect of macros. The cited *link* above is a great aspiration for a
 macros beginners.

thanks for sharing and bringing back the life of learning macros !
thanks to all



 Regards,
 Chaya

 The excel learner  :-)


 On Fri, May 17, 2013 at 5:20 PM, Abhishek Jain 
 abhishek@gmail.comwrote:

 Firstly, take a breath. Keep calm. Just because you're reading e-books,
 googling for 2 months and you don't know how to use 'Dim'...doesn't mean
 you should be ashamed. Humans are strange. They went to moon before
 figuring out that it would be handy to install little wheels in luggage. My
 point is - there is no exact sequence of learning. You only know when you
 know.

 Getting back to your thing. The major problem with learning VBA by
 oneself is that - we don't know what to learn and from where to start. We
 know there are codes, there are lines that appear in Greek but perform
 magic. VBA is also a language but thankfully not as hard as Greek. So
 before you set out, open VB editor and wander around, first thing first,
 have a task. Start with simple tasks, preferably, the ones you have done
 already. Do it again, manually, a couple of times, then record, and then,
 off you go.

 With this idea in mind, here are a few tips which I collected from net
 and added some of my own:

 1. Use the recorder -

 Excel’s built in Macro recorder is a great way to learn about new
 objects and ways to deal with them. I use it all the time to record parts
 of my code and then customize the output. Just keep in mind that macro
 recorder does not produce the best or complete code all the time. But it
 gives you a damn good idea about how to write code for a set of actions.
 Although the code produced by the recorder might not make sense to you all
 the time but it surely gives an idea of what you just done. A more
 effective way to get the most out the macro recorder would be - record
 something you know or do well. For example - I know how to copy data from
 a sheet and paste it to another sheet. I do it all the time. If I record
 that activity, I will get a code that will copy certain data from a sheet
 and paste it on another sheet. Now, if I were you, I would play around with
 it, you know, change the cell references, change the sheet names, change
 the range which is being copied or the destination. Further, I will record
 few other activities like sorting the range and then copy that code in my
 earlier code and try to make it one code which will copy, paste and sort.
 That's how it works. Also, when recording a macro, do it a few times for
 the same thing until you get whatever is being done accomplished in the
 fewest steps. This will leave the least amount of goofy stuff you don't
 need. And finally, to finish with macro recorder, I'll advise this: Record
 in parts. If you have a long task that involves many things at once like,
 copying, pasting, sorting, coloring, renaming, etc...record a separate
 macro for each task. The code these individual macros would return, might
 be of one or two lines only, but these lines will tell you exactly how
 things work in that white little magicland.

 2. Think it through -

 The best way to solve even a very complex problem is to think through.
 Next time, when you are about to automate that report or clean some
 imported data using VBA, just write the logic down on a paper. See and
 understand various aspects of the problem. The solution becomes clear to
 you and when the solution is clear to you, further course towards achieving
 it becomes easy in mind.

 3. Use Immediate Window

 Excel VBE has a powerful feature called as Immediate window. Think of
 this like a sandbox. You can write almost any VBA statements here and get
 quick results. For example, Open VBE (ALT+F11 in Excel) and go to Immediate
 window.

 -Type ?Activecell.Value
 -Press Enter
 -And you will see the current cell’s value printed in immediate window.

 4. Read the help topics.

 5. For each command/argument/function, there is a set method in which
 they work. Try to find that correct method.

 6. Never hesitate to ask when you're not getting something. As long
 as a question is thoughtfully laid out, there are great guys here who will
 go far 

Re: $$Excel-Macros$$ Creating Dynamic Hyperlink between Summary and Detail sheet

[Eugene Bernard]

Hi Ravindar

Thank you.

Regards
Eugene


On Tue, May 7, 2013 at 12:46 PM, ravinder negi ravi_colw...@yahoo.comwrote:

 Hi, PFA solved.

 --- On *Mon, 5/6/13, Eugene Bernard eugene.bern...@gmail.com* wrote:


 From: Eugene Bernard eugene.bern...@gmail.com
 Subject: $$Excel-Macros$$ Creating Dynamic Hyperlink between Summary and
 Detail sheet
 To: excel-macros@googlegroups.com
 Date: Monday, May 6, 2013, 9:01 PM


 Hi all,

 I have a requirement to create a hyper link between two sheets (Summary
 and detail) in the attached sheet.

 I need to create a hyperlink in summary sheet, for all the value cells
 from B2:E5.

 From the created 16 hyperlinks from summary sheet, if for example , I
 click on cell B2, the detail sheet should open

 with filtered values of qty0 and Month May13 and Week having a value of
 W1.

 Support greatly appreciated.

 Regards
 Eugene

  --
 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?hl=en.
 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?hl=en.
 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?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ Creating Dynamic Hyperlink between Summary and Detail sheet

[Eugene Bernard]

Hi all,

I have a requirement to create a hyper link between two sheets (Summary and
detail) in the attached sheet.

I need to create a hyperlink in summary sheet, for all the value cells from
B2:E5.

From the created 16 hyperlinks from summary sheet, if for example , I click
on cell B2, the detail sheet should open

with filtered values of qty0 and Month May13 and Week having a value of
W1.

Support greatly appreciated.

Regards
Eugene

-- 
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?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.




Summary_to_Detail_Link.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Creating Dynamic Hyperlink between Summary and Detail sheet

[Eugene Bernard]

Thanks Ashish for your lightening response !!!.

This meets exactly, what I expected !!!.

Thanks.

Eugene


On Mon, May 6, 2013 at 9:57 PM, ashish koul koul.ash...@gmail.com wrote:

 try this see if it helps

 Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
 Boolean)

 Dim wk As Worksheet
 Set wk = Sheets(Detail)
 Application.EnableEvents = False
 On Error GoTo Err:


 If Target.Count = 1 And Not Intersect(Target, Range(b2:e5)) Is
 Nothing Then
 If wk.FilterMode Then
 wk.ShowAllData
 End If
 With wk.Range(a1).CurrentRegion
 .AutoFilter Field:=1, Criteria1:=Cells(Target.Row, 1).Text
 .CurrentRegion.AutoFilter Field:=2, Criteria1:=Cells(1,
 Target.Column).Text
 .CurrentRegion.AutoFilter Field:=3, Criteria1:=0
 wk.Select
 End With
 End If

 Application.EnableEvents = True
 Exit Sub

 Err:
 Application.EnableEvents = True
 End Sub





 On Mon, May 6, 2013 at 9:01 PM, Eugene Bernard 
 eugene.bern...@gmail.comwrote:

 Hi all,

 I have a requirement to create a hyper link between two sheets (Summary
 and detail) in the attached sheet.

 I need to create a hyperlink in summary sheet, for all the value cells
 from B2:E5.

 From the created 16 hyperlinks from summary sheet, if for example , I
 click on cell B2, the detail sheet should open

 with filtered values of qty0 and Month May13 and Week having a value
 of W1.

 Support greatly appreciated.

 Regards
 Eugene

  --
 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?hl=en.
 For more options, visit https://groups.google.com/groups/opt_out.






 --
 *Regards*
 * *
 *Ashish Koul*


 *Visit*
 *My Excel Blog http://www.excelvbamacros.com/*
 Like Us on 
 Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897
 Join Us on Facebook http://www.facebook.com/groups/163491717053198/


 P Before printing, think about the environment.



 --
 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?hl=en.
 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

$$Excel-Macros$$ Active Filters

[Eugene Bernard]

Hi all,

How to find list of active filters in place in Excel.

Regards
Eugene

-- 
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?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Two-to-multi column sorting

[Eugene Bernard]

Mr Koul,

Tested the macro, the result is not exactly matching requirement requested
by Chris.

Regards
Eugene


On Sat, Jan 26, 2013 at 9:50 PM, ashish koul koul.ash...@gmail.com wrote:

 Try this

 Sub sample()
 Dim i As Long, j As Long

 Range(a1:b  Range(a65356).End(xlDown).Row).Sort key1:=Range(a:a),
 order1:=xlAscending, Header:=xln0

 For i = 1 To Range(a65356).End(xlUp).Row
 j = Application.WorksheetFunction.CountIf(Range(a:a), Range(a 
 i).Value)
 Range(a1).End(xlToRight).Offset(0, 1).Value = Range(a  i).Value
 Range(b  i  :b  i + j - 1).Copy
 Destination:=Range(a1).End(xlToRight).Offset(1, 0)
 i = i + j - 1
 Next

 End Sub




 On Fri, Jan 25, 2013 at 12:56 AM, Chris christoph...@gmail.com wrote:

 Hey there -

 a very simple problem that I'm trying to solve without any code if at all
 possible. It's so simple that I don't even need to post a workbook:

 Imagine you have two columns worth of data whereas the 2nd column is 100%
 unique but items in column 1 will appear multiple times such as in this
 list:

 Column1   Column2
 Arkansas  Alpha
 Arkansas  Beta
 Arkansas  Gamma
 Florida   Echo
 Florida   Foxtrott
 Florida   Pi
 Georgia   Ben
 Georgia   Kyle

 The task is to take the data above (copy  paste or whatever function
 Excel 2010 offers) to resort the list by Column1 items vertically such as:

 Arkansas Florida Georgia
 AlphaEchoBen
 Beta FoxtrottKyle
 GammaPi

 Pasting using traspose obviously doesn't work here. I was thinking pivots
 maybe? Is there anything in Excel that does this kinda of sorting/changing
 quickly?

 Thanks,
 Chris

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

 FORUM RULES

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

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






 --
 *Regards*
 * *
 *Ashish Koul*


 *Visit*
 *My Excel Blog http://www.excelvbamacros.com/*
 Like Us on 
 Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897
 Join Us on Facebook http://www.facebook.com/groups/163491717053198/


 P Before printing, think about the environment.



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

Re: $$Excel-Macros$$ Two-to-multi column sorting

[Eugene Bernard]

Yes Please. It is working perfectly.

Regards
Eugene


On Sat, Jan 26, 2013 at 11:04 PM, ashish koul koul.ash...@gmail.com wrote:

 Hi

 Its working at my place .  Please find the working file attached


 Regards
 Ashish Koul



 On Sat, Jan 26, 2013 at 10:58 PM, Eugene Bernard eugene.bern...@gmail.com
  wrote:

 Mr Koul,

 Tested the macro, the result is not exactly matching requirement
 requested by Chris.

 Regards
 Eugene


 On Sat, Jan 26, 2013 at 9:50 PM, ashish koul koul.ash...@gmail.comwrote:

 Try this

 Sub sample()
 Dim i As Long, j As Long

 Range(a1:b  Range(a65356).End(xlDown).Row).Sort key1:=Range(a:a),
 order1:=xlAscending, Header:=xln0

 For i = 1 To Range(a65356).End(xlUp).Row
 j = Application.WorksheetFunction.CountIf(Range(a:a), Range(a 
 i).Value)
 Range(a1).End(xlToRight).Offset(0, 1).Value = Range(a  i).Value
 Range(b  i  :b  i + j - 1).Copy
 Destination:=Range(a1).End(xlToRight).Offset(1, 0)
 i = i + j - 1
 Next

 End Sub




 On Fri, Jan 25, 2013 at 12:56 AM, Chris christoph...@gmail.com wrote:

 Hey there -

 a very simple problem that I'm trying to solve without any code if at
 all possible. It's so simple that I don't even need to post a workbook:

 Imagine you have two columns worth of data whereas the 2nd column is
 100% unique but items in column 1 will appear multiple times such as in
 this list:

 Column1   Column2
 Arkansas  Alpha
 Arkansas  Beta
 Arkansas  Gamma
 Florida   Echo
 Florida   Foxtrott
 Florida   Pi
 Georgia   Ben
 Georgia   Kyle

 The task is to take the data above (copy  paste or whatever function
 Excel 2010 offers) to resort the list by Column1 items vertically such as:

 Arkansas Florida Georgia
 AlphaEchoBen
 Beta FoxtrottKyle
 GammaPi

 Pasting using traspose obviously doesn't work here. I was thinking
 pivots maybe? Is there anything in Excel that does this kinda of
 sorting/changing quickly?

 Thanks,
 Chris

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

 FORUM RULES

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

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






 --
 *Regards*
 * *
 *Ashish Koul*


 *Visit*
 *My Excel Blog http://www.excelvbamacros.com/*
 Like Us on 
 Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897
 Join Us on Facebook http://www.facebook.com/groups/163491717053198/


 P Before printing, think about the environment.



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

$$Excel-Macros$$ Allocation problem between Requirement and Stock.

[Eugene Bernard]

Dear all,

Please find attached an excel workbook, having 2 sheets. In this REQT
sheet, I need to fill in the column C with the quantities available from
Stock sheet, based on Item.

The allocation is based on Item, Requirement and Stock.

The Requirement is filled in column B of REQT sheet.
The manual allocation is filled in Column C. How to allocate it using
Formula

The allocation can be done easily in the case of unique item. By using
minimum function.
If item repeats like A001 how to allocate. Please help.

Regards
Eugene

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




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

Re: $$Excel-Macros$$ Re: Card List view

[Eugene Bernard]

Use grid control, to meet your requirement.

Regards
Eugene


On Fri, Jan 11, 2013 at 4:35 PM, Prince prince141...@gmail.com wrote:

 Hi Chaya,


 Can you please shere ur workbook. One more thing where is the source of ur
 data.

 regards
 prince

 On Friday, January 11, 2013 4:03:27 PM UTC+5:30, chaya moni wrote:

 Dear Exceller,

   While goggling, i find some interesting fact in user form, Actually
 I use to update card in the excel as like the same attachment. So I have
 many more card list. so I have made a userform1, which I like to find the
 list view at a single click. Can we make the data inside the userform1. as
 i have already describe details inside the body of the excel inside.

  For creating this userform1 , i have spent 2 weeks and at last i
 have prepared but all effort lost, because i don't have any idea how to go
 further. Searching for help in internet for this, i find finally this
 forum. hope that somebody excel teachers will help this.

 regards,
 Chaya



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

 FORUM RULES

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

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




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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Heplp Required

[Eugene Bernard]

Hi Neeraj,

Try these rwo statements.

=TODAY()+RANDBETWEEN(1,31)

=TIME(RANDBETWEEN(1,12),RANDBETWEEN(0,60),RANDBETWEEN(0,60))

Regards
Eugene


On Sat, Dec 1, 2012 at 10:48 AM, neeraj chauhan
neerajchauhan...@gmail.comwrote:

 Dear Experts,

 i want randomly time and date like


  10:43 AM  10:50 AM  10:05 AM  11:10 AM  1:07 PM
  20-Nov-12  19-Nov-12  2-Nov-12  11-Nov-12  6-Nov-12  24-Nov-12  18-Nov-12
 27-Nov-12  4-Nov-12  1-Nov-12

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

 FORUM RULES

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

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




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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Required Unique data with funtion

[Eugene Bernard]

Dear Kuldeep,

Is it possible to get the data in sorted order.

Regards
Eugene


On Tue, Oct 30, 2012 at 12:05 PM, Kuldeep Singh naukrikuld...@gmail.comwrote:


 Dear Priyanka,

 See attached file.

 Regards,
 Kuldeep Singh
 Back Office Executive (MIS)
 Info Edge India Limited (naukri.com)


 On Tue, Oct 30, 2012 at 11:47 AM, Priyanka Vaish 
 vaishpriyanka2...@gmail.com wrote:

 Hi Experts,


 Please solve this Query.



 Regards,
 Priyanka

 --
 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.
 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 (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.
 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 (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.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ Required Unique data with funtion

[Eugene Bernard]

How to achieve this thro' functions without manually sorting.

Regards
Eugene


On Fri, Nov 9, 2012 at 11:56 AM, Kuldeep Singh naukrikuld...@gmail.comwrote:


 Sure Priyanka,

 First Sort data then use formula. It's working fine.

 Regards,
 Kuldeep Singh


 On Fri, Nov 9, 2012 at 11:52 AM, Eugene Bernard 
 eugene.bern...@gmail.comwrote:

 Dear Kuldeep,

 Is it possible to get the data in sorted order.

 Regards
 Eugene


 On Tue, Oct 30, 2012 at 12:05 PM, Kuldeep Singh 
 naukrikuld...@gmail.comwrote:


 Dear Priyanka,

 See attached file.

 Regards,
 Kuldeep Singh
 Back Office Executive (MIS)
 Info Edge India Limited (naukri.com)


 On Tue, Oct 30, 2012 at 11:47 AM, Priyanka Vaish 
 vaishpriyanka2...@gmail.com wrote:

 Hi Experts,


 Please solve this Query.



 Regards,
 Priyanka

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

Re: $$Excel-Macros$$ MsgBox Query

[Eugene Bernard]

Try this

MsgBox (Sheets(1).Range(a1))

Regards
Eugene

On Tue, Oct 23, 2012 at 10:40 AM, SAJID MEMON sajidwi...@hotmail.comwrote:




 Dears,
 Find enclosed above attachemnt
 I WANT THE VALUE OR ANY TEXT IN A1 CELL SHOULD APPEAR IN THE MESSAGE BOX

 Awiting...

 Sajid Memon

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