Re: move cell contents

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi Julie,
You are right about the duplicate names. Actually, I have several list to
pick from. I have a front page. It has 17 different locations I need names
to go into. Each list I randomly pick from has its own catogory. The
different catogories contain some of the same names. I need to pick a random
name from each catogory and not have them duplicate the same name within the
17 locations. If there is a vba code that can be written, I would appericate
the help and instructions own how to use the code within the work***.

Thanks again,
David L

"JulieD" wrote:

> Hi David
>
> a formula can only affect the cell it is in, it can't move or change another
> cell for this you need some code ...
>
> from what i gather you've got two lists from which you're picking random
> names, however, sometimes you get a duplicated name when you combine the
> results of the two lists and you don't want this to happen? if this is the
> case, i don't understand how moving a name from g5 to j5 will help?
>
> --
> Cheers
> JulieD
> check out www.hcts.net.au/tipsandtricks.htm
> ....well i'm working on it anyway
> "David L" <DavidL@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:560BAC3E-698C-499F-8332-F9735DD20863@xxxxxxxxxxxxxxxx
> > Is there a way to move a cell contents to another cell with a formula.
> > ex:
> > if a5="Name" then move g5 to j5? Also, I am using
> > =INDEX(Sheet1!B3:B12,INT((RAND()*10)+1),1) to pick random names from a
> > list.
> > I have the formula in different place pick random names from different
> > list.
> > This does work, but I have different list with some of the same names and
> > with the random pick I do not want the same name to appear.
> > --
> > Thanks for any and all help.
> > Davidl
>
>
>
.

Quantcast