date:20121223

Re: $$Excel-Macros$$ Unsubscribe my email id

2012-12-23 Thread Anoop K Sharma

Email to following group

excel-macros+unsubscr...@googlegroups.com.


On Mon, Dec 24, 2012 at 1:13 PM, jaspreet singh wrote:

> excel-macros+unsubscr...@googlegroups.com.




-- 
Regards,
Anoop
Sr. Developer

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

FORUM RULES

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

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

$$Excel-Macros$$ Unsubscribe my email id

2012-12-23 Thread jaspreet singh

Hi,
 
Please, unsubsribe my email id from the group.
 
Thanks
Jaspreet Singh

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

FORUM RULES

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

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

$$Excel-Macros$$ Re: Macro to create attendance Sheet for each Employee

2012-12-23 Thread prkhan56

Hello Lalit
Thanks for the reply.
Please see the sample sheet which I have attached with my first post.  
 
The names of the employees are in excel sheet and the time in / time out 
details are shown against each employee name
 
I want to run the macro to run on Master sheet and create time sheet each 
employee showing their Time In/ Time Out
 
Is this clear?
Thanks 
Regards
Rashid Khan
 
On Monday, December 24, 2012 8:41:35 AM UTC+4, Lalit Mohan Pandey wrote:

> Hi Rashid,
>
> Could you please explain when you want to run this process to capture 
> InTime and OutTime of an Employee and how we know who are the employees. Is 
> there any list of employee?
>
> Regards,
> Lalit Mohan
>
> On Wednesday, 19 December 2012 16:17:43 UTC+5:30, prkhan56 wrote: 
>>
>>  Hello All
>>
>> I am using excel 2007
>>
>> I have data in the Master Sheet for various Employees  
>>
>> I want to create separate sheet for each employee viz A, B, C and so on
>> (see sample 
>> sheet attached)
>>
>> I got the macro from the Group which create separate sheet for each name  
>> (it 
>> is in the attached shet) 
>>
>> 
>>
>> I wish to amend the macro so that it gives the output as shown in sample 
>> sheets A, B and C 
>>
>> My requirements are 
>>
>> 1  It should check the date/ time of each Employee and then 
>> put the values  (shown in Red Color) against each date Time-In / 
>> Time-Out on individual  sheets
>>
>> 2  The macro should take the first entry and the last entry 
>> for each day for each Name
>>
>> 3  It should do this till the last employee is reached
>>
>> 4  There are some unauthorized entry in Col D with no Names 
>> in Col A.  These entries should be ignored
>>
>> 5  The macro should put formulas in Col G and H (highlighted 
>> in Green Color)
>>
>> 6  Everything in Red Color Font would be done the by the 
>> macro…viz the Month, Name, Date, Time In and Time Out
>>
>> 
>>
>> Thanks in advance
>> Rashid Khan
>>
>

-- 
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$$ Mail merge and E mail : Reminder email to customers using VBA

2012-12-23 Thread Anoop K Sharma

Hello Stranger,

I can see your query and would like to get it done but before doing this I
am curious to know something related to your query.
Are you having invoices info and customer info in different workbooks?
If yes then In attached Sample list of Invoicing, I can see only few
inputs. Are these information available only one sheet or more than one
sheet. I put the same question on the other attached workbook (customer
Master).

or it would be good idea if these information is put on same workbook.

Regards,
Anoop
Sr. Developer


On Wed, Dec 19, 2012 at 4:45 PM, ..  wrote:

> Dear List members
>
> Request : *Mail merge and E mail* using VBA or other tools
> =
>
>- I have to send reminder / dunning letters to my customers.
>- Unfortunately the faxing option from the company is very time
>consuming (print, sort, fax, wait for dial tones...failure etc etc) and it
>takes a long time.
>- Also there isn't a corporate e mail reminder solution in sight.
>- To avoid delays and very heavy workload, I plan to e mail the
>reminder / dunning letters. *I have to take this personally *
>- I think this should be possible to partially automate this task
>using XL (data) and combining that with word or VBA and send mail thru MS
>outlook.
>- I suspect some one may have tried this before
>- I seek your help for innovative solutions...either VBA or any other
>innovative solution as well .
>- All input data would be available as XL files. Samples shown below
>and XL files also added to this mail
>- If this has not been tried earlier or if this is too cumbersome,
>please drop this, ...my advance apologies .
>- Any pointers to other websites are also gratefully acknowledged
>
>
>
> THANKS in advance !!!
>
> Subu
>
>
> My customer master looks like this  *[xl file enclosed]*
> 
>
> Customer#Customer_Name...Address..E_mail...
>
> 12345The fancy paint shopPO Box 322,
> madras...fancy_pa...@hotmail.com
> 12346Bright Colours.PO Box 123,
> cochinbright_col...@gmail.com
> 12347Best Decor Bangalore..PO Box 456,
> bangalorebest_d...@bestbangl.co.in
> and ...so on .
>
>
>
> My list of overdue invoices looks like this *[xl file enclosed] *
> ===
> Customer
> #Invoice#...InvoiceDate.DueDateAmount_Due(Rs)
>
> 12345.AX4562.01/10/2012.30/11/2012..11289.60
>
> 12345.AX4653.02/10/2012.30/11/2012..45678.45
>
> 12345.AX4653.02/11/2012.31/12/2012..11235.78
>
> 12346.AX8657.04/10/2012.30/11/2012...4567.60
>
> 12346.AX7658.07/10/2012.30/11/2012...3456.45
>
> 12346.AX9248.08/11/2012.31/12/2012...2589.78
>
> 12347.AX4258.06/10/2012.30/11/2012.111269.60
>
> 12347.AX4796.12/10/2012.30/11/2012..33789.45
>
> 12347.AX6987.10/11/2012.31/12/2012560.78
> ...and so on 
>
>
>
> I wish to send a reminder / dunning letters by e mail as follows
> ==
>
>
> === start of 1st reminder email to fancy_pa...@hotmail.com ==
>
> To
> M/s Fancy Paint Shop =>
> PO Box 322   =>
> Madras   =>  all above from the master !
>
> Date : 19 Dec 2012 (basically run date)
>
> Dear Sir, Madam
>
> You account is overdue by Rs. 56,968.05. Please effect payment immediately
> to avoid delays in supply. A list of invoices due on your account is given
> below
>
> Customer
> #Invoice#...InvoiceDate.DueDateAmount_Due(Rs)
>
> 12345.AX4562.01/10/2012.30/11/2012..11289.60
>
> 12345.AX4653.02/10/2012.30/11/2012..45678.45
>
> Should you need anything more please contact Subu at ..@yahoo.com or
> at +98354xyzab for further information
>
> Thanking you
> Yours Sincerely
>
> Subu
> === end of 1st dunning email ===
>
> As you would have noticed the next reminder / dunning letter would be of
> the same format but different in the due amount and list of invoices
>
>
>
> = Start of 2nd reminder / dunning email to 
> bright_col...@gmail.com===
>
>
> To
> M/s Bright Colours   =>
> PO Box 123   =>
> Cochin   =>  all above from the master !
>
> Date : 19 Dec 2012 (basically run date)
>
> Dear Sir, Madam
>
> You account is overdue by Rs. 8024.05. Please effect payment immediately
> to avoid delays in supply

Re: $$Excel-Macros$$ Re: How to import web page Table in Excel

2012-12-23 Thread Satendra kumar

Hi Lalit,

how to get data scrolling from password protected site, "like i want my
email inbox".

thankx
satendra

On Sat, Dec 22, 2012 at 2:42 PM, Lalit Mohan Pandey <
mohan.pande...@gmail.com> wrote:

> Hi Dhaval,
>
> ** **
>
> PFA.
>
> Hope it is what you are looking for.
>
> ** **
>
> ** **
>
> *Regards,*
>
> *Lalit Mohan*
>
> *+919711867226  [IM Only]*
>
> On Saturday, 22 December 2012 13:01:26 UTC+5:30, Dhaval Shah wrote:
>>
>> Dear can u mail me sample file me try to put code but its can't work
>> acTually I m not much accrate
>>
>> Thanks
>>
>> Dhaval shah
>> Sent on my BlackBerry® from Vodafone
>> --
>> *From: * Lalit Mohan Pandey 
>> *Sender: * excel-...@googlegroups.com
>> *Date: *Fri, 21 Dec 2012 01:54:12 -0800 (PST)
>> *To: *
>> *ReplyTo: * excel-...@googlegroups.com
>> *Subject: *$$Excel-Macros$$ Re: How to import web page Table in Excel
>>
>> Hi Dhaval,
>>
>> Hope it might helps you,
>>
>> Put below code in a module and add refrence of "Microsoft Internet
>> Controls"
>>
>> Option Explicit
>>
>> Declare Function apiShowWindow Lib "user32" Alias "ShowWindow" _
>> (ByVal hwnd As Long, ByVal nCmdShow As Long) As Long
>>
>> Sub Test()
>>
>> Call CopyWebPage
>>
>> End Sub
>>
>> Private Sub CopyWebPage(Optional IEVisible As Boolean = False)
>>
>> Dim IE  As InternetExplorer
>> Dim wksSheetAs Worksheet
>> Dim dtTime  As Date
>>
>> Application.DisplayAlerts = False
>> Application.EnableEvents = False
>>
>> If Application.ScreenUpdating Then Application.ScreenUpdating = False
>>
>> Set wksSheet = ThisWorkbook.Worksheets("**sheet1")
>> wksSheet.DrawingObjects.Delete
>> wksSheet.Cells.Clear
>>
>> Set IE = New InternetExplorer
>> With IE
>> apiShowWindow .hwnd, 3
>> .Visible = IEVisible
>> .Navigate "http://www.nseindia.com/live_**
>> market/dynaContent/live_watch/**equities_stock_watch.htm?cat=N
>> **"
>> 'Wait for initial page to load
>> Do While .readyState <> READYSTATE_COMPLETE Or .Busy: DoEvents:
>> Loop
>>
>> 'Copying website
>> dtTime = Now()
>> Begin:
>> If Now() <= DateAdd("s", 3, dtTime) Then
>> GoTo Begin
>> End If
>> .ExecWB OLECMDID_SELECTALL, OLECMDEXECOPT_DODEFAULT
>> .ExecWB OLECMDID_COPY, OLECMDEXECOPT_DODEFAULT
>> .ExecWB OLECMDID_CLEARSELECTION, OLECMDEXECOPT_DODEFAULT
>> .Quit
>> End With
>> With wksSheet
>> Application.Goto .Range("A1")
>> .Paste
>> Application.CutCopyMode = False
>> .Cells(301, 1).Resize(100).EntireRow.**Delete
>> .Cells(1, 1).Resize(247).EntireRow.**Delete
>> DeleteShapes ("$1:$2")
>> DeleteShapes ("$54:$54"), False
>> .Range("A1").CurrentRegion.**Font.Size = 8
>> Application.Goto .Range("A1")
>> End With
>> Set IE = Nothing
>>
>> End Sub
>>
>> Private Sub DeleteShapes(ByVal strRange As String, Optional
>> blnDelOtherShp As Boolean = True)
>>
>> Dim Sh As Shape
>> With Worksheets("Sheet1")
>> For Each Sh In .Shapes
>> If Not Application.Intersect(Sh.**TopLeftCell,
>> .Range(strRange)) Is Nothing Then
>> Sh.Delete
>> End If
>> Next Sh
>> For Each Sh In .Shapes
>> If Not Sh.Name Like "Picture*" Then
>> Sh.Delete
>> End If
>> Next Sh
>> End With
>>
>> End Sub
>>
>> and call "Test" procedure whereever you need to refresh may be in button
>> click or some where else.
>>
>> change sheet name and range aaccordingly.
>>
>> Regards,
>> Lalit Mohan
>>
>> On Friday, 21 December 2012 13:59:59 UTC+5:30, Dhaval Shah wrote:
>>>
>>> Hello Friends
>>>
>>> i want  to import below mention link table to excel Sheet with auto
>>> refresh
>>>
>>>
>>> http://www.nseindia.com/live_**market/dynaContent/live_watch/**
>>> equities_stock_watch.htm?cat=N
>>>
>>>
>>> actually nseindia update there web site recently .   earlier i m easily
>>> import ( with auto refresh ) the table
>>>
>>> also atteach my previous file for u r reference
>>>
>>> Thanks
>>>
>>> Dhaval Shah
>>>
>>>
>>>  --
>> 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

Re: $$Excel-Macros$$ HIGH LOW QUERY

2012-12-23 Thread Dhaval Shah

Suppos i m change the data in Sintex manual then formula works

On Mon, Dec 24, 2012 at 10:41 AM, Dhaval Shah wrote:

> Hello Prince ,
>
> Wish u merry Christmas
>
> i m facing some problem to find out High Low value Date in u r  Formula
> pls see the attech file there is two Category not show me HIGH Data is it
> anything wrong with formula ??? pls chk
>
>
> thanks
>
> Dhaval Shah
>
> On Thu, Dec 13, 2012 at 10:08 PM, Prince  wrote:
>
>> Hi Dhaval'
>>
>> PFA
>>
>> Regards
>> Prince
>>
>>
>> On Thursday, December 13, 2012 6:29:32 PM UTC+5:30, Dhaval Shah wrote:
>>
>>> Need Data Range upto 99000 in this sheet data Range upto only 2000
>>>
>>> me try to change Data Range but its dosent work
>>>
>>> Pls do need full
>>>
>>> Thanks
>>>
>>> Dhaval  Shah
>>>
>>> 98240 35253
>>>
>>>
>>> On Wed, Dec 12, 2012 at 10:43 PM, Prince  wrote:
>>>
 Hi Dhaval ,

 Pls find Attached.
 Regards
 Prince

 On Wednesday, December 12, 2012 6:26:26 PM UTC+5:30, Dhaval Shah wrote:
>
> from 158 row formula not working
>
> On Wed, Dec 12, 2012 at 6:25 PM, Dhaval Shah wrote:
>
>> Already change data range but not working
>>
>> On Wed, Dec 12, 2012 at 6:24 PM, Satendra kumar > > wrote:
>>
>>> Hi,
>>>
>>> change data range than apply i hope this is working...
>>>
>>> thankx
>>> satendra
>>>
>>>
>>> On Wed, Dec 12, 2012 at 6:19 PM, Dhaval Shah wrote:
>>>
 FRIENDS

 WHENEVER I M PUTTING NEW DATEA ABOVE 808 UPTO 5000 RAW FORMULA NOT
 WORKING

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

 FORUM RULES

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

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



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

 FORUM RULES

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

$$Excel-Macros$$ Concept of INDEX, Match, Direct, Indirect

2012-12-23 Thread Amit Desai (MERU)

Dear Friends,

I would like to learn the concept of INDEX, MATCH, DIRECT,INDIRECT functions.

Please provide me some write-ups with examples.

Thanks in Advance.

Best Regards,
Amit



Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail communications are timely, 
secure or free from computer virus or other defect.

-- 
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$$ lookup values with 2 conditions

2012-12-23 Thread Amit Desai (MERU)

Could you please explain the formula used?

Best Regards,
Amit

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of >>Excel Beginner<<
Sent: 22 December 2012 18:45
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ lookup values with 2 conditions

Hi Amit,

 Please find the attachment.

--
Regards,

Excel Beginner
On Sat, Dec 22, 2012 at 4:56 PM, Amit Gandhi 
mailto:silkyro...@gmail.com>> wrote:
Hi Experts

I am attaching an excel file, where I have applied LOOKUP/INDIRECT function in 
sheet "backup". But its very slow in working/opening. And when data is large, 
it takes too much time for processing.

Is there any better & fast way to get the same output?

Please help me here.

Regards

Amit

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

Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail communications are timely, 
secure or free from computer virus or other defect.

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

Re: $$Excel-Macros$$ lookup values with 2 conditions

2012-12-23 Thread Amit Gandhi

Thanks dear

Its really fast.

Regards

Amit


On Sat, Dec 22, 2012 at 6:45 PM, >>Excel Beginner<<  wrote:

> Hi Amit,
>
>  Please find the attachment.
>
>
>
>
> --
> *Regards,*
> *
> *
> *Excel Beginner*
> On Sat, Dec 22, 2012 at 4:56 PM, Amit Gandhi  wrote:
>
>> Hi Experts
>>
>> I am attaching an excel file, where I have applied LOOKUP/INDIRECT
>> function in sheet "backup". But its very slow in working/opening. And
>> when data is large, it takes too much time for processing.
>>
>> Is there any better & fast way to get the same output?
>>
>> Please help me here.
>>
>> Regards
>>
>> Amit
>>
>>  --
>> 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.
>
>
>



-- 
'Expecting the world to treat u fairly coz u r a good person is like
expecting the lion not to attack u coz u r a vegetarian.
Think about it.'

Take care

Amit

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

FORUM RULES

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

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

$$Excel-Macros$$ Re: Reason for delay in Filter

2012-12-23 Thread Lalit Mohan Pandey

Hi Prashant,

Before applying filters please use below code:

*Application.Calculation = xlCalculationManual*

and when you done with the filter then change it back to its original value

*Application.Calculation = xlCalculationAutomatic*

Instead of using Selection in your code please use a range like this:

*Worksheets("Sheet1").range("A1:D10")..AutoFilter Field:=1, Criteria1:="a"*

Regards,
Lalit Mohan

On Saturday, 22 December 2012 21:51:03 UTC+5:30, prashant shinde wrote:
>
> Hi Friends,
>
> Can somebody please tel me what are the reasons for delay in Autofilter 
> code. 
> We have a macro file where in one of the function we have used 
> Selection.AutoFilter Field:=1, Criteria1:="a"
>
> This code is executed thousand times and it takes almost 1.75 seconds to 
> execute above line once. so the whole process takes lots of time.
>
> Can somebody please tell me how why is it happening.
>
>

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

FORUM RULES

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

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

$$Excel-Macros$$ Re: Need to convert the fax copy in Excel sheet.

2012-12-23 Thread Lalit Mohan Pandey

Hi Ganesh,

You would need some OCR software to convert image to text.
you can read this link i am sure its help you
http://www.freewaregenius.com/2011/1...ree-ocr-tools/

Regards,
Lalit Mohan



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

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

FORUM RULES

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

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

$$Excel-Macros$$ Re: Macro to create attendance Sheet for each Employee

2012-12-23 Thread Lalit Mohan Pandey

Hi Rashid,

Could you please explain when you want to run this process to capture 
InTime and OutTime of an Employee and how we know who are the employees. Is 
there any list of employee?

Regards,
Lalit Mohan

On Wednesday, 19 December 2012 16:17:43 UTC+5:30, prkhan56 wrote:
>
> Hello All
>
> I am using excel 2007
>
> I have data in the Master Sheet for various Employees  
>
> I want to create separate sheet for each employee viz A, B, C and so on
> (see sample 
> sheet attached)
>
> I got the macro from the Group which create separate sheet for each name  (it 
> is in the attached shet) 
>
> 
>
> I wish to amend the macro so that it gives the output as shown in sample 
> sheets A, B and C 
>
> My requirements are 
>
> 1  It should check the date/ time of each Employee and then 
> put the values  (shown in Red Color) against each date Time-In / Time-Out 
> on individual  sheets
>
> 2  The macro should take the first entry and the last entry 
> for each day for each Name
>
> 3  It should do this till the last employee is reached
>
> 4  There are some unauthorized entry in Col D with no Names 
> in Col A.  These entries should be ignored
>
> 5  The macro should put formulas in Col G and H (highlighted 
> in Green Color)
>
> 6  Everything in Red Color Font would be done the by the 
> macro…viz the Month, Name, Date, Time In and Time Out
>
> 
>
> Thanks in advance
> Rashid Khan
>

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

FORUM RULES

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

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

$$Excel-Macros$$ Re: Macro to create attendance Sheet for each Employee

2012-12-23 Thread prkhan56

Hello all experts
Any help on my problem please
 
Rashid
On Saturday, December 22, 2012 12:15:33 AM UTC+4, prkhan56 wrote:

> Hello Prince
> I posted the reply yesterday but I cannot see it posted.  So posting again.
>  
> *Where is the out time of the employees.* 
> Please see this sample data of employee A for 1st Nov only.  Data for the 
> same employee is also there in my previous sample sheet in Col B against 
> his name.
>  
> Name A11/1/2012 8:13 *IN TIME*
>
> Name A11/1/2012 8:13
>
> Name A11/1/2012 19:52
>
> Name A11/1/2012 19:52
>
> Name A11/1/2012 19:52
>
> Name A11/1/2012 19:52 *OUT TIME*
>  
>  
> *and if there are 100 emplyees then do you want 100 sheets in the workbook
> *
> Yes. Newly created sheet would be as per the number of employees
>  
> Thanks for your time.
> Regards
> Rashid Khan
>  
>  
>  
>
> On Wednesday, December 19, 2012 2:47:43 PM UTC+4, prkhan56 wrote:
>
>>  Hello All
>>
>> I am using excel 2007
>>
>> I have data in the Master Sheet for various Employees  
>>
>> I want to create separate sheet for each employee viz A, B, C and so on
>> (see sample 
>> sheet attached)
>>
>> I got the macro from the Group which create separate sheet for each name  
>> (it 
>> is in the attached shet) 
>>
>> 
>>
>> I wish to amend the macro so that it gives the output as shown in sample 
>> sheets A, B and C 
>>
>> My requirements are 
>>
>> 1  It should check the date/ time of each Employee and then 
>> put the values  (shown in Red Color) against each date Time-In / 
>> Time-Out on individual  sheets
>>
>> 2  The macro should take the first entry and the last entry 
>> for each day for each Name
>>
>> 3  It should do this till the last employee is reached
>>
>> 4  There are some unauthorized entry in Col D with no Names 
>> in Col A.  These entries should be ignored
>>
>> 5  The macro should put formulas in Col G and H (highlighted 
>> in Green Color)
>>
>> 6  Everything in Red Color Font would be done the by the 
>> macro…viz the Month, Name, Date, Time In and Time Out
>>
>> 
>>
>> Thanks in advance
>> Rashid Khan
>>
>

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Re: Need to convert the fax copy in Excel sheet.

2012-12-23 Thread Prince

Hi Ganesh,

What i think is that any scanned copy is always saved as Image file in the 
system. So do you want save this image file in excel so that data can be 
presented in excel.?

Regards
Prince

On Sunday, December 23, 2012 2:26:06 PM UTC+5:30, GANESH wrote:
>
> Hi,
>
> Thanks for your reply 
>
> I don not know the source of Scan copy, 
> but if I want to convert any scan copy what would be the code.
>
> Thanks and regards
>
>
> On Sun, Dec 23, 2012 at 12:19 PM, Prince 
> > wrote:
>
>> Hi Ganesh,
>>
>> Plz tell us the source of Fax Data.
>>
>> Regards
>> Prince
>>
>> On Sunday, December 23, 2012 11:16:42 AM UTC+5:30, GANESH wrote:
>>>
>>> Hi,
>>>  
>>> Can some please send me the Code for convert the Fax copy to Excel sheet.
>>>  
>>> Thanks and Regards 
>>> Ganesh Acha
>>>  
>>>  
>>> -- 
>>> Join official Facebook page of this forum @ https://www.facebook.com/**
>>> discussexcel 
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security 
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and 
>>> members are not responsible for any loss.
>>> --- 
>>> You received this message because you are subscribed to the Google 
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To post to this group, send email to excel-...@googlegroups.com.
>>> To unsubscribe from this group, send email to excel-macros...@**
>>> googlegroups.com.
>>> Visit this group at 
>>> http://groups.google.com/**group/excel-macros?hl=en
>>> .
>>>
>>  -- 
>> Join official Facebook page of this forum @ 
>> https://www.facebook.com/discussexcel
>>  
>> FORUM RULES
>>  
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security 
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>  
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and 
>> members are not responsible for any loss.
>> --- 
>> You received this message because you are subscribed to the Google Groups 
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-...@googlegroups.com
>> .
>> To unsubscribe from this group, send email to 
>> excel-macros...@googlegroups.com .
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>  
>>  
>>
>
>

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Re: Reason for delay in Filter

2012-12-23 Thread Prince

Hi Prashant,

I understand the restriction of the work place.So provide me Below 
mentioned details.
1: How much data you have in sheet.
2:Is there any other formula or macro runs before you filter the data.
3:Can we have some sample data workbook ie any dummy workbook that has same 
volume of data.

Regards
Prince


On Sunday, December 23, 2012 4:16:59 PM UTC+5:30, prashant shinde wrote:
>
> Hi guys,
>
> sorry but i cant share the workbook as its company workbook so i dont have 
> it.
>
> are there general reasons which may cause the delay?
> like if there are lots of Vlookup and countif formulas on the sheet.
>
>
>   --
> *From:* Prince >
> *To:* excel-...@googlegroups.com  
> *Cc:* hanumant shinde > 
> *Sent:* Sunday, 23 December 2012 11:42 AM
> *Subject:* $$Excel-Macros$$ Re: Reason for delay in Filter
>  
> Hi Prashant,
>
> Please share your workbook so that we diagnose the problem and can provide 
> whatever best we can do.
>
> Regards
> Prince
>
> On Saturday, December 22, 2012 9:51:03 PM UTC+5:30, prashant shinde wrote:
>
> Hi Friends,
>
> Can somebody please tel me what are the reasons for delay in Autofilter 
> code. 
> We have a macro file where in one of the function we have used 
> Selection.AutoFilter Field:=1, Criteria1:="a"
>
> This code is executed thousand times and it takes almost 1.75 seconds to 
> execute above line once. so the whole process takes lots of time.
>
> Can somebody please tell me how why is it happening.
>
> -- 
> Join official Facebook page of this forum @ 
> https://www.facebook.com/discussexcel
>  
> FORUM RULES
>  
> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security 
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>  
> NOTE : Don't ever post confidential data in a workbook. Forum owners and 
> members are not responsible for any loss.
> --- 
> You received this message because you are subscribed to the Google Groups 
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-...@googlegroups.com
> .
> To unsubscribe from this group, send email to 
> excel-macros...@googlegroups.com .
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>  
>  
>
>
>   

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Re: Reason for delay in Filter

2012-12-23 Thread David Grugeon

Yes.  ThEre are general reasons.  One is using select rather than ranges,
another is not setting calculate to manual before running a complex macro,
and the third is not switching of screenUpdating while the macro is running.

On Sunday, 23 December 2012, hanumant shinde wrote:

> Hi guys,
>
> sorry but i cant share the workbook as its company workbook so i dont have
> it.
>
> are there general reasons which may cause the delay?
> like if there are lots of Vlookup and countif formulas on the sheet.
>
>
>   --
> *From:* Prince  'prince141...@gmail.com');>>
> *To:* excel-macros@googlegroups.com  'excel-macros@googlegroups.com');>
> *Cc:* hanumant shinde  'arsfan2...@yahoo.co.in');>>
> *Sent:* Sunday, 23 December 2012 11:42 AM
> *Subject:* $$Excel-Macros$$ Re: Reason for delay in Filter
>
> Hi Prashant,
>
> Please share your workbook so that we diagnose the problem and can provide
> whatever best we can do.
>
> Regards
> Prince
>
> On Saturday, December 22, 2012 9:51:03 PM UTC+5:30, prashant shinde wrote:
>
> Hi Friends,
>
> Can somebody please tel me what are the reasons for delay in Autofilter
> code.
> We have a macro file where in one of the function we have used
> Selection.AutoFilter Field:=1, Criteria1:="a"
>
> This code is executed thousand times and it takes almost 1.75 seconds to
> execute above line once. so the whole process takes lots of time.
>
> Can somebody please tell me how why is it happening.
>
> --
> 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 'excel-macros@googlegroups.com');>
> .
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com  'excel-macros%2bunsubscr...@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 'excel-macros@googlegroups.com');>
> .
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com  'excel-macros%2bunsubscr...@googlegroups.com');>.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>


-- 
Regards
David Grugeon

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Re: Reason for delay in Filter

2012-12-23 Thread hanumant shinde

Hi guys,

sorry but i cant share the workbook as its company workbook so i dont have it.

are there general reasons which may cause the delay?
like if there are lots of Vlookup and countif formulas on the sheet.





>
> From: Prince 
>To: excel-macros@googlegroups.com 
>Cc: hanumant shinde  
>Sent: Sunday, 23 December 2012 11:42 AM
>Subject: $$Excel-Macros$$ Re: Reason for delay in Filter
> 
>
>Hi Prashant,
>
>
>Please share your workbook so that we diagnose the problem and can provide 
>whatever best we can do.
>
>
>Regards
>Prince
>
>On Saturday, December 22, 2012 9:51:03 PM UTC+5:30, prashant shinde wrote:
>Hi Friends,
>>
>>Can somebody please tel me what are the reasons for delay in Autofilter code. 
>>We have a macro file where in one of the function we have used 
>>Selection.AutoFilter Field:=1, Criteria1:="a"
>>
>>This code is executed thousand times and it takes almost 1.75 seconds to 
>>execute above line once. so the whole process takes lots of time.
>>
>>
>>Can somebody please tell me how why is it happening.
>>
>>
-- 
>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$$ VBA MACRO HELP NEEDED

2012-12-23 Thread Sumit Rathi


hi sir,

can u please mail me the book for vba macro in my mail id i.e 
rathisumitra...@gmail.com

thank you

regards 
sumit rathi

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Re: Need to convert the fax copy in Excel sheet.

2012-12-23 Thread ganesh acharya

Hi,

Thanks for your reply

I don not know the source of Scan copy,
but if I want to convert any scan copy what would be the code.

Thanks and regards


On Sun, Dec 23, 2012 at 12:19 PM, Prince  wrote:

> Hi Ganesh,
>
> Plz tell us the source of Fax Data.
>
> Regards
> Prince
>
> On Sunday, December 23, 2012 11:16:42 AM UTC+5:30, GANESH wrote:
>>
>> Hi,
>>
>> Can some please send me the Code for convert the Fax copy to Excel sheet.
>>
>> Thanks and Regards
>> Ganesh Acha
>>
>>
>> --
>> Join official Facebook page of this forum @ https://www.facebook.com/**
>> discussexcel 
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-...@googlegroups.com.
>> To unsubscribe from this group, send email to excel-macros...@**
>> googlegroups.com.
>> Visit this group at 
>> http://groups.google.com/**group/excel-macros?hl=en
>> .
>>
>  --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Unsubscribe my email id

$$Excel-Macros$$ Unsubscribe my email id

$$Excel-Macros$$ Re: Macro to create attendance Sheet for each Employee

Re: $$Excel-Macros$$ Mail merge and E mail : Reminder email to customers using VBA

Re: $$Excel-Macros$$ Re: How to import web page Table in Excel

Re: $$Excel-Macros$$ HIGH LOW QUERY

$$Excel-Macros$$ Concept of INDEX, Match, Direct, Indirect

RE: $$Excel-Macros$$ lookup values with 2 conditions

Re: $$Excel-Macros$$ lookup values with 2 conditions

$$Excel-Macros$$ Re: Reason for delay in Filter

$$Excel-Macros$$ Re: Need to convert the fax copy in Excel sheet.

$$Excel-Macros$$ Re: Macro to create attendance Sheet for each Employee

$$Excel-Macros$$ Re: Macro to create attendance Sheet for each Employee

Re: $$Excel-Macros$$ Re: Need to convert the fax copy in Excel sheet.

Re: $$Excel-Macros$$ Re: Reason for delay in Filter

Re: $$Excel-Macros$$ Re: Reason for delay in Filter

Re: $$Excel-Macros$$ Re: Reason for delay in Filter

Re: $$Excel-Macros$$ VBA MACRO HELP NEEDED

Re: $$Excel-Macros$$ Re: Need to convert the fax copy in Excel sheet.

19 matches

Site Navigation

Mail list logo

Footer information