Linking Text (Data) between worksheets

[Rizitsu]

I would assume this is possible, its just getting the right method fo
the problem,

Worksheet one has many fields of data, making a large worksheet, ther
are some fileds in the worksheet that are text only, and these tex
only fields can be long. Is it possible to link textual data fro
worksheet to worksheeet, (here's the catch) and when requested to prin
the data that relates to the original worksheet.

e.g. worksheet one has numerical data & textual data,

i want to remove the textual data,

so worksheet two has the textual data and worksheet one has th
numerical data.

I dont want to use M$access as i cannot perform Pivot table analysis o
the data. (Or can I?)

And if i can compile data together and print a selection of data the
it would suit more than its purpose.

Thanks in advance

 

[Frank Kabel]

Hi
first not really sure how your data looks like and how you want to
split it. you may provide more details.

BUT: you can do pivot analysis based on Access databases!

 

[Rizitsu]

Ok, great news about the Pivot table analysis.

Might have to try that out tommorow, in the mean time, the data i
represented in a way so that i have fields for different types acros
the top,

<-------------Worksheet One -------------------> |
<------ Worksheet Two ----->
[field 1][field 2][field 3][field 4*(2)][field 5*(3)][field 6*(4)] |
[field 2][field 3][field 4]
[ num ] [ num ] [ num ][ __text ][___text ][___text ] | [ text ]
text ][ text ]

In fields 4/5/6 (worksheet one) i will have a "Single String"
pointing to the fields 2/3/4 (worksheet two) The main text will be i
the second worksheet.

I will try and sort this problem out with Access, i can use Primary an
foreign keys then.

Thanks for the help Kabel

Ri