9 Replies Latest reply: Nov 30, 2012 6:48 AM by Wayne Contello
Roland nl Level 1 (0 points)

Hello, ( dutch i will try my best englisch   )

 

I have two spreadsheats.

 

1 Klanten bestand ( customers file )

1 Factuur  ( invoice )

 

When i put in the invoice the cusomer number i want to get out of cusomors file the adres.

 

I can do that whitin 1 spreadscheet but i need to do that whitin the two.

 

Now i have

 

=ZOEKEN(H10;Klantenbestand::Tabel 1 :: $A;Bedrijfsnaam) 

 

     could be in english 

               = LOOKUP (H10; client file :: Table 1 :: $ A; Company Name)

 

I think it should be somthing like

 

=ZOEKEN(H10; file location :: Klantenbestand::Tabel 1 :: $A;Bedrijfsnaam) 

         

     could be in english

               = LOOKUP (H10; file location :: client file :: Table 1 :: $ A; Company Name)

 

I cant find somting related whit google or in the forum.

 

Is there some one who knows how to ???

 

And i would like to work whit iCloud if posible....

  • Wayne Contello Level 6 (17,564 points)

    You cannot use Numbers refer to cells in another document in Numbers.  you can refer to cells in the same table, a different table or a different table in another sheet.

     

    You can combine the two documents into a single document where each resides in a different sheet.

  • Roland nl Level 1 (0 points)

    Whe i combine the documents i wil get one verry big file at the end of the year i gues.

     

    When i make over 200 invoices the file gets bigger and bigger.

     

    Whiting exel ( microsoft ) it is posible but i dont want to use the microsoft products anny more...

     

    anny other sugestions ???

  • Wayne Contello Level 6 (17,564 points)

    Use a free office clone like LibreOffice, NeoOffice or keep one years worth of information in the Nubers document.

  • Roland nl Level 1 (0 points)

    hmmm.

     

    and what did you meen with.. or keep one years worth of information in the Nubers document.

     

    Like copy het invoice every time i want to make a new one so i get a big file at the end...

     

     

    I have thought of that, but then i want to make a pdf of the worksheet Factuur, when i make a PDF he makes a pdf of the complete document and that is also not the meaning of it.

     

    Or can i make a pdf of one work sheet ??

  • Wayne Contello Level 6 (17,564 points)

    When you print to PDF you can select the "From" and "To" so that you just print a single page or a range of pages:

    Screen Shot 2012-11-30 at 8.11.34 AM.png

  • Roland nl Level 1 (0 points)

    Ok that helpt, i did it wiht export -> PDF ...

     

    Now the only iseu is the the iseu that cant be solved.

     

    He people of apple fix it please .....

     

    Wont work i tink but you never know, unsolved problems... i hope the dont like that

  • Wayne Contello Level 6 (17,564 points)

    Roland,

     

    You can provide feedback regarding Numbers to Apple by using the menu item "Numbers > Provide Numbers Feedback".  Posting on this forum has little chance of affecting any change.

     

    Best regards,

    Wayne

  • Roland nl Level 1 (0 points)

    Thanks, i will do that.

     

    If i get an awnser then i wil get back with it here !

  • Wayne Contello Level 6 (17,564 points)

    Roland,

     

    Please do not hold your breath waiting on an answer becuase of providing feedback.  You will turn blue in the face.  That's just my opinion.

     

    Regards,

    Wayne