LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 61
Default Data from other files & Match?

Hi to all
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cross match data in Col A v/s Col B and display match in Col 3 aquaflow Excel Discussion (Misc queries) 3 July 10th 08 05:07 PM
match item in 2 excel files [email protected] Excel Discussion (Misc queries) 0 April 25th 08 03:38 AM
how do I match data from two separate files in excel roger f brennan Excel Discussion (Misc queries) 4 February 13th 08 12:11 AM
Match 10 xls files Tom Lemmens Excel Discussion (Misc queries) 0 October 26th 05 08:10 AM
index,match,match on un-sorted data Brisbane Rob Excel Worksheet Functions 3 September 24th 05 10:04 PM


All times are GMT +1. The time now is 11:11 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"