Dear All
this is my problem .
I have an excel workbook with the format of an invoice and i want when i fill the cells with units the characteristics of the unit and the kilos to be informed another workbook wich will be named Delivery Note and Packing list.
The "invoice" Workbook will be saved every time with the "Invoice" No so i can not go to the workbook "packing list" and just give the cells that i want to be filled by "invoice" every time because every time that the "Invoice"will be saved with another No name the packing list will keep the previous data of the previous Invoice No.
For instance if i make an Invoice No02 by opening and modifying the No01 and save as No02 the cells of the Packing list01 that i want to be informed by the invoice such Units as =[Invoice01.xlsx]Sheet!$B$4, will keep the No01 datas
Any Idea how to solve this?
Bookmarks