Hi folks,
Sorry for the bad English, but normally I speak dutch, so... I have a question;
Is it possible, in numbers, to create a list, for example
1001 computer
1002 software
1003 supply
1004 Machines
1005 goodwill
1006 credit
1007 sell
etc, etc, ....
and then use these numbers in another table (on another page) where it grabs a value an puts that value in a third table (again on another page)
for example I have a table with some info an a amount
jan 10 | bought a mac computer | 2500 Euro | ...
jan 17 | Bought software | 1550 euro | ...
jan 22 | sold some drawings | 750 euro | ...
jan 25 | bought a cd player | 100 Euro | ...
jan 25 | print ink | 25 Euro | ...
feb 01 | print ink | 25 Euro | ...
feb 13 | Bought software | 250 euro | ...
feb 22 | print ink | 25 Euro | ...
etc, etc
where the .... are I now want to put the code so it will look like
jan 10 | bought a mac computer | 2500 Euro | 1001
jan 17 | Bought software | 1550 euro | 1002
jan 22 | sold some drawings | 750 euro | 1007
jan 25 | bought a cd player | 100 Euro | 1001
jan 25 | print ink | 25 Euro | 1003
feb 01 | print ink | 25 Euro | 1003
feb 13 | Bought software | 250 euro | 1002
feb 22 | print ink | 25 Euro | 1003
so this should result in another table which should look like
1001 - 1002 - 1003 - 1004 - 1005 - 1006 - 1007
-----------------------------------------------
2500 - 1550 - 0025 - 0000 - 0000 - 0000 - 0750
0100 - 0250 - 0025 - 0000 - 0000 - 0000 - 0000
0000 - 0000 - 0025 - 0000 - 0000 - 0000 - 0000
-----------------------------------------------
2600 - 2800 - 0075 - 0000 - 0000 - 0000 - 0750
is this possible in numbers?
greetings from Holland