Create Database in Excell

[Guest]

Hi

I looking to create a database in excel, based on a number of grouped fields that are spread in several excel documents & worksheets. The goodsnews is that the structure & the description of the fields is identical (only the variable next to the fiel
changes) but the location in a sheet can differ

ie. of a block (= group of fields)

Titel: Analyse data too
Status: starte
Responsible Person: Joh
Field: variabl

note: one document is composed of several sheets and each sheet can contain serveral of blocks (= grouped fields
Also, links are not a option because this reduces the flexiblity of the document

Many thank
Frank

 

[Trevor Shuttleworth]

Frank

not sure exactly what you want to do but it sounds like VLOOKUP is the thing
you need. I suggest you have a "master" sheet containing the key field and
lookups to extract the information from the other sheets.

Regards

Trevor

Hi,

I looking to create a database in excel, based on a number of grouped

fields that are spread in several excel documents & worksheets. The
goodsnews is that the structure & the description of the fields is identical
(only the variable next to the field

changes) but the location in a sheet can differ.

ie. of a block (= group of fields) :

Titel: Analyse data tool
Status: started
Responsible Person: John
Field: variable

note: one document is composed of several sheets and each sheet can

contain serveral of blocks (= grouped fields)