Prev: Correcting a typo in large value list
Next: Un-Provision Project Server Web Access
From: Jack Dahlgren MVP on 9 Mar 2010 15:43
Proj 2003 may have that limitation...

How about just creating a custom field and value list?

-Jack

"Val" <Val(a)discussions.microsoft.com> wrote in message
news:486A499F-328A-40EA-987B-0D1BF26F8FEB(a)microsoft.com...
> Project 2003
> I right-click the column header - select customize fields, then select
> value list. It appears that I can only cut/delete a row from the value
> list
> one at a time. I'd like to delete 200 rows all at once instead of line by
> line.
>
>
>
> "Jack Dahlgren MVP" wrote:
>
>> Which version of MS Project?
>> In Proj 2007 right-click a column header - select customize fields, then
>> click the lookup value button.
>>
>>
>> "Val" <Val(a)discussions.microsoft.com> wrote in message
>> news:B3D0D4CA-9891-44BD-BA85-BF16E0997AE4(a)microsoft.com...
>> > Tried that - it didn't work :(
>> >
>> > I'm inside the value list dialog box so I'm thinking that is the
>> > problem.
>> > Is there somewhere else that I can go to edit the value list?
>> >
>> > thanks.
>> >
>> > "Jack Dahlgren MVP" wrote:
>> >
>> >> Select first item by clicking. Scroll down. Hold shift key and click.
>> >> The
>> >> entire set of items between those two points will be selected.
>> >>
>> >> -Jack
>> >>
>> >> "Val" <Val(a)discussions.microsoft.com> wrote in message
>> >> news:5CD4F05B-CCE6-4D90-9B94-7FD94AEEE753(a)microsoft.com...
>> >> > How do I cut all 200 rows at once? I don't really want to do it one
>> >> > at
>> >> > a
>> >> > time.
>> >> >
>> >> > Thanks.
>> >> >
>> >> > "Jack Dahlgren MVP" wrote:
>> >> >
>> >> >> Yes. Select then click on the cut icon. Try it.
>> >> >>
>> >> >> -Jack Dahlgren
>> >> >>
>> >> >> "Val" <Val(a)discussions.microsoft.com> wrote in message
>> >> >> news:6596A51E-9C60-46A4-B9AB-AAB335A92906(a)microsoft.com...
>> >> >> > Is there a way to delete multiple rows in a value list for a Text
>> >> >> > column?
>> >> >> > I
>> >> >> > have over 200 rows out of a value list that are duplicates that I
>> >> >> > need
>> >> >> > to
>> >> >> > delete. I can delete them row by row but I'd like to click on
>> >> >> > the
>> >> >> > 1st
>> >> >> > row
>> >> >> > and shift click on the last row that needs to deleted. Is this
>> >> >> > possible?
>> >> >> >
>> >> >> > Thanks in advance (from a Project newbie)
>> >> >>
>> >> >> .
>> >> >>
>> >> .
>> >>
>> .
>>
From: Val on 9 Mar 2010 16:30
How about a new approach? Is there a way I can delete the entire value list
without going thru it row by row. I tried to start with Gerard's Visual
Basic script but I'm not that good at VB. So I just want to delete the
entire value list and then start from scratch.

"Jack Dahlgren MVP" wrote:

> Proj 2003 may have that limitation...
>
> How about just creating a custom field and value list?
>
> -Jack
>
> "Val" <Val(a)discussions.microsoft.com> wrote in message
> news:486A499F-328A-40EA-987B-0D1BF26F8FEB(a)microsoft.com...
> > Project 2003
> > I right-click the column header - select customize fields, then select
> > value list. It appears that I can only cut/delete a row from the value
> > list
> > one at a time. I'd like to delete 200 rows all at once instead of line by
> > line.
> >
> >
> >
> > "Jack Dahlgren MVP" wrote:
> >
> >> Which version of MS Project?
> >> In Proj 2007 right-click a column header - select customize fields, then
> >> click the lookup value button.
> >>
> >>
> >> "Val" <Val(a)discussions.microsoft.com> wrote in message
> >> news:B3D0D4CA-9891-44BD-BA85-BF16E0997AE4(a)microsoft.com...
> >> > Tried that - it didn't work :(
> >> >
> >> > I'm inside the value list dialog box so I'm thinking that is the
> >> > problem.
> >> > Is there somewhere else that I can go to edit the value list?
> >> >
> >> > thanks.
> >> >
> >> > "Jack Dahlgren MVP" wrote:
> >> >
> >> >> Select first item by clicking. Scroll down. Hold shift key and click.
> >> >> The
> >> >> entire set of items between those two points will be selected.
> >> >>
> >> >> -Jack
> >> >>
> >> >> "Val" <Val(a)discussions.microsoft.com> wrote in message
> >> >> news:5CD4F05B-CCE6-4D90-9B94-7FD94AEEE753(a)microsoft.com...
> >> >> > How do I cut all 200 rows at once? I don't really want to do it one
> >> >> > at
> >> >> > a
> >> >> > time.
> >> >> >
> >> >> > Thanks.
> >> >> >
> >> >> > "Jack Dahlgren MVP" wrote:
> >> >> >
> >> >> >> Yes. Select then click on the cut icon. Try it.
> >> >> >>
> >> >> >> -Jack Dahlgren
> >> >> >>
> >> >> >> "Val" <Val(a)discussions.microsoft.com> wrote in message
> >> >> >> news:6596A51E-9C60-46A4-B9AB-AAB335A92906(a)microsoft.com...
> >> >> >> > Is there a way to delete multiple rows in a value list for a Text
> >> >> >> > column?
> >> >> >> > I
> >> >> >> > have over 200 rows out of a value list that are duplicates that I
> >> >> >> > need
> >> >> >> > to
> >> >> >> > delete. I can delete them row by row but I'd like to click on
> >> >> >> > the
> >> >> >> > 1st
> >> >> >> > row
> >> >> >> > and shift click on the last row that needs to deleted. Is this
> >> >> >> > possible?
> >> >> >> >
> >> >> >> > Thanks in advance (from a Project newbie)
> >> >> >>
> >> >> >> .
> >> >> >>
> >> >> .
> >> >>
> >> .
> >>
> .
>
From: Val on 9 Mar 2010 17:56
OK, I figured out a way to get rid of the bad data. I have a project that
has a clean ValueList and if I use "Import Custom Field" from the Customize
Field form then the imported value list writes over my existing value list
where if I used the "Import Value List" from the Value list form then it
appends the list to the existing list.

Thanks for offering help.

"Val" wrote:

> Is there a way to delete multiple rows in a value list for a Text column? I
> have over 200 rows out of a value list that are duplicates that I need to
> delete. I can delete them row by row but I'd like to click on the 1st row
> and shift click on the last row that needs to deleted. Is this possible?
>
> Thanks in advance (from a Project newbie)
From: Jack Dahlgren MVP on 10 Mar 2010 13:48
I think Proj2003 had a function to import a lookup table. Try importing a
blank one from another project.

-Jack

"Val" <Val(a)discussions.microsoft.com> wrote in message
news:1C4EE682-2FCA-4933-BB05-4F72AAADDD72(a)microsoft.com...
> How about a new approach? Is there a way I can delete the entire value
> list
> without going thru it row by row. I tried to start with Gerard's Visual
> Basic script but I'm not that good at VB. So I just want to delete the
> entire value list and then start from scratch.
>
> "Jack Dahlgren MVP" wrote:
>
>> Proj 2003 may have that limitation...
>>
>> How about just creating a custom field and value list?
>>
>> -Jack
>>
>> "Val" <Val(a)discussions.microsoft.com> wrote in message
>> news:486A499F-328A-40EA-987B-0D1BF26F8FEB(a)microsoft.com...
>> > Project 2003
>> > I right-click the column header - select customize fields, then select
>> > value list. It appears that I can only cut/delete a row from the value
>> > list
>> > one at a time. I'd like to delete 200 rows all at once instead of line
>> > by
>> > line.
>> >
>> >
>> >
>> > "Jack Dahlgren MVP" wrote:
>> >
>> >> Which version of MS Project?
>> >> In Proj 2007 right-click a column header - select customize fields,
>> >> then
>> >> click the lookup value button.
>> >>
>> >>
>> >> "Val" <Val(a)discussions.microsoft.com> wrote in message
>> >> news:B3D0D4CA-9891-44BD-BA85-BF16E0997AE4(a)microsoft.com...
>> >> > Tried that - it didn't work :(
>> >> >
>> >> > I'm inside the value list dialog box so I'm thinking that is the
>> >> > problem.
>> >> > Is there somewhere else that I can go to edit the value list?
>> >> >
>> >> > thanks.
>> >> >
>> >> > "Jack Dahlgren MVP" wrote:
>> >> >
>> >> >> Select first item by clicking. Scroll down. Hold shift key and
>> >> >> click.
>> >> >> The
>> >> >> entire set of items between those two points will be selected.
>> >> >>
>> >> >> -Jack
>> >> >>
>> >> >> "Val" <Val(a)discussions.microsoft.com> wrote in message
>> >> >> news:5CD4F05B-CCE6-4D90-9B94-7FD94AEEE753(a)microsoft.com...
>> >> >> > How do I cut all 200 rows at once? I don't really want to do it
>> >> >> > one
>> >> >> > at
>> >> >> > a
>> >> >> > time.
>> >> >> >
>> >> >> > Thanks.
>> >> >> >
>> >> >> > "Jack Dahlgren MVP" wrote:
>> >> >> >
>> >> >> >> Yes. Select then click on the cut icon. Try it.
>> >> >> >>
>> >> >> >> -Jack Dahlgren
>> >> >> >>
>> >> >> >> "Val" <Val(a)discussions.microsoft.com> wrote in message
>> >> >> >> news:6596A51E-9C60-46A4-B9AB-AAB335A92906(a)microsoft.com...
>> >> >> >> > Is there a way to delete multiple rows in a value list for a
>> >> >> >> > Text
>> >> >> >> > column?
>> >> >> >> > I
>> >> >> >> > have over 200 rows out of a value list that are duplicates
>> >> >> >> > that I
>> >> >> >> > need
>> >> >> >> > to
>> >> >> >> > delete. I can delete them row by row but I'd like to click on
>> >> >> >> > the
>> >> >> >> > 1st
>> >> >> >> > row
>> >> >> >> > and shift click on the last row that needs to deleted. Is
>> >> >> >> > this
>> >> >> >> > possible?
>> >> >> >> >
>> >> >> >> > Thanks in advance (from a Project newbie)
>> >> >> >>
>> >> >> >> .
>> >> >> >>
>> >> >> .
>> >> >>
>> >> .
>> >>
>> .
>>
First  |  Prev  | 
Pages: 1 2 3
Prev: Correcting a typo in large value list
Next: Un-Provision Project Server Web Access