Automatically filling fields

  • Thread starter Thread starter denisecook
  • Start date Start date
D

denisecook

This one is kind of difficult to explain so I'll try to do a tex
example.

I have a form for supervisors that asks for personal data like name
location, dept no., phone, and then the supervisor must list all o
their employees below. This information dumps into a Master workshee
so you end up with several records of employees but the supervisor inf
is only appearing once. For each employee record to be complete an
sortable, it needs to have this supervisor info included in thei
record, i.e., appearing in the same row. I'm getting something lik
this:

sup name sup phone emp name emp phone emp shift
JACKSON 999-9999 BROWN 999-9999 1st
WILSON 999-9999 2nd
EDWARDS 999-9999 3rd

So you see, the supervisor data needs to also replicate into the othe
fields somehow because if I sort by supervisor, Wilson and Edward
won't have one.

Without manually doing a copy/paste, is there anyway I can tell Exce
to duplicate this info if a name appears in emp_name, or better yet, i
there are 25 employees in this area, then duplicate sup_name 25x?
don't know what to do here! :
 
Hi
try the following:
- select your range with the supervisor name
- hit F5
- click 'Special' and choose 'Blank/Empty cells')
- enter the equation sign '=' and hit the upper arrow
- hit CTRL+ENTER
 
Hi

Select the range of emp name - excluding the heading. Edit / Go to / Blanks.
This will select all of the lines that do not have an entry. Hit = and then
the up arrow. Then hit Ctrl Enter. This will fill in each blank with the
name above - until it reaches another name - and so on.

Once this has been done - and you are happy with it - select the whole
column of entries and Copy / Paste Special / Values to fix the values in
place.
 
Back
Top