Re: $$Excel-Macros$$ SUBTOTAL REMOVE

2012-02-06 Thread Maries
Hi,
**
*Try this code:*
**
Sub Macro1()
Cells.Select
Selection.RemoveSubtotal
End Sub

Regards,

MARIES.

On Mon, Feb 6, 2012 at 11:37 AM, chandra sekaran wrote:

> HI ALL
>
> I have write  small macro , i want revmove  subtotal  if  Active sheet
> subtotal method  is there
>
>
>
> Sub Macro1()
>
> If ActiveSheet.SubtotalMethod = True Then
> Selection.RemoveSubtotal
> End If
>
> End Sub
>
> can any one  correct this code
>
> Regards
> chandru
> chennai
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ 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. 

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

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


RE: $$Excel-Macros$$ vlookup in Text Box

2012-02-06 Thread Asa Rossoff
Hi charlie,

Got it.

Ok, the error is just indicating that the vlookup failed to find the Part#.
It failed for at least two reasons: (1) The VLookup is in the Change event,
which fires after every change, such as after each keypress - -so the whole
part# was probably not entered yet, and (2) The value of textboxes is text
(a string in vba terminology), but the Part#s in your database are numbers.

 

You can resolve issue #1 by handling/ignoring errors, but leaving the code
in the Change event, if you want Vlookups to execute repeatedly while
someone types, i.e.:

Private Sub TextBox8_Change()

On Error Resume Next

TextBox5.Value = WorksheetFunction.VLookup(TextBox8.Value, Range("DBase"),
2, False)

End Sub

 

You can resolve issue #2 by use of the Val() function to convert the text to
a number:

Private Sub TextBox8_Change()

On Error Resume Next

TextBox5.Value = WorksheetFunction.VLookup(Val(TextBox8.Value),
Range("DBase"), 2, False)

End Sub

 

You could, if desired, make the description field go blank rather than
retaining it's previous value if there was an error in the vlookup:

Private Sub TextBox8_Change()

On Error Resume Next

TextBox5.Value = WorksheetFunction.VLookup(Val(TextBox8.Value),
Range("DBase"), 2, False)

If Err.Number <> 0 Then TextBox5.Value = ""

End Sub

 

Back to issue #1:  If you want to only do your Vlookups when the user has
completely finished entering the part#, you should use a different event
instead.  There are several events that might be appropriate, but probably
BeforeUpdate would be a good call barring a specific reason to use another
event:

Private Sub TextBox8_BeforeUpdate(ByVal Cancel As MSForms.ReturnBoolean)

On Error Resume Next

TextBox5.Value = WorksheetFunction.VLookup(Val(TextBox8.Value),
Range("DBase"), 2, False)

If Err.Number <> 0 Then TextBox5.Value = "" ' Optional

End Sub

 

Asa

 

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Cab Boose
Sent: Sunday, February 05, 2012 10:48 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ vlookup in Text Box

 

Hi Asa

 

Found the files see attached.

 

Charlie in New Zealand



 

On Mon, Feb 6, 2012 at 7:14 PM, Asa Rossoff  wrote:

Charlie,

Hmm. still not getting it.  Maybe an Excel 2010 incompatibility with your
file?

Can you right-click the userform and select Export File...  then send the
resulting .frm and .frx files?

Thanks,

Asa

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Cab Boose
Sent: Sunday, February 05, 2012 9:10 PM


To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ vlookup in Text Box

 

Hi Asa

 

Workbook attached.  The code is in Userform 1.   Textbox 8

 

 

Thanks 

 

Charlie

On Mon, Feb 6, 2012 at 2:43 PM, Asa Rossoff  wrote:

Hi Charlie,

Can you post your workbook?  The original workbook you posted did not seem
to contain your VBA project--just the data.

 

If I can see your form code I can better tell what might be going on.

 

Asa

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Cab Boose
Sent: Sunday, February 05, 2012 1:35 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ vlookup in Text Box

 

Hi Asa

 

Have changed the two things, but now I get a 1004 error.   Unable to get the
vlookup of the worksheet function class.  

 

 

Note that I have Option Explicit at top of page, do I need to declare
anything ?

Thanks

 

 

Charlie

On Sun, Feb 5, 2012 at 8:20 PM, Asa Rossoff  wrote:

Hi Charlie,

Glad my last post helped :)

 

>From a quick look I see two issues/potential issues:

1.   The syntax error:

TextBox5.Value = WorksheetFunction.VLookup(TextBox8.Value,
Range.("DBase"),2,False)

Remove the "." between "Range" and ("Dbase"):

TextBox5.Value = WorksheetFunction.VLookup(TextBox8.Value, Range
("DBase"),2,False)

2.   The Defined Names (ranges) in your workbook.  They include the
header row, which can interfere with lookup functions.  Not a high
likelihood in the exact usage that you have here, but still might be a good
idea to change.

 

P.S. In my last post, I used ActiveWorkbook.Worksheets(.).Range(.) in the
Userform_Initialize event to set up the linked cell.  You can consider if
ThisWorkbook is more appropriate than ActiveWorkbook in a given instance.  I
actually recommend always using ThisWorkbook if the workbook containing the
VBA code/userform is the workbook you mean and only using ActiveWorkbook
when you might mean another workbook---that which is on-screen at any given
moment.  Avoid pitfalls that way.  Whoops :)

Asa

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Cab Boose
Sent: Saturday, February 04, 2012 10:48 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ vlookup in Text Box

 

Hi

 

See attached worksheet.   Excel2000

 

I have  userform1  and one of the codes is to lookup a part # (in Textbox
8)(

$$Excel-Macros$$ INDEX FUNCTION & MATCH FUNCTION

2012-02-06 Thread Jai
Dear Excel Group Member,


Please give the some example of  index function & Match Function  & how can
use both function in combined.

-- 
FORUM RULES (986+ 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. 

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

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


Re: $$Excel-Macros$$ INDEX FUNCTION & MATCH FUNCTION

2012-02-06 Thread PrIyAnKa
Kindly check below links

http://www.techonthenet.com/excel/formulas/index_function.php
http://dmcritchie.mvps.org/excel/vlookup.htm
http://www.ozgrid.com/Excel/left-lookup.htm


On Mon, Feb 6, 2012 at 3:33 PM, Jai  wrote:

> Dear Excel Group Member,
>
>
> Please give the some example of  index function & Match Function  & how
> can use both function in combined.
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ 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. 

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

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


$$Excel-Macros$$ Excel 2007 not opening the sheet

2012-02-06 Thread Idhrees Mohamed
Dear Friends,

I am using excel 2007 and my files are not opening in the first attempt if
i minimize the window and maximize or right click inside open or new then
once the contents will show. Please let me know how can i rectify the error.

-- 
Thanks & Regards,

Mohamed Idhrees. S.

-- 
FORUM RULES (986+ 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. 

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

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


Re: $$Excel-Macros$$ Need a small MACRO to SPLIT

2012-02-06 Thread dguillett1

Glad to help



Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message- 
From: Somnath Khadilkar

Sent: Sunday, February 05, 2012 8:43 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need a small MACRO to SPLIT

Many thanks Don Guillett Sir,
   You hv done MORE than my requirement.
=mangal ho [ GOD BLESS ]

On 2/5/12, dguillett1  wrote:

See Attached to make unique list>filter and copy to new sheets in file

Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Somnath Khadilkar
Sent: Sunday, February 05, 2012 11:32 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need a small MACRO to SPLIT

Good even...
   I have attached a sample file

depending upon colm A I need to split the whole DATA sheets into
multiple sheets in the same/diff. file each sheets be named as per the
COLM 'A', if possible. These entries are from few to many 100 K [ max
distinct cities < 25, however]

=mangal ho



Good Morning.
   I receive  XL file comprising 1-sheet. Depending upon Colm 'A' I
need to SPLIT this single sheet into MULTIPLE sheets [ with this colm
as it name. ] The Distinct entries in this colm. would be less than
say 25, but the no of entries cud be anything say 10 to 100 K.

Regards

You really need to give us details and send a file with a complete
explanation.



Don Guillett
SalesAid Software
dguille...@gmail.com

--
FORUM RULES (986+ 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.

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

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

--
FORUM RULES (986+ 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.

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

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



--
FORUM RULES (986+ 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.


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


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


--
FORUM RULES (986+ 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. 


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

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


Re: $$Excel-Macros$$ refreshing data of sheet2

2012-02-06 Thread dguillett1
Your macro worked on sheet 1 because you were on sheet 1 and didn’t work on 
sheet 2 because your with did not have the necessary dots.
with sheet2
.do it
.do that
.do anoither
end with

Don Guillett
SalesAid Software
dguille...@gmail.com

From: Shankar Bheema 
Sent: Sunday, February 05, 2012 10:50 PM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ refreshing data of sheet2

Dear experts.

I attached an excel worksheet and want to refresh data of sheet2.  Pls specify 
the code.
-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (986+ 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. 

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

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


Re: $$Excel-Macros$$ datediff doubt

2012-02-06 Thread dguillett1
Your life would be simpler if you designed withOUT all of these userforms, etc. 
KISS

Don Guillett
SalesAid Software
dguille...@gmail.com

From: Shankar Bheema 
Sent: Sunday, February 05, 2012 10:59 PM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ datediff doubt

Dear Experts,

I placed two userforms for a worksheet.

txtavgfrom1 of userform2 should carry the next day of the previous 10 months 
date of txtdor.text of userform 1 
eg. if txtdor.text is 30-04-2041 then txtavgfrom1 of userform2 should carry 
01-07-2040.

If the dateavgfrom1 of userform2 not starts with the 1st then the days combo 
should active and produce the difference of days between the dates or else the 
months combo should active and produce the difference of months.

waiting for the solution

regards
shankar
-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (986+ 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. 

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

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


$$Excel-Macros$$ Extract the single word called "cell" from the corresponding Rows().

2012-02-06 Thread Mohammed Muneer
 
 
 
 
Regards,
Muneer,
CC...

-- 
FORUM RULES (986+ 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. 

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

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


Book1.xls
Description: Book1.xls


Re: $$Excel-Macros$$ refreshing data of sheet2

2012-02-06 Thread Shankar Bheema
thank you  so much

On Mon, Feb 6, 2012 at 7:04 PM, dguillett1  wrote:

>   Your macro worked on sheet 1 because you were on sheet 1 and didn’t
> work on sheet 2 because your with did not have the necessary dots.
> with sheet2
> .do it
> .do that
> .do anoither
> end with
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* Shankar Bheema 
> *Sent:* Sunday, February 05, 2012 10:50 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ refreshing data of sheet2
>
> Dear experts.
>
> I attached an excel worksheet and want to refresh data of sheet2.  Pls
> specify the code.
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ 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. 

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

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


Re: $$Excel-Macros$$ Need A Macro To Move Rows

2012-02-06 Thread dguillett1
Place in a module and save the file as macro enabled. xls or .xlsM
‘==
Option Explicit
Sub lineemupSAS()
Dim i As Long
Application.ScreenUpdating = False
For i = Cells(Rows.Count, 1).End(xlUp).Row To 2 Step -2
  Cells(i, 1).Resize(, 10).Copy Cells(i - 1, "K")
  Rows(i).Delete
Next i
Columns.AutoFit
Application.ScreenUpdating = True
End Sub
‘=
Don Guillett
SalesAid Software
dguille...@gmail.com

From: John A. Smith 
Sent: Monday, February 06, 2012 8:21 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Need A Macro To Move Rows

Thank you for your ongoing Excel help.  I need a macro to correct a download 
issue.  The download places one event on two lines in 10 columns.  I need the 
second line of every event moved up next the first part of the event, thereby 
doubling the number of columns but cutting the number of rows in half.

I have detailed an example in the attached file.  Thank you again for all your 
help and teaching.

John
-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (986+ 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. 

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

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


Re: $$Excel-Macros$$ Need A Macro To Move Rows

2012-02-06 Thread John A. Smith
Thanks again for your assistance Don, your help is very much appreciated.

John

On Mon, Feb 6, 2012 at 10:03 AM, dguillett1  wrote:

>   Place in a module and save the file as macro enabled. xls or .xlsM
> ‘==
> Option Explicit
> Sub lineemupSAS()
> Dim i As Long
> Application.ScreenUpdating = False
> For i = Cells(Rows.Count, 1).End(xlUp).Row To 2 Step -2
>   Cells(i, 1).Resize(, 10).Copy Cells(i - 1, "K")
>   Rows(i).Delete
> Next i
> Columns.AutoFit
> Application.ScreenUpdating = True
> End Sub
> ‘=
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* John A. Smith 
> *Sent:* Monday, February 06, 2012 8:21 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Need A Macro To Move Rows
>
>   Thank you for your ongoing Excel help.  I need a macro to correct a
> download issue.  The download places one event on two lines in 10 columns.
> I need the second line of every event moved up next the first part of the
> event, thereby doubling the number of columns but cutting the number of
> rows in half.
>
> I have detailed an example in the attached file.  Thank you again for all
> your help and teaching.
>
> John
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ 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. 

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

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


Re: $$Excel-Macros$$ Need A Macro To Move Rows

2012-02-06 Thread dguillett1
Glad to help

Don Guillett
SalesAid Software
dguille...@gmail.com

From: John A. Smith 
Sent: Monday, February 06, 2012 9:11 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Need A Macro To Move Rows

Thanks again for your assistance Don, your help is very much appreciated.

John


On Mon, Feb 6, 2012 at 10:03 AM, dguillett1  wrote:

  Place in a module and save the file as macro enabled. xls or .xlsM
  ‘==
  Option Explicit
  Sub lineemupSAS()
  Dim i As Long
  Application.ScreenUpdating = False
  For i = Cells(Rows.Count, 1).End(xlUp).Row To 2 Step -2
Cells(i, 1).Resize(, 10).Copy Cells(i - 1, "K")
Rows(i).Delete
  Next i
  Columns.AutoFit
  Application.ScreenUpdating = True
  End Sub
  ‘=
  Don Guillett
  SalesAid Software
  dguille...@gmail.com

  From: John A. Smith 
  Sent: Monday, February 06, 2012 8:21 AM
  To: excel-macros@googlegroups.com 
  Subject: $$Excel-Macros$$ Need A Macro To Move Rows

  Thank you for your ongoing Excel help.  I need a macro to correct a download 
issue.  The download places one event on two lines in 10 columns.  I need the 
second line of every event moved up next the first part of the event, thereby 
doubling the number of columns but cutting the number of rows in half.

  I have detailed an example in the attached file.  Thank you again for all 
your help and teaching.

  John
  -- 
  FORUM RULES (986+ 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. 
   
  NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
   
  
--
  To post to this group, send email to excel-macros@googlegroups.com

  -- 
  FORUM RULES (986+ 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. 
   
  NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
   
  
--
  To post to this group, send email to excel-macros@googlegroups.com


-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (986+ 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. 

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

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


Re: $$Excel-Macros$$ Extract the single word called "cell" from the corresponding Rows().

2012-02-06 Thread dguillett1
I’m confused. Start over with a better explanation and before/after examples


Don Guillett
SalesAid Software
dguille...@gmail.com

From: Mohammed Muneer 
Sent: Monday, February 06, 2012 8:08 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Extract the single word called "cell" from the 
corresponding Rows().





Regards,
Muneer,
CC...
-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (986+ 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. 

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

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


Re: $$Excel-Macros$$ formula in rate column

2012-02-06 Thread raghu gr
Thank you sir, its working

with regards
raghu

On Mon, Feb 6, 2012 at 8:20 PM, The Viper  wrote:

> check the attachment and go to rate sheet
>
>
> On Sun, Feb 5, 2012 at 2:13 PM, raghu gr  wrote:
>
>> hi,
>>
>> Thanks a lot sir,
>>
>> For the same type of file i tried to write formula in the attached file,
>> but i could not, so pls request to give formula for attached file also.
>>
>> with regards
>> Raghu
>>
>>
>> On Sat, Feb 4, 2012 at 10:50 AM, The Viper  wrote:
>>
>>> hi
>>>
>>> check the attachment
>>>
>>>
>>>
>>> On Sat, Feb 4, 2012 at 12:02 AM, raghu gr wrote:
>>>
 Hi experts,

 I have a invoice file and summary file, i want the formula in rate
 column, which has to pick from rate sheet.
 please help me in this regard

 Attached sample file

 Thank you

 with regards
 Raghu

 --
 FORUM RULES (986+ 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.

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


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

>>>
>>>
>>>
>>> --
>>> *Great day,*
>>> *viper*
>>>
>>> --
>>> FORUM RULES (986+ 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.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>
>>  --
>> FORUM RULES (986+ 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.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> *Great day,*
> *viper*
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ 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 questi

Re: $$Excel-Macros$$ formula in rate column

2012-02-06 Thread NOORAIN ANSARI
Dear Raghu,

You can use..

=VLOOKUP($G$2,CHOOSE({1,2},RATESHEET!$B$6:$B$9,RATESHEET!$C$6:$C$9),2,0)

See attached sheet..



On Sat, Feb 4, 2012 at 12:02 AM, raghu gr  wrote:

> Hi experts,
>
> I have a invoice file and summary file, i want the formula in rate column,
> which has to pick from rate sheet.
> please help me in this regard
>
> Attached sample file
>
> Thank you
>
> with regards
> Raghu
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Thanks & regards,
Noorain Ansari
 *http://noorainansari.com/* 
*http://excelmacroworld.blogspot.com/*

-- 
FORUM RULES (986+ 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. 

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

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


SAMPLEINVOICE(Solved).xls
Description: MS-Excel spreadsheet


Re: $$Excel-Macros$$ TEXT FUNCTION PROBLEM

2012-02-06 Thread respuzy
Thanks boss
Sent from my BlackBerry® smartphone from Airtel Ghana

-Original Message-
From: "dguillett1" 
Sender: excel-macros@googlegroups.com
Date: Mon, 6 Feb 2012 09:50:15 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ TEXT FUNCTION PROBLEM

See attached

Don Guillett
SalesAid Software
dguille...@gmail.com

From: hilary lomotey 
Sent: Monday, February 06, 2012 9:15 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ TEXT FUNCTION PROBLEM

Hi Experts

I am trying to have a currency symbol in front of a value anytime i select the 
currency as demonstrated below (file attached also), the problem is am able to 
achieve that however, i get so many decimal places  so i tried using the text 
function to reduce it to two d. places, but when i insert the text formula, i 
dont get the symbol anymore, can anyone pls help on this , thanks 
  3   C. SYMBOL CURRENCY AVERAGE BUYING  SELLING   2.6241
 
  $ DOLLAR($) 1.66385 1.6467 1.681   
  € EURO(€) 2.17605 2.1541 2.198   
  £ POUND(£) 2.6241 2.5968 2.6514   
  GH¢ CEDI(GH¢)   1.  1. 1.   
  
  
  
POUND(£) Equivalent 
  200,000.00  £76216.6075987958  
  

-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (986+ 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. 

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

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

-- 
FORUM RULES (986+ 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. 

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

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


Re: $$Excel-Macros$$ SUBTOTAL REMOVE

2012-02-06 Thread Sam Mathai Chacko
To keep it shorter, and more efficient, one could write

Sub ClearSubTotal()

ActiveSheet.UsedRange.RemoveSubtotal

End Sub

Regards,

Sam Mathai Chacko

On Mon, Feb 6, 2012 at 2:16 PM, Maries  wrote:

> Hi,
> **
> *Try this code:*
> **
> Sub Macro1()
> Cells.Select
> Selection.RemoveSubtotal
> End Sub
>
> Regards,
>
> MARIES.
>
> On Mon, Feb 6, 2012 at 11:37 AM, chandra sekaran 
> wrote:
>
>> HI ALL
>>
>> I have write  small macro , i want revmove  subtotal  if  Active sheet
>> subtotal method  is there
>>
>>
>>
>> Sub Macro1()
>>
>> If ActiveSheet.SubtotalMethod = True Then
>> Selection.RemoveSubtotal
>> End If
>>
>> End Sub
>>
>> can any one  correct this code
>>
>> Regards
>> chandru
>> chennai
>>
>> --
>> FORUM RULES (986+ 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.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>  --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Sam Mathai Chacko

-- 
FORUM RULES (986+ 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. 

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

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


Re: $$Excel-Macros$$ vlookup in Text Box

2012-02-06 Thread Sam Mathai Chacko
A more appropriate event for this case would be the Exit event. You can
just type in your number, for example 3 and hit the ENTER key. And
generally speaking, the lesser the lines, the more efficient the code.

Private Sub TextBox8_Exit(ByVal Cancel As MSForms.ReturnBoolean)
TextBox5.Value = WorksheetFunction.VLookup(Val(TextBox8.Value),
Range("DBase"), 2, False)
End Sub

Private Sub TextBox8_Change()
TextBox5.Text = ""
End Sub

And just in case you want to ensure that there are no errors in case the
user hits the enter key (return key) by mistake, you can add On Error
Resume Next as Asa mentioned (in the Exit event that is).

Regards,
Sam Mathai Chacko

On Mon, Feb 6, 2012 at 2:27 PM, Asa Rossoff  wrote:

> Hi charlie,
>
> Got it.
>
> Ok, the error is just indicating that the vlookup failed to find the
> Part#.  It failed for at least two reasons: (1) The VLookup is in the
> Change event, which fires after every change, such as after each keypress -
> -so the whole part# was probably not entered yet, and (2) The value of
> textboxes is text (a string in vba terminology), but the Part#s in your
> database are numbers.
>
> ** **
>
> You can resolve issue #1 by handling/ignoring errors, but leaving the code
> in the Change event, if you want Vlookups to execute repeatedly while
> someone types, i.e.:
>
> Private Sub TextBox8_Change()
>
> *On Error Resume Next*
>
> TextBox5.Value = WorksheetFunction.VLookup(TextBox8.Value, Range("DBase"),
> 2, False)
>
> End Sub
>
> ** **
>
> You can resolve issue #2 by use of the Val() function to convert the text
> to a number:
>
> Private Sub TextBox8_Change()
>
> On Error Resume Next
>
> TextBox5.Value = WorksheetFunction.VLookup(*Val(TextBox8.Value)*,
> Range("DBase"), 2, False)
>
> End Sub
>
> ** **
>
> You could, if desired, make the description field go blank rather than
> retaining it's previous value if there was an error in the vlookup:
>
> Private Sub TextBox8_Change()
>
> On Error Resume Next
>
> TextBox5.Value = WorksheetFunction.VLookup(Val(TextBox8.Value),
> Range("DBase"), 2, False)
>
> *If Err.Number <> 0 Then TextBox5.Value = ""*
>
> End Sub
>
> ** **
>
> *Back to issue #1:*  If you want to only do your Vlookups when the user
> has completely finished entering the part#, you should use a different
> event instead.  There are several events that might be appropriate, but
> probably BeforeUpdate would be a good call barring a specific reason to use
> another event:
>
> Private Sub TextBox8_BeforeUpdate(ByVal Cancel As MSForms.ReturnBoolean)**
> **
>
> On Error Resume Next
>
> TextBox5.Value = WorksheetFunction.VLookup(Val(TextBox8.Value),
> Range("DBase"), 2, False)
>
> If Err.Number <> 0 Then TextBox5.Value = "" ' Optional
>
> End Sub
>
> ** **
>
> Asa
>
> ** **
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Cab Boose
> *Sent:* Sunday, February 05, 2012 10:48 PM
> *To:* excel-macros@googlegroups.com
>
> *Subject:* Re: $$Excel-Macros$$ vlookup in Text Box
>
> ** **
>
> Hi Asa
>
>  
>
> Found the files see attached.
>
>  
>
> Charlie in New Zealand
>
>
>
>  
>
> On Mon, Feb 6, 2012 at 7:14 PM, Asa Rossoff  wrote:
>
> Charlie,
>
> Hmm… still not getting it.  Maybe an Excel 2010 incompatibility with your
> file?
>
> Can you right-click the userform and select Export File...  then send the
> resulting .frm and .frx files?
>
> Thanks,
>
> Asa
>
>  
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Cab Boose
> *Sent:* Sunday, February 05, 2012 9:10 PM
>
>
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ vlookup in Text Box
>
>  
>
> Hi Asa
>
>  
>
> Workbook attached.  The code is in Userform 1.   Textbox 8
>
>  
>
>  
>
> Thanks 
>
>  
>
> Charlie
>
> On Mon, Feb 6, 2012 at 2:43 PM, Asa Rossoff  wrote:
>
> Hi Charlie,
>
> Can you post your workbook?  The original workbook you posted did not seem
> to contain your VBA project--just the data.
>
>  
>
> If I can see your form code I can better tell what might be going on.
>
>  
>
> Asa
>
>  
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Cab Boose
> *Sent:* Sunday, February 05, 2012 1:35 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ vlookup in Text Box
>
>  
>
> Hi Asa
>
>  
>
> Have changed the two things, but now I get a 1004 error.   Unable to get
> the vlookup of the worksheet function class.  
>
>  
>
>  
>
> Note that I have Option Explicit at top of page, do I need to declare
> anything ?
>
> Thanks
>
>  
>
>  
>
> Charlie
>
> On Sun, Feb 5, 2012 at 8:20 PM, Asa Rossoff  wrote:
>
> Hi Charlie,
>
> Glad my last po

Re: $$Excel-Macros$$ SUBTOTAL REMOVE

2012-02-06 Thread chandra sekaran
Hi sam,

  If  Subtotal method  is there than only remove subtotal works , in that
case whether subtotal paticular sheet is there or not  if subototal method
 is there i will use below code will work.if not thereby pass
remove subtotal  then subtotal commant will work this my query

chandru




On Mon, Feb 6, 2012 at 10:50 PM, Sam Mathai Chacko wrote:

> To keep it shorter, and more efficient, one could write
>
> Sub ClearSubTotal()
>
> ActiveSheet.UsedRange.RemoveSubtotal
>
> End Sub
>
> Regards,
>
> Sam Mathai Chacko
>
>
> On Mon, Feb 6, 2012 at 2:16 PM, Maries  wrote:
>
>>  Hi,
>> **
>> *Try this code:*
>> **
>> Sub Macro1()
>> Cells.Select
>> Selection.RemoveSubtotal
>> End Sub
>>
>> Regards,
>>
>> MARIES.
>>
>> On Mon, Feb 6, 2012 at 11:37 AM, chandra sekaran 
>> wrote:
>>
>>> HI ALL
>>>
>>> I have write  small macro , i want revmove  subtotal  if  Active sheet
>>> subtotal method  is there
>>>
>>>
>>>
>>> Sub Macro1()
>>>
>>> If ActiveSheet.SubtotalMethod = True Then
>>> Selection.RemoveSubtotal
>>> End If
>>>
>>> End Sub
>>>
>>> can any one  correct this code
>>>
>>> Regards
>>> chandru
>>> chennai
>>>
>>> --
>>> FORUM RULES (986+ 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.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>
>>  --
>> FORUM RULES (986+ 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.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> Sam Mathai Chacko
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ 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. 

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

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


Re: $$Excel-Macros$$ SUBTOTAL REMOVE

2012-02-06 Thread Sam Mathai Chacko
There is no object model in Excel which tests the use of subtotal in a
worksheet/range.

The closest you could get is to look whether the used range has something
like an =SUBTOTAL(*) somewhere, and then use the code that I suggested
below. But that would then not be fool proof. The possibility that you used
a SUBTOTAL formula deliberately somewhere cannot be ruled out.

So to keep it simple, a reasonable solution, but not what old-school VBA
experts would be happy about, would be to use an On Error Resume Next.
Personally speaking, that is also not my kind of recommendation, but until
Microsoft comes out with an object model that checks the existence of
SUBTOTAL in the sheet/range, we have to use this.

So, just to show how I'd do it out of laziness

Sub ClearSubTotal()

On Error Resume Next
ActiveSheet.UsedRange.RemoveSubtotal

End Sub

Regards,

Sam Mathai Chacko

On Mon, Feb 6, 2012 at 11:20 PM, chandra sekaran wrote:

> Hi sam,
>
>   If  Subtotal method  is there than only remove subtotal works , in that
> case whether subtotal paticular sheet is there or not  if subototal method
>  is there i will use below code will work.if not thereby pass
> remove subtotal  then subtotal commant will work this my query
>
> chandru
>
>
>
>
> On Mon, Feb 6, 2012 at 10:50 PM, Sam Mathai Chacko wrote:
>
>> To keep it shorter, and more efficient, one could write
>>
>> Sub ClearSubTotal()
>>
>> ActiveSheet.UsedRange.RemoveSubtotal
>>
>> End Sub
>>
>> Regards,
>>
>> Sam Mathai Chacko
>>
>>
>> On Mon, Feb 6, 2012 at 2:16 PM, Maries  wrote:
>>
>>>  Hi,
>>> **
>>> *Try this code:*
>>> **
>>> Sub Macro1()
>>> Cells.Select
>>> Selection.RemoveSubtotal
>>> End Sub
>>>
>>> Regards,
>>>
>>> MARIES.
>>>
>>> On Mon, Feb 6, 2012 at 11:37 AM, chandra sekaran >> > wrote:
>>>
 HI ALL

 I have write  small macro , i want revmove  subtotal  if  Active sheet
 subtotal method  is there



 Sub Macro1()

 If ActiveSheet.SubtotalMethod = True Then
 Selection.RemoveSubtotal
 End If

 End Sub

 can any one  correct this code

 Regards
 chandru
 chennai

 --
 FORUM RULES (986+ 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.

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


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

>>>
>>>  --
>>> FORUM RULES (986+ 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.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>
>>
>>
>> --
>> Sam Mathai Chacko
>>
>> --
>> FORUM RULES (986+ 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.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send ema

Re: $$Excel-Macros$$ Excel 2007 not opening the sheet

2012-02-06 Thread Sam Mathai Chacko
HEre's a discussion on this topic. Scroll down to a little over the half
way mark, and you should find a few probable solutions. One was about
deleting the pdfmaker file (do you have that?). Second was about changing
some setting in Excel. Either way, I haven't faced this myself, so no
solutions from my side.

Regards,

Sam Mathai Chacko

On Mon, Feb 6, 2012 at 4:15 PM, Idhrees Mohamed wrote:

> Dear Friends,
>
> I am using excel 2007 and my files are not opening in the first attempt if
> i minimize the window and maximize or right click inside open or new then
> once the contents will show. Please let me know how can i rectify the
> error.
>
> --
> Thanks & Regards,
>
> Mohamed Idhrees. S.
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Sam Mathai Chacko

-- 
FORUM RULES (986+ 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. 

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

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


Re: $$Excel-Macros$$ TEXT FUNCTION PROBLEM

2012-02-06 Thread Sam Mathai Chacko
The text can be formatted by having the space *within* the format

=CHOOSE(A1,C2,C3,C4,C5)&TEXT(C10/I1," 0,0.00")

or using Don's suggestion

=INDEX(C2:C5,MATCH(D12,D2:D5))&TEXT(C13/INDEX(E2:E5,MATCH(D12,D2:D5)),"
0,0.00")

Regards,

Sam Mathai Chacko

On Mon, Feb 6, 2012 at 10:31 PM,  wrote:

> Thanks boss
> Sent from my BlackBerry® smartphone from Airtel Ghana
> --
> *From: * "dguillett1" 
> *Sender: * excel-macros@googlegroups.com
> *Date: *Mon, 6 Feb 2012 09:50:15 -0600
> *To: *
> *ReplyTo: * excel-macros@googlegroups.com
> *Subject: *Re: $$Excel-Macros$$ TEXT FUNCTION PROBLEM
>
>  See attached
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* hilary lomotey 
> *Sent:* Monday, February 06, 2012 9:15 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ TEXT FUNCTION PROBLEM
>
>  Hi Experts
>
> I am trying to have a currency symbol in front of a value anytime i select
> the currency as demonstrated below (file attached also), the problem is am
> able to achieve that however, i get so many decimal places  so i tried
> using the text function to reduce it to two d. places, but when i insert
> the text formula, i dont get the symbol anymore, can anyone pls help on
> this , thanks
>   3   C. SYMBOL CURRENCY AVERAGE BUYING  SELLING   2.6241
> $ DOLLAR($) 1.66385 1.6467 1.681   € EURO(€)
> 2.17605 2.1541 2.198   £ POUND(£) 2.6241 2.5968 2.6514
>   GH¢ CEDI(GH¢)   1. 1. 1.
>
>   POUND(£) Equivalent
> 200,000.00  £76216.6075987958
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Sam Mathai Chacko

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not

Re: $$Excel-Macros$$ datediff doubt

2012-02-06 Thread Sam Mathai Chacko
Your txtavgto1.Value in form 2 is empty during execution of the form
initialize event. I have just added a conditional statement to work around
the error.

Now, your objective is not clear. So you might want to rephrase.

Second, I am of the same opinion as Don. It seems you have generated an
obsession for user forms. There are lots of ways you can do this without a
user form.

Anyway, I leave that to your discretion.

Regards,

Sam Mathai Chacko

On Mon, Feb 6, 2012 at 7:07 PM, dguillett1  wrote:

>   Your life would be simpler if you designed withOUT all of these
> userforms, etc. KISS
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* Shankar Bheema 
> *Sent:* Sunday, February 05, 2012 10:59 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ datediff doubt
>
> Dear Experts,
>
> I placed two userforms for a worksheet.
>
> txtavgfrom1 of userform2 should carry the next day of the previous 10
> months date of txtdor.text of userform 1
> eg. if txtdor.text is 30-04-2041 then txtavgfrom1 of userform2 should
> carry 01-07-2040.
>
> If the dateavgfrom1 of userform2 not starts with the 1st then the days
> combo should active and produce the difference of days between the dates or
> else the months combo should active and produce the difference of months.
>
> waiting for the solution
>
> regards
> shankar
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Sam Mathai Chacko

-- 
FORUM RULES (986+ 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. 

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

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


Re: $$Excel-Macros$$ TEXT FUNCTION PROBLEM

2012-02-06 Thread respuzy
Thanks Sam.you guys are genius.  VEry grateful 
Sent from my BlackBerry® smartphone from Airtel Ghana

-Original Message-
From: Sam Mathai Chacko 
Sender: excel-macros@googlegroups.com
Date: Tue, 7 Feb 2012 00:40:37 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ TEXT FUNCTION PROBLEM

The text can be formatted by having the space *within* the format

=CHOOSE(A1,C2,C3,C4,C5)&TEXT(C10/I1," 0,0.00")

or using Don's suggestion

=INDEX(C2:C5,MATCH(D12,D2:D5))&TEXT(C13/INDEX(E2:E5,MATCH(D12,D2:D5)),"
0,0.00")

Regards,

Sam Mathai Chacko

On Mon, Feb 6, 2012 at 10:31 PM,  wrote:

> Thanks boss
> Sent from my BlackBerry® smartphone from Airtel Ghana
> --
> *From: * "dguillett1" 
> *Sender: * excel-macros@googlegroups.com
> *Date: *Mon, 6 Feb 2012 09:50:15 -0600
> *To: *
> *ReplyTo: * excel-macros@googlegroups.com
> *Subject: *Re: $$Excel-Macros$$ TEXT FUNCTION PROBLEM
>
>  See attached
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* hilary lomotey 
> *Sent:* Monday, February 06, 2012 9:15 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ TEXT FUNCTION PROBLEM
>
>  Hi Experts
>
> I am trying to have a currency symbol in front of a value anytime i select
> the currency as demonstrated below (file attached also), the problem is am
> able to achieve that however, i get so many decimal places  so i tried
> using the text function to reduce it to two d. places, but when i insert
> the text formula, i dont get the symbol anymore, can anyone pls help on
> this , thanks
>   3   C. SYMBOL CURRENCY AVERAGE BUYING  SELLING   2.6241
> $ DOLLAR($) 1.66385 1.6467 1.681   € EURO(€)
> 2.17605 2.1541 2.198   £ POUND(£) 2.6241 2.5968 2.6514
>   GH¢ CEDI(GH¢)   1. 1. 1.
>
>   POUND(£) Equivalent
> 200,000.00  £76216.6075987958
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Sam Mathai Chacko

-- 
FORUM RULES (986+ 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 que

Re: $$Excel-Macros$$ formula in rate column

2012-02-06 Thread Sam Mathai Chacko
Your use of the CHOOSE formula here is absolutely obsolete.

Having CHOOSE({1,2},RATESHEET!$B$6:$B$9,RATESHEET!$C$6:$C$9) is equivalent
to simply using RATESHEET!$B$6:$C$9

Instead, you could have passed the column number dynamically by looking
were the CR COIL is located. For this you could have matched the value as
C3 with wildcards around it in the column header of the rate sheet data
table.

Here's how the formula would look like

=VLOOKUP($G$2,RATESHEET!$B$6:$C$9,MATCH("*"&C3&"*",RATESHEET!$B$5:$F$5,0),0)

Regards,

Sam Mathai Chacko

On Mon, Feb 6, 2012 at 10:18 PM, NOORAIN ANSARI wrote:

>
> Dear Raghu,
>
> You can use..
>
> =VLOOKUP($G$2,CHOOSE({1,2},RATESHEET!$B$6:$B$9,RATESHEET!$C$6:$C$9),2,0)
>
> See attached sheet..
>
>
>
> On Sat, Feb 4, 2012 at 12:02 AM, raghu gr  wrote:
>
>> Hi experts,
>>
>> I have a invoice file and summary file, i want the formula in rate
>> column, which has to pick from rate sheet.
>> please help me in this regard
>>
>> Attached sample file
>>
>> Thank you
>>
>> with regards
>> Raghu
>>
>> --
>> FORUM RULES (986+ 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.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
>  ** *http://noorainansari.com/*
> *http://excelmacroworld.blogspot.com/*
>
>
>  --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Sam Mathai Chacko

-- 
FORUM RULES (986+ 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. 

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

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


Re: $$Excel-Macros$$ datediff doubt

2012-02-06 Thread dguillett1
As many of you know, I adhere to the KISS principle and rarely use all of these 
forms or a lot of CF. I prefer to have a macro do the work. In fact, on many 
projects I do not even use visible formulas. I also like to breakup vlookups, 
etc into meaningful blocks instead of entire columns. ie: Instead of a lot of 
buttons to sort a set of columns, I’ll use a double click event. I am aware 
that some project designers go to great lengths to make it so the end user has 
no way of understand what is going on. Why use a userform when a cell or block 
of cells can do the same thing is beyond me. Then there is sometimes the poster 
here who claims our work as their own to impress the boss. Too bad the boss 
doesn’t know better.  I didn’t become a reg mgr for ING and series 7 brokers 
license holder by being stupid. Excel keeps my mind working at age 75.

Don Guillett
SalesAid Software
dguille...@gmail.com

From: Sam Mathai Chacko 
Sent: Monday, February 06, 2012 1:24 PM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ datediff doubt

Your txtavgto1.Value in form 2 is empty during execution of the form initialize 
event. I have just added a conditional statement to work around the error.

Now, your objective is not clear. So you might want to rephrase.

Second, I am of the same opinion as Don. It seems you have generated an 
obsession for user forms. There are lots of ways you can do this without a user 
form.

Anyway, I leave that to your discretion.

Regards,

Sam Mathai Chacko


On Mon, Feb 6, 2012 at 7:07 PM, dguillett1  wrote:

  Your life would be simpler if you designed withOUT all of these userforms, 
etc. KISS

  Don Guillett
  SalesAid Software
  dguille...@gmail.com

  From: Shankar Bheema 
  Sent: Sunday, February 05, 2012 10:59 PM
  To: excel-macros@googlegroups.com 
  Subject: $$Excel-Macros$$ datediff doubt

  Dear Experts,

  I placed two userforms for a worksheet.

  txtavgfrom1 of userform2 should carry the next day of the previous 10 months 
date of txtdor.text of userform 1 
  eg. if txtdor.text is 30-04-2041 then txtavgfrom1 of userform2 should carry 
01-07-2040.

  If the dateavgfrom1 of userform2 not starts with the 1st then the days combo 
should active and produce the difference of days between the dates or else the 
months combo should active and produce the difference of months.

  waiting for the solution

  regards
  shankar
  -- 
  FORUM RULES (986+ 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. 
   
  NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
   
  
--
  To post to this group, send email to excel-macros@googlegroups.com

  -- 
  FORUM RULES (986+ 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. 
   
  NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
   
  
--
  To post to this group, send email to excel-macros@googlegroups.com




-- 
Sam Mathai Chacko
-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
-

Re: $$Excel-Macros$$ Need A Macro To Move Rows

2012-02-06 Thread dguillett1
Nice


Don Guillett
SalesAid Software
dguille...@gmail.com

From: Sam Mathai Chacko 
Sent: Monday, February 06, 2012 2:06 PM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Need A Macro To Move Rows

If your rows go in to the thousands, using autofilter will add a bit more 
(~40%) efficiency

Sub Consolidator()

Application.ScreenUpdating = 0
With Range("A2", Cells(Rows.Count, "J").End(xlUp))
.AutoFilter 7, "Pickup"
.Offset(1, 10).Resize(.Rows.Count - 1, 10).SpecialCells(12).FormulaR1C1 
= "=R[1]C[-10]"
.Rows(1).Offset(, 10).FormulaR1C1 = "=RC[-10]"
.AutoFilter
With .Offset(, 10).Resize(, 10)
.Value = .Value
.Offset(, -10).Copy
.PasteSpecial xlPasteFormats
.Columns(1).SpecialCells(4).EntireRow.Delete
End With
End With
Application.ScreenUpdating = 1

End Sub

Regards,

Sam Mathai Chacko


On Mon, Feb 6, 2012 at 9:21 PM, dguillett1  wrote:

  Glad to help

  Don Guillett
  SalesAid Software
  dguille...@gmail.com

  From: John A. Smith 
  Sent: Monday, February 06, 2012 9:11 AM
  To: excel-macros@googlegroups.com 
  Subject: Re: $$Excel-Macros$$ Need A Macro To Move Rows

  Thanks again for your assistance Don, your help is very much appreciated.

  John


  On Mon, Feb 6, 2012 at 10:03 AM, dguillett1  wrote:

Place in a module and save the file as macro enabled. xls or .xlsM
‘==
Option Explicit
Sub lineemupSAS()
Dim i As Long
Application.ScreenUpdating = False
For i = Cells(Rows.Count, 1).End(xlUp).Row To 2 Step -2
  Cells(i, 1).Resize(, 10).Copy Cells(i - 1, "K")
  Rows(i).Delete
Next i
Columns.AutoFit
Application.ScreenUpdating = True
End Sub
‘=
Don Guillett
SalesAid Software
dguille...@gmail.com

From: John A. Smith 
Sent: Monday, February 06, 2012 8:21 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Need A Macro To Move Rows

Thank you for your ongoing Excel help.  I need a macro to correct a 
download issue.  The download places one event on two lines in 10 columns.  I 
need the second line of every event moved up next the first part of the event, 
thereby doubling the number of columns but cutting the number of rows in half.

I have detailed an example in the attached file.  Thank you again for all 
your help and teaching.

John
-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 

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

-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 

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


  -- 
  FORUM RULES (986+ 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. 
   
  NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not 

RE: $$Excel-Macros$$ Text Box - Properties

2012-02-06 Thread Asa Rossoff
Hi Charlie,

I don't have a lot of practicle experience in all areas of Excel, so I just
realized there is an easier way to link controls to the worksheet!

 

Simply use the ControlSource property of the control and provide a cell
reference or named range.  See
http://www.ozgrid.com/Excel/free-training/ExcelVBA2/excelvba2lesson15.htm.

 

The downside to this method (and also to the exact solution I provided
below) is that the cell is updated immediately upon editing the value of the
control.  Sometimes you want to wait until an entire form is completed to
update data on the worksheet, in which case you will have to use some
variation on the VBA method I described below. (And for posterity, like I
said in a separate thread, you might want to use ThisWorkbook instead of the
ActiveWorkbook that I used in Userform_Initialize if the linked cell will
always be in the same workbook as the userform).

 

Asa

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Asa Rossoff
Sent: Saturday, February 04, 2012 5:38 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Text Box - Properties

 

The Active X Text Box control can be linked to a cell, but I think it is
only available for use on a worksheet, not a userform. and everyone keeps
telling me to avoid Active X controls on worksheets like the plague, anyway.

 

To duplicate the linking behavior, you'll have to use a little VBA code.
For example, in your form code you could use:

Public TextBox1Cell As Range

 

Private Sub UserForm_Initialize()

Set TextBox1Cell = ActiveWorkbook.Sheets("Sheet1").Range("A1")

End Sub

 

Private Sub UserForm_Terminate()

Set TextBox1Cell = Nothing

End Sub

 

Private Sub UserForm_Activate()

TextBox1.Value = TextBox1Cell.Value2

End Sub

 

Private Sub TextBox1_Change()

TextBox1Cell.Value2 = TextBox1.Value

End Sub

If you also need the control on the form to update if the worksheet cell is
changed for some other reason while the form is still open (a calculation,
other code,.) then you can add code to your worksheet's Calculate and Change
events.  If the cell will only contain a value and not a formula, you don't
need the calculate event.

Private Sub Worksheet_Change(ByVal Target As Range)

With UserForm1

If .Visible Then

If Not Application.Intersect(Target, .TextBox1Cell) Is Nothing
Then

.TextBox1.Value = .TextBox1Cell.Value2

End If

End If

End With

End Sub

 

Private Sub Worksheet_Calculate()

With UserForm1

If .Visible Then

If .TextBox1.Value <> .TextBox1Cell.Value2 Then

.TextBox1.Value = .TextBox1Cell.Value2

End If

End If

End With

End Sub

 

Asa

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Cab Boose
Sent: Saturday, February 04, 2012 4:27 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Text Box - Properties

 

Hi

 

I have a userform open with a 'text box' .  Want to link with a cell in
sheet.

 

However the 'text box'  properties does not show a 'linked cell' heading.
I am sure it use to.  How do I restore the missing property or is there
another text box I should use.

 

Thks

 

Charlie

-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

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

-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to e

Re: $$Excel-Macros$$ Need A Macro To Move Rows

2012-02-06 Thread John A. Smith
Wow, thanks Sam.  When I was trying this myself, I started down this
approach and couldn't make it work.  Thanks for the lesson.

John



On Mon, Feb 6, 2012 at 3:06 PM, Sam Mathai Chacko wrote:

> If your rows go in to the thousands, using autofilter will add a bit more
> (~40%) efficiency
>
> Sub Consolidator()
>
> Application.ScreenUpdating = 0
> With Range("A2", Cells(Rows.Count, "J").End(xlUp))
> .AutoFilter 7, "Pickup"
> .Offset(1, 10).Resize(.Rows.Count - 1,
> 10).SpecialCells(12).FormulaR1C1 = "=R[1]C[-10]"
> .Rows(1).Offset(, 10).FormulaR1C1 = "=RC[-10]"
> .AutoFilter
> With .Offset(, 10).Resize(, 10)
> .Value = .Value
> .Offset(, -10).Copy
> .PasteSpecial xlPasteFormats
> .Columns(1).SpecialCells(4).EntireRow.Delete
> End With
> End With
> Application.ScreenUpdating = 1
>
> End Sub
>
> Regards,
>
> Sam Mathai Chacko
>
>
> On Mon, Feb 6, 2012 at 9:21 PM, dguillett1  wrote:
>
>>   Glad to help
>>
>> Don Guillett
>> SalesAid Software
>> dguille...@gmail.com
>>
>>  *From:* John A. Smith 
>> *Sent:* Monday, February 06, 2012 9:11 AM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* Re: $$Excel-Macros$$ Need A Macro To Move Rows
>>
>>  Thanks again for your assistance Don, your help is very much
>> appreciated.
>>
>> John
>>
>> On Mon, Feb 6, 2012 at 10:03 AM, dguillett1  wrote:
>>
>>>   Place in a module and save the file as macro enabled. xls or .xlsM
>>> ‘==
>>> Option Explicit
>>> Sub lineemupSAS()
>>> Dim i As Long
>>> Application.ScreenUpdating = False
>>> For i = Cells(Rows.Count, 1).End(xlUp).Row To 2 Step -2
>>>   Cells(i, 1).Resize(, 10).Copy Cells(i - 1, "K")
>>>   Rows(i).Delete
>>> Next i
>>> Columns.AutoFit
>>> Application.ScreenUpdating = True
>>> End Sub
>>> ‘=
>>> Don Guillett
>>> SalesAid Software
>>> dguille...@gmail.com
>>>
>>>  *From:* John A. Smith 
>>> *Sent:* Monday, February 06, 2012 8:21 AM
>>> *To:* excel-macros@googlegroups.com
>>> *Subject:* $$Excel-Macros$$ Need A Macro To Move Rows
>>>
>>>   Thank you for your ongoing Excel help.  I need a macro to correct a
>>> download issue.  The download places one event on two lines in 10 columns.
>>> I need the second line of every event moved up next the first part of the
>>> event, thereby doubling the number of columns but cutting the number of
>>> rows in half.
>>>
>>> I have detailed an example in the attached file.  Thank you again for
>>> all your help and teaching.
>>>
>>> John
>>> --
>>> FORUM RULES (986+ 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.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>  --
>>> FORUM RULES (986+ 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.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>
>> --
>> FORUM RULES (986+ 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 pr

RE: $$Excel-Macros$$ Extract the single word called "cell" from the corresponding Rows().

2012-02-06 Thread Mohammed Muneer
Sorry Don, please check the attachment its very clear in it.

 

 

 

Regards,

Muneer,

CC...

 



From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1
Sent: Monday, February 06, 2012 6:56 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Extract the single word called "cell" from
the corresponding Rows().

 

I'm confused. Start over with a better explanation and before/after
examples

 

 

Don Guillett
SalesAid Software
dguille...@gmail.com

 

From: Mohammed Muneer   

Sent: Monday, February 06, 2012 8:08 AM

To: excel-macros@googlegroups.com 

Subject: $$Excel-Macros$$ Extract the single word called "cell" from the
corresponding Rows().

 

 

 

 

 

Regards,

Muneer,

CC...

-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook.
Forum owners and members are not responsible for any loss.
 

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

-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook.
Forum owners and members are not responsible for any loss.
 

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

-- 
FORUM RULES (986+ 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. 

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

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


Re: $$Excel-Macros$$ Extract the single word called "cell" from the corresponding Rows().

2012-02-06 Thread David Grugeon
Hi Muneer

The original attachment is not at all clear.  Neither Don nor I have the
faintest idea what you want.  Could you send another attachments with added
the result you want where you want it?  I.e just fill in the shaded cells
(if that is where the result goes) with the values you would expect them to
contain.

On 7 February 2012 14:20, Mohammed Muneer  wrote:

>  Sorry Don, please check the attachment its very clear in it.
>
> ** **
>
> ** **
>
> ** **
>
> Regards,
>
> Muneer,
>
> CC…
>
> ** **
>  --
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *dguillett1
> *Sent:* Monday, February 06, 2012 6:56 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Extract the single word called "cell"
> from the corresponding Rows().
>
> ** **
>
> I’m confused. Start over with a better explanation and before/after
> examples
>
>  
>
>  
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>  
>
> *From:* Mohammed Muneer  
>
> *Sent:* Monday, February 06, 2012 8:08 AM
>
> *To:* excel-macros@googlegroups.com 
>
> *Subject:* $$Excel-Macros$$ Extract the single word called "cell" from
> the corresponding Rows().
>
>  
>
>  
>
>  
>
>  
>
>  
>
> Regards,
>
> Muneer,
>
> CC...
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
David Grugeon

-- 
FORUM RULES (986+ 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. 

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

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


$$Excel-Macros$$ Hi friends, now its clear.....

2012-02-06 Thread Mohammed Muneer
del cell   

bel cell del

cell bel del

cell ell llec

blood consist of red cell and white cell

simos is a cell

max cell

sony cell

a cell is a source of energy for some electronic devices and stands as a
two way power.

 

Above mentioned lines are having the word "cell" in common, Ok I want to
extract the same in the cell beside (the highlighted).

For example, we are at first line del cell and if I can do this to
extract the word cell.

 

cell

del cell

cell

bel cell del

cell

cell bel del

cell

cell ell llec

cell

blood consist of red cell and white cell

cell

simos is a cell

cell

max cell

cell

sony cell

cell

a cell is a source of energy for some electronic devices and stands as a
two way power.

 

 

Regards,

Muneer,

CC...

 

 

-- 
FORUM RULES (986+ 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. 

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

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


Re: $$Excel-Macros$$ Text Box - Properties

2012-02-06 Thread Cab Boose
Hi Asa and Sam

Thanks for all the info.  It will take me a couple of days to comprehend it
all and then I will get back to you.

I really appreciate your help

Regards

Charlie

On Tue, Feb 7, 2012 at 12:10 PM, Asa Rossoff  wrote:

> Hi Charlie,
>
> I don't have a lot of practicle experience in all areas of Excel, so I
> just realized there is an easier way to link controls to the worksheet!***
> *
>
> ** **
>
> Simply use the ControlSource property of the control and provide a cell
> reference or named range.  See
> http://www.ozgrid.com/Excel/free-training/ExcelVBA2/excelvba2lesson15.htm.
> 
>
> ** **
>
> The downside to this method (and also to the exact solution I provided
> below) is that the cell is updated immediately upon editing the value of
> the control.  Sometimes you want to wait until an entire form is completed
> to update data on the worksheet, in which case you will have to use some
> variation on the VBA method I described below. (And for posterity, like I
> said in a separate thread, you might want to use ThisWorkbook instead of
> the ActiveWorkbook that I used in Userform_Initialize if the linked cell
> will always be in the same workbook as the userform).
>
> ** **
>
> Asa
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Asa Rossoff
> *Sent:* Saturday, February 04, 2012 5:38 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* RE: $$Excel-Macros$$ Text Box - Properties
>
> ** **
>
> The Active X Text Box control can be linked to a cell, but I think it is
> only available for use on a worksheet, not a userform… and everyone keeps
> telling me to avoid Active X controls on worksheets like the plague, anyway…
> 
>
> ** **
>
> To duplicate the linking behavior, you'll have to use a little VBA code.
> For example, in your form code you could use:
>
> Public TextBox1Cell As Range
>
> ** **
>
> Private Sub UserForm_Initialize()
>
> Set TextBox1Cell = ActiveWorkbook.Sheets("Sheet1").Range("A1")
>
> End Sub
>
> ** **
>
> Private Sub UserForm_Terminate()
>
> Set TextBox1Cell = Nothing
>
> End Sub
>
> ** **
>
> Private Sub UserForm_Activate()
>
> TextBox1.Value = TextBox1Cell.Value2
>
> End Sub
>
> ** **
>
> Private Sub TextBox1_Change()
>
> TextBox1Cell.Value2 = TextBox1.Value
>
> End Sub
>
> If you also need the control on the form to update if the worksheet cell
> is changed for some other reason while the form is still open (a
> calculation, other code,…) then you can add code to your worksheet's
> Calculate and Change events.  If the cell will only contain a value and not
> a formula, you don't need the calculate event.
>
> Private Sub Worksheet_Change(ByVal Target As Range)
>
> With UserForm1
>
> If .Visible Then
>
> If Not Application.Intersect(Target, .TextBox1Cell) Is Nothing
> Then
>
> .TextBox1.Value = .TextBox1Cell.Value2
>
> End If
>
> End If
>
> End With
>
> End Sub
>
> ** **
>
> Private Sub Worksheet_Calculate()
>
> With UserForm1
>
> If .Visible Then
>
> If .TextBox1.Value <> .TextBox1Cell.Value2 Then
>
> .TextBox1.Value = .TextBox1Cell.Value2
>
> End If
>
> End If
>
> End With
>
> End Sub
>
> ** **
>
> Asa
>
> ** **
>
> *From:* excel-macros@googlegroups.com [
> mailto:excel-macros@googlegroups.com ] *On
> Behalf Of *Cab Boose
> *Sent:* Saturday, February 04, 2012 4:27 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Text Box - Properties
>
> ** **
>
> Hi
>
>  
>
> I have a userform open with a 'text box' .  Want to link with a cell in
> sheet.
>
>  
>
> However the 'text box'  properties does not show a 'linked cell'
> heading. I am sure it use to.  How do I restore the missing property or
> is there another text box I should use.
>
>  
>
> Thks
>
>  
>
> Charlie
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> FORUM 

Re: $$Excel-Macros$$ SUBTOTAL REMOVE

2012-02-06 Thread chandra sekaran
Dear sam,

Thanks for your  valuable  Advice

Regards
chandru




On Tue, Feb 7, 2012 at 12:22 AM, Sam Mathai Chacko wrote:

> There is no object model in Excel which tests the use of subtotal in a
> worksheet/range.
>
> The closest you could get is to look whether the used range has something
> like an =SUBTOTAL(*) somewhere, and then use the code that I suggested
> below. But that would then not be fool proof. The possibility that you used
> a SUBTOTAL formula deliberately somewhere cannot be ruled out.
>
> So to keep it simple, a reasonable solution, but not what old-school VBA
> experts would be happy about, would be to use an On Error Resume Next.
> Personally speaking, that is also not my kind of recommendation, but until
> Microsoft comes out with an object model that checks the existence of
> SUBTOTAL in the sheet/range, we have to use this.
>
> So, just to show how I'd do it out of laziness
>
> Sub ClearSubTotal()
>
> On Error Resume Next
>
> ActiveSheet.UsedRange.RemoveSubtotal
>
> End Sub
>
> Regards,
>
> Sam Mathai Chacko
>
>   On Mon, Feb 6, 2012 at 11:20 PM, chandra sekaran  > wrote:
>
>> Hi sam,
>>
>>   If  Subtotal method  is there than only remove subtotal works , in that
>> case whether subtotal paticular sheet is there or not  if subototal method
>>  is there i will use below code will work.if not thereby pass
>> remove subtotal  then subtotal commant will work this my query
>>
>> chandru
>>
>>
>>
>>
>> On Mon, Feb 6, 2012 at 10:50 PM, Sam Mathai Chacko wrote:
>>
>>> To keep it shorter, and more efficient, one could write
>>>
>>> Sub ClearSubTotal()
>>>
>>> ActiveSheet.UsedRange.RemoveSubtotal
>>>
>>> End Sub
>>>
>>> Regards,
>>>
>>> Sam Mathai Chacko
>>>
>>>
>>> On Mon, Feb 6, 2012 at 2:16 PM, Maries  wrote:
>>>
  Hi,
 **
 *Try this code:*
 **
 Sub Macro1()
 Cells.Select
 Selection.RemoveSubtotal
 End Sub

 Regards,

 MARIES.

 On Mon, Feb 6, 2012 at 11:37 AM, chandra sekaran <
 duraichan...@gmail.com> wrote:

> HI ALL
>
> I have write  small macro , i want revmove  subtotal  if  Active
> sheet  subtotal method  is there
>
>
>
> Sub Macro1()
>
> If ActiveSheet.SubtotalMethod = True Then
> Selection.RemoveSubtotal
> End If
>
> End Sub
>
> can any one  correct this code
>
> Regards
> chandru
> chennai
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook.
> Forum owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

  --
 FORUM RULES (986+ 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.

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


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

>>>
>>>
>>>
>>> --
>>> Sam Mathai Chacko
>>>
>>> --
>>> FORUM RULES (986+ 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

$$Excel-Macros$$ Excel - Training module - Basic + Advance

2012-02-06 Thread Amit Desai (MERU)
Dear Team,

Does any have excel training ppt or module for Basic & Advance. If yes, please 
forward it with sample file.

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.

-- 
FORUM RULES (986+ 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. 

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

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


$$Excel-Macros$$ Excel test file Basic & Advance

2012-02-06 Thread Amit Desai (MERU)
Dear Team,

Please forward excel test file for basic & advance level, if anybody have it.

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.

-- 
FORUM RULES (986+ 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. 

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

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


Re: $$Excel-Macros$$ Re:

2012-02-06 Thread NOORAIN ANSARI
5)  Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.

On Sun, Feb 5, 2012 at 2:05 AM, Hemant  wrote:

>
> Good way to make some additional money.
> http://hidayeterkan.com/home.work.php?gugmailID=a7et9
>
> --
> FORUM RULES (986+ 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.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Thanks & regards,
Noorain Ansari
 ** *http://noorainansari.com/*
*http://excelmacroworld.blogspot.com/*

-- 
FORUM RULES (986+ 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. 

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

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