How do I get users to fill out excel spreadsheet sequentially

[DD]

I am trying to get users to enter all required fields. How do I stop users
from not filling out a required field

[robert111]

write an if statement that tests all your fields, and if any one is blank, display a banner saying YOU HAVE ONE OR MORE FIELDS STILL TO COMPLETE

[Dave Peterson]

I use an adjacent cell with a formula like:

=if(a1<>"","","<-- Must be filled in!")

And I make it big bright bold red.



DD wrote:
>
> I am trying to get users to enter all required fields. How do I stop users
> from not filling out a required field

--

Dave Peterson

[DD]

Thank you that worked well

"robert111" wrote:

>
> write an if statement that tests all your fields, and if any one is
> blank, display a banner saying YOU HAVE ONE OR MORE FIELDS STILL TO
> COMPLETE
>
>
> --
> robert111
> ------------------------------------------------------------------------
> robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
> View this thread: http://www.excelforum.com/showthread...hreadid=558766
>
>

[DD]

Thank you - worked brilliantly

"Dave Peterson" wrote:

> I use an adjacent cell with a formula like:
>
> =if(a1<>"","","<-- Must be filled in!")
>
> And I make it big bright bold red.
>
>
>
> DD wrote:
> >
> > I am trying to get users to enter all required fields. How do I stop users
> > from not filling out a required field
>
> --
>
> Dave Peterson
>

[Gord Dibben]

And if they choose to ignore the warning..........what then?


Gord Dibben MS Excel MVP

On Thu, 6 Jul 2006 23:31:01 -0700, DD <[email protected]> wrote:

>Thank you - worked brilliantly
>
>"Dave Peterson" wrote:
>
>> I use an adjacent cell with a formula like:
>>
>> =if(a1<>"","","<-- Must be filled in!")
>>
>> And I make it big bright bold red.
>>
>>
>>
>> DD wrote:
>> >
>> > I am trying to get users to enter all required fields. How do I stop users
>> > from not filling out a required field
>>
>> --
>>
>> Dave Peterson
>>

[Dave Peterson]

You scream at them!

Gord Dibben wrote:
>
> And if they choose to ignore the warning..........what then?
>
> Gord Dibben MS Excel MVP
>
> On Thu, 6 Jul 2006 23:31:01 -0700, DD <[email protected]> wrote:
>
> >Thank you - worked brilliantly
> >
> >"Dave Peterson" wrote:
> >
> >> I use an adjacent cell with a formula like:
> >>
> >> =if(a1<>"","","<-- Must be filled in!")
> >>
> >> And I make it big bright bold red.
> >>
> >>
> >>
> >> DD wrote:
> >> >
> >> > I am trying to get users to enter all required fields. How do I stop users
> >> > from not filling out a required field
> >>
> >> --
> >>
> >> Dave Peterson
> >>

--

Dave Peterson

[Gord Dibben]

Not in the enlightened corporate world I was working in for the past 15 years.

No punching, slapping, screaming, derogatory statements or any other non-PC
behaviour.

Employing the fruits of your sensitivity training, you gently point out that
they have not followed instructions quite as you wished and could they possibly,
if so inclined, fill out the required cells between breaks and attending group
hugs sessions.


I am soooooooooooooooo happy to be out of it.


Gord


On Fri, 07 Jul 2006 11:36:05 -0500, Dave Peterson <[email protected]>
wrote:

>You scream at them!
>
>Gord Dibben wrote:
>>
>> And if they choose to ignore the warning..........what then?
>>
>> Gord Dibben MS Excel MVP
>>
>> On Thu, 6 Jul 2006 23:31:01 -0700, DD <[email protected]> wrote:
>>
>> >Thank you - worked brilliantly
>> >
>> >"Dave Peterson" wrote:
>> >
>> >> I use an adjacent cell with a formula like:
>> >>
>> >> =if(a1<>"","","<-- Must be filled in!")
>> >>
>> >> And I make it big bright bold red.
>> >>
>> >>
>> >>
>> >> DD wrote:
>> >> >
>> >> > I am trying to get users to enter all required fields. How do I stop users
>> >> > from not filling out a required field
>> >>
>> >> --
>> >>
>> >> Dave Peterson
>> >>

[Dave Peterson]

You left out surfing the web!

Gord Dibben wrote:
>
> Not in the enlightened corporate world I was working in for the past 15 years.
>
> No punching, slapping, screaming, derogatory statements or any other non-PC
> behaviour.
>
> Employing the fruits of your sensitivity training, you gently point out that
> they have not followed instructions quite as you wished and could they possibly,
> if so inclined, fill out the required cells between breaks and attending group
> hugs sessions.
>
> I am soooooooooooooooo happy to be out of it.
>
> Gord
>
> On Fri, 07 Jul 2006 11:36:05 -0500, Dave Peterson <[email protected]>
> wrote:
>
> >You scream at them!
> >
> >Gord Dibben wrote:
> >>
> >> And if they choose to ignore the warning..........what then?
> >>
> >> Gord Dibben MS Excel MVP
> >>
> >> On Thu, 6 Jul 2006 23:31:01 -0700, DD <[email protected]> wrote:
> >>
> >> >Thank you - worked brilliantly
> >> >
> >> >"Dave Peterson" wrote:
> >> >
> >> >> I use an adjacent cell with a formula like:
> >> >>
> >> >> =if(a1<>"","","<-- Must be filled in!")
> >> >>
> >> >> And I make it big bright bold red.
> >> >>
> >> >>
> >> >>
> >> >> DD wrote:
> >> >> >
> >> >> > I am trying to get users to enter all required fields. How do I stop users
> >> >> > from not filling out a required field
> >> >>
> >> >> --
> >> >>
> >> >> Dave Peterson
> >> >>

--

Dave Peterson

[robert111]

In the spirit of contributions so far, test if they have complied with your wishes, ie are any cells blank, and if so, automatically send an e-mail asking them to fill out all outstanding fields, AND COPY THIS TO THEIR BOSS. If no improvement, next time ALSO COPY TO BOSS'S BOSS. Calculate how much this rework is costing in dollars, and send an E-mail to the Financial Vice-President. Update your resume / CV just in case.

Robert