0

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

www.stefringoot.com

flag

2 Answers

0

Greetings to Holland.

Yes this is possible although I am not sure that the listing in table 3 can be done. It is possible to see the total of each category.

I have loaded a file called Transactions on the spreadsheet area of my apple home site type this in your browser.

http://public.me.com/dbp_1999

The Password is Allmec

Then Navigate to the spreadsheet folder.

I hope that is what you were looking for.

Kind Regards Allmec

link|flag
0

Thanks a lot Allmec....

I have downloaded the file and will now try to embed in in my other file I let you know the result.... give me a few day's...

greetings stef

link|flag

Your Answer

Get an OpenID
or

Not the answer you're looking for? Browse other questions tagged or ask your own question.