$$Excel-Macros$$ Re: how to use colour index if the sheet have backgroud color

[OpenExcel.com]

Hi Rajesh,

Refer --> http://msdn.microsoft.com/en-us/library/aa206146(office.11).aspx
ColorIndex - Returns or sets the color of the border. The color is
specified as an index value into the current color palette, or as a
XlColorIndex constant. This property specifies a color as an index
into the workbook color palette. You can use the Colors method to
return the current color palette as you've used in the second line of
your code.

ColorIndex has pre-defined 56 colors which you can assign to the font
color, background color, border color etc. but using color method, you
can make your own color using RGB method or can assign vb constants
like vbRed or vbYellow etc.

For e.g. To color background as gray, you can use any of the following
statement:
Columns(2).Interior.ColorIndex = 56
or
Columns(2).Interior.Color = RGB(80,80,80)



PS: In future please do not send attachments, rather try to elaborate
your problem efficiently. The group is to help and solve your issues
not your projects.




Thanks & Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com





On Nov 16, 9:16 pm, Rajesh K R  wrote:
> Hi Experts,
>
> Is it possible to use colour index code if i am using a background
> color on the sheet,pls find the attatchment and find a solution.
>
> Thanks in advance
> Regards
> Rajesh kainikkara
>
>  ATTENDANCE.XLS
> 33KViewDownload

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ workbook open password protected.

[SUMIT VYAS]

send file

On Wed, Nov 17, 2010 at 4:20 AM, Johnnyboy5 wrote:

> workbook open password protected.
>
> I need to be able to get a message box to appear with some
> information - before the Password message box appears.  I can get the
> message to
> appear after the Password box - but not before.
> any ideas.
> Johnnyboy
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Calculating direction of change across several cells

[0 1]

I'm trying to return a value (1,2,or3) based on the percent change in
values since a max value. For example, assume cells A1:E1 contain
these values:

200,300,200,50,150.

The values represent the number of widgets produced in year 1, year 2,
up to year 5.

The max value for this example is 300.

The percent change from 300 to 200 is -.33% (200-300/300).
The percent change from 200 to 50 is -.75% (50-200/200).
The percent change from 50 to 150 is +2.0% (150-50/50).

If every year since the max experienced a percent decrease, return a
1.
If every year since the max experienced a percent increase, return a
2.
In all other cases, e.g., a decrease in one year, an increase in the
next (as in this example), return a 3.

If it's not possible to use a formula for this, a macro would be fine.
I'm just stumped as to how to get Excel to calculate this. It needs to
find the peak, and then determine whether all subsequent values are
constantly decreasing, increasing, or in flux. 

Thanks for any suggestions. 
   

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ workbook open password protected.

[Johnnyboy5]

workbook open password protected.

I need to be able to get a message box to appear with some
information - before the Password message box appears.  I can get the
message to
appear after the Password box - but not before.
any ideas.
Johnnyboy

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ AutoSaveAs

[enquirer]

Thanks ever so much for your help Paul.

On Nov 16, 1:12 pm, Paul Schreiner  wrote:

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ how to use colour index if the sheet have backgroud color

[Rajesh K R]

Hi Experts,

Is it possible to use colour index code if i am using a background
color on the sheet,pls find the attatchment and find a solution.

Thanks in advance
Regards
Rajesh kainikkara

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts


ATTENDANCE.XLS
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: VBA Copying range of cells from one workbook to another while retaining the formulae

[Mike Magill]

Many thanks.  I had actually tried that and it had failed but I've
subsequently worked out what was going wrong.  The worksheet I was
copying from was protected.  I just needed to unprotect first and it
all works fine now.

On Nov 16, 1:45 pm, Ashish Jain  wrote:
> Hi Mike,
>
> Try this:
> RR.Range("A" & LastRow_RR + 1 & ":CN" & LastRow_RR + LastRow_NWR -
> 5).Formula
>  = NWR.Range("A6:CN" & LastRow_NWR).Formula
>
> 
> Thanks & Regards
> Ashish Jain
> McKinsey India Knowledge Center
> (Microsoft Certified Application Specialist)
> (Microsoft Certified 
> Professional)http://www.excelitems.comhttp://www.openexcel.com
> 
>
> On Nov 16, 6:08 pm, Mike Magill  wrote:
>
>
>
> > I have a macro that copies a large range of cells that contains a
> > mixture of cells with values and text and other cells with formulae.
>
> > I want to copy this range into a new workbook using VBA but I can't
> > seem to retain the formulae (which are converted to their values). I'm
> > sure there is a simple solution but I'm struggling to find it.
>
> > I've tried two ways that don't work so far and included snippets from
> > my macro below to show you what I've tried:
>
> > Attempt 1:
>
> > NWR.Range("A6:CN" & LastRow_NWR).Copy RR.Range("A" & LastRow_RR + 1 &
> > ":CN" & LastRow_RR + LastRow_NWR - 5)
>
> > Attempt 2:
>
> > Data1 = NWR.Range("A6:CN" & LastRow_NWR)
> > RR.Range("A" & LastRow_RR + 1 & ":CN" & LastRow_RR + LastRow_NWR - 5)
> > = Data1
>
> > Can anyone help?- Hide quoted text -
>
> - Show quoted text -

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Re: VBA Copying range of cells from one workbook to another while retaining the formulae

[Ashish Jain]

Hi Mike,


Try this:
RR.Range("A" & LastRow_RR + 1 & ":CN" & LastRow_RR + LastRow_NWR -
5).Formula
 = NWR.Range("A6:CN" & LastRow_NWR).Formula


Thanks & Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com


On Nov 16, 6:08 pm, Mike Magill  wrote:
> I have a macro that copies a large range of cells that contains a
> mixture of cells with values and text and other cells with formulae.
>
> I want to copy this range into a new workbook using VBA but I can't
> seem to retain the formulae (which are converted to their values). I'm
> sure there is a simple solution but I'm struggling to find it.
>
> I've tried two ways that don't work so far and included snippets from
> my macro below to show you what I've tried:
>
> Attempt 1:
>
> NWR.Range("A6:CN" & LastRow_NWR).Copy RR.Range("A" & LastRow_RR + 1 &
> ":CN" & LastRow_RR + LastRow_NWR - 5)
>
> Attempt 2:
>
> Data1 = NWR.Range("A6:CN" & LastRow_NWR)
> RR.Range("A" & LastRow_RR + 1 & ":CN" & LastRow_RR + LastRow_NWR - 5)
> = Data1
>
> Can anyone help?

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Salary sending problem

[Ankit Agrawal]

Hello Sir,

I have a problem related to mail through excel. basically I have to make
salary slip. and forward it to the employees. I manage the data into the
excel and use mail merge in MS word. now the problem is, I have to make
separate file for each employee and have to send one by one on their e-mail
id.

Question

1- Is any way that we can make separately file automatically and send to it
mail automatically to each employee.
2- is any way that every file having its own password and its password would
be employee DOB or their PAN may be any other key

Here  I am sending you sample file so please illustrate it because I am new
in the excel and don't know much more about other computer software & tools


Thanks & regards
Ankit

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts


salary Slip(2).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet


pay  October 2010 format(2).docx
Description: application/vnd.openxmlformats-officedocument.wordprocessingml.document

$$Excel-Macros$$ VBA Copying range of cells from one workbook to another while retaining the formulae

[Mike Magill]

I have a macro that copies a large range of cells that contains a
mixture of cells with values and text and other cells with formulae.

I want to copy this range into a new workbook using VBA but I can't
seem to retain the formulae (which are converted to their values). I'm
sure there is a simple solution but I'm struggling to find it.

I've tried two ways that don't work so far and included snippets from
my macro below to show you what I've tried:

Attempt 1:

NWR.Range("A6:CN" & LastRow_NWR).Copy RR.Range("A" & LastRow_RR + 1 &
":CN" & LastRow_RR + LastRow_NWR - 5)

Attempt 2:

Data1 = NWR.Range("A6:CN" & LastRow_NWR)
RR.Range("A" & LastRow_RR + 1 & ":CN" & LastRow_RR + LastRow_NWR - 5)
= Data1

Can anyone help?

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ AutoSaveAs

[Paul Schreiner]

You can create a BeforeClose event in which you save the file before exiting.

To do it yourself,
first, record a macro in which you do a SaveAS (specify file)
Then, in the VBA editor, choose the Thisworkbook module.
In the upper left pull-down, select Workbook
in the upper right pull-down, select BeforeClose

This will create a blank macro:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
End Sub

Next, create varables to "collect" your file name
and add the portion that you recorded.
Replace your sample file name with your "captured" name.

In Excel 2007 it could look like:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
    Dim NewName, CurName
    NewName = Sheets("Sheet1").Range("G7").Value
    CurName = ActiveWorkbook.FullName
    If (UCase(NewName) = UCase(CurName)) Then
    ActiveWorkbook.Save
    Else
    ActiveWorkbook.SaveAs Filename:=NewName, _
  FileFormat:=xlExcel12, _
  CreateBackup:=False
    End If
End Sub

good luck,

Paul


- Original Message 
> From: enquirer 
> To: MS EXCEL AND VBA MACROS 
> Sent: Mon, November 15, 2010 1:34:10 PM
> Subject: $$Excel-Macros$$ AutoSaveAs
> 
> Hello All
> I would like to create a macro that will save the current workbook to
> a subfolder on a mapped network drive (z:\master\CB), with a filename
> the same as the contents of cell G7 (an autogenerated number).
> I would like to automate this as much as possible, so if it can be
> done automatically when the user closes the form, that would be great,
> but if not, then I can create a button and attach the macro.  I
> already have a print button, so I could incorporate the save as well
> and call it Print & Save.  I would also like to create a button, that
> when clicked, opens the folder z:\master\CB, so the user can view the
> files previously saved.
> I am a self taught newbie and this is my first Excel project, so any
> help will be much appreciated.  Most of what I've learnt so far, has
> been from reading posts in this group, so I thank you all for the help
> you've already provided without knowing.
> Thanks in advance for help with this new, specific requirement.
> enquirer
> 
> -- 
>--
>-
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links : 
>http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> 
> To post to this group, send email to excel-macros@googlegroups.com
> 
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
> 

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: Re: $$Excel-Macros$$ Problem in Salary Slip

[Ajay Varshney]

You can take idea from what I have done in the attached file.




On Tue, Nov 16, 2010 at 3:38 PM, Surendra wrote:

> Good After Noon Team,
>
> Still, Waiting for your response.
>
>
> Regards,
> Surnedra
>
>
> On Mon, 15 Nov 2010 15:28:43 +0530 wrote
>
> >Hi Team,
> >
>
> >
> I need your help for calculating Last Working Date from attached format.
> >
>
> >
> As per policy below mention attendance legends count as a working day
> >
> P Present
> >
> HD Half Day
> >
> COD Comp Off Due
> >
> PL Privilege Leave
> >
> CL Casual Leave
> >
> SL Sick Leave
> >
> LP Loss Of Pay
> >
> ML Maternity Leave
> >
> O Weekly Off
> >
> CO Comp Off
> >
> UL Unplanned Leave
> >
> H Fixed Holiday
> >
> FH Floating Holiday
> >
>
> >
> and
> >
>
> >
> A Abconding
> >
> RD Ramp Down
> >
> R Desired Exit
> >
> UR Undesired Exit
> >
>
> >
> Above legends mark for inactive cases.
> >
>
> >
> **I Send you a file with example please help me for this.
> >
>
> >
> Trust me you are doing great JOB 
> >
>
> >
> Regards,
> >
> Surendra
>
> Regards,
> >
>
> >
> Surendra Singh
> >
> 9301334795
>
>
>
> Regards,
>
> Surendra Singh
> 9301334795
>
> 
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts


Last_Working_Date(1).xls
Description: MS-Excel spreadsheet

Re: Re: $$Excel-Macros$$ Problem in Salary Slip

[Surendra]

Good After Noon Team,

Still, Waiting for your response.


Regards,
Surnedra


On Mon, 15 Nov 2010 15:28:43 +0530  wrote
>Hi Team,
>

>
I need your help for calculating Last Working Date from attached format.
>

>
As per policy below mention attendance legends count as a working day
>
P Present
>
HD Half Day 
>
COD Comp Off Due
>
PL Privilege Leave
>
CL Casual Leave
>
SL Sick Leave
>
LP Loss Of Pay
>
ML Maternity Leave
>
O Weekly Off
>
CO Comp Off
>
UL Unplanned Leave
>
H Fixed Holiday
>
FH Floating Holiday
>

>
and 
>

>
A Abconding
>
RD Ramp Down
>
R Desired Exit
>
UR Undesired Exit
>

>
Above legends mark for inactive cases.
>

>
**I Send you a file with example please help me for this.
>

>
Trust me you are doing great JOB 
>

>
Regards,
>
Surendra

Regards,
>

>
Surendra Singh
>
9301334795



Regards,

Surendra Singh
9301334795

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts


Last_Working_Date.xls
Description: Binary data

$$Excel-Macros$$ Re: Grouping 20 ppl in 4 groups with 5 ppl in each, and repeat this 5 times - aim for as few repeats as possible..

[anandydr]

Hi,

In case you are using Excel 2007 or can use Analysis ToolPac you can
use =randbetween (lower_limit, upper_limit)  with 1 as lower and 5 as
upper limit. Otherwise you can use =int(rand( )*100) to generate
random integers then divide the numbers by 2, 3, 4, 5, and 6 and
select people based on the result, like if prime no select or if even
no select.

Hope that helps,
Regards,
Anand

On Nov 14, 11:26 pm, Beanbag  wrote:
> Hi,
>
> I have 20 ppl that i need to put in 4 groups with 5 each:
>
> First time
> Group 1: 1,2,3,4,5
> Group 2: 6,7,8,9,10
> Group 3: 11,12,13,14,15
> Group 4: 16,17,18,19,20
>
> The next week i want to form 4 new groups. However aiming to have as
> few ppl working together with ppl that they were in group with
> previously.
>
> And the following week same issue. New groups, as few repeats as
> possible.
>
> I have been able to do a lookup-matrix that can tell me how will i am
> doing with the ambition of no repeats.
> However, as i am not doing very well, i was wondering if it was
> possible to do an automatic allocation of ppl based on the few simple
> rules above?
>
> Is it?
>
> br
> Thomas

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

RE: $$Excel-Macros$$ VBA Code Required

[shrinivas shevde]

Dear Members
Please Help me I am waiting for reply

shrinivas


 


Date: Fri, 12 Nov 2010 13:09:02 +0530
Subject: $$Excel-Macros$$ VBA Code Required
From: shrinivas...@gmail.com
To: excel-macros@googlegroups.com


Dear All
Can Anyone help me for following problem.
I want to compare 2 column (which are in different different file).
Example, Consider File "A" and File "B" I want to compare column of (File A 
,sheet 1, column X) to (File B, sheet 2, Column Y)
There are chances that in (File A ,sheet 1, column X) there are 25 items and in 
 (File B, sheet 2, Column Y) there are only 21 items then balance 4 items 
should get highlight .
I want VBA code which will do following thing.
Ask me the file ,ask me the sheet and aske me the column to be compare
then compare the column and highlight 
-- 
Shrini

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

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
  

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Intercompany reconciliation

[Jagadeesh B S]

Hello friends,

I need to prepare Intercompany reconciliation for my company which
includes around 60-70 a/c’s of our intercompany transactions, if
anyone doing same kind of job or anyone knowing nice way of doing.
Please help me in doing this reconciliation report and understand it
better.

Thank you
Jagadeesh B S

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts