WNGetz,
I modified the sample sheet you provided.
Create a directory on called
C:\test2
and place the files there.
If you are not limited by your original design and the use of merged cells
this may work for you.
When you open the "employee profile" sheet do not enter eny data in to your original form.
Click the button labled "A Simple Method".
this will launch a User Form where you can enter employee info.
Then click the "Write Record" button.
The employee info will be written to "On-Call List2" sheet to the proper sheets.
cplmckenzie
|