Could you upload a copy of your file, and post a *link* to it here in reply?
Think there's a need to see your actual set-up
One free filehost you could use:
http://www.flypicture.com/
Note: Pl do not post any attachments to the newsgroup.
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"lawmere" wrote in message
...
hi Max
It wont work for me when i tried to upload it it would not let me put
anything in F1 or maybe i didnt explain myself prperly am so sorry am just
panicking. will start again if you could help explain in a novice form
pls:
Worksheet 1 is called Master with all the stored information and is
designed
as follows
Name Sex Age Height Occupation Education Religion
Worksheet 2 is designed as an inspection sheet as follows:
Person Location Sex Areapostcode Attitude Height
now what i want to do is if i type in a person's name in worksheet 2 i
want
it to automatically fill in similar columns with worksheet1 i.e [Sex and
Height]
Regards
Lawrence