+ Reply to Thread
Results 1 to 1 of 1

"Invoice" workbook with several seved names to inform D. N or packing list workbooks

  1. #1
    Registered User
    Join Date
    02-25-2016
    Location
    GREECE
    MS-Off Ver
    2013
    Posts
    1

    "Invoice" workbook with several seved names to inform D. N or packing list workbooks

    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?
    Last edited by Fotis.vas; 02-25-2016 at 01:35 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 01-22-2016, 09:21 AM
  2. [SOLVED] Help with formula, if cell A1 = "name" vlookup then add inform to D1
    By Excelnoub in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-03-2014, 03:53 PM
  3. [SOLVED] Invoice "Current" or "Overdue" (but need "Paid" option)
    By rwatson in forum Excel General
    Replies: 5
    Last Post: 04-05-2012, 12:16 PM
  4. Replies: 0
    Last Post: 01-04-2006, 06:55 PM
  5. use variable in Workbooks("book1").Worksheets("sheet1").Range("a1"
    By Luc in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-28-2005, 04:05 PM
  6. Backup to specific folder if workbook names begins with "NSR" or "MAC"
    By GregR in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-05-2005, 08:06 PM
  7. [SOLVED] opening worksheet is "packing list"
    By usrofc in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-24-2005, 04:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1