Hi

Im after some help with a macro as im not the best when it comes to VBA. i
also get the reply from Tom Ogilvy he said it may be possilbe with macro.

I want to maintain a master listing and accept input and provide output in
4 separate workbooks.

I am creating a Job Card file for my co., where I have 35 fields. Where as
field no. 1 & 2 are very important and other field are to fill base on that
field. This 33 fields are distributed between 4 department.
1. Marking 2.Production 3. Q.A. Dept.& 4 Store dept.

What I want is there is any way that all 4 department will entry the data
from deferent file and it store into one file in there respective field and
no one can see any dept. data. All can see only "first 2 filed" and fill
their information.(there may be more data on same job card no. and jobcardno
are uniqe)

i have filed like...

a1=JobCardNo.
b1=Party Name,

From c1 to q1 for Marking dept. fields
From r1 to ad1 for Production dept. fields
from ae1 to ag1 for q.a. dept.
and
from ai1 to aj1 for store dept.

Is there any helping? Thanks in advance.

Shah ****al