Excell relasionship

[msi_1985]

Dear Sir.
i am irsath. i have been worikng in Saudi arabia. i am computer operator Mastoura company.
i don't have skills about access. i have been following my company employees data list on the excell sheet, i have 4 type of employee list, so i am following separate sheet for each type of employee. and i am following all employee list on one sheet.

my quetions.
* i would like to make relashionship with all sheet ( each employee list)

 

[HaHoBe]

Hi, msi_1985,

VLookup could proove to be one way for finding the Data from all sheets to one summary (esp. if an individual personal number has been given to each employee and this unique number is placed to the far left of the data). Otherwise Match and Index could be helpful.

Both ways would make it necessary to fill in formulas into the summary sheet. With the addition of IsError only data could be filled as far as the employee list really goes (while the formulas go furter).

There is a way with VBA too - copy all data form all sheets and apply them to a summary (maybe see Combine All Worksheets into One at the VBA Express Knowledge Base for code) for - if this is not possible - report if this code may be of interest.

HTH,
Holger

 

[mdjks]

Holger,
Thank you for the link to VBA express, looks like it will be a very helpful new resource.