Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Use spreadsheet as data source
Hi,
We have two workbooks, Bk 1 contains information relating to production scheduling and manufacturing information. Bk2 is a template used to generate a ticket (workbook) containing specific information relating to the individual order. Is it possible to transfer information between the two. Eg on Bk1 there is a packing spec worksheets for items, what size outer to use, and how many items in that outer as well as other information, can we interrogate this (search by item code) and then "autofill" in cells marked "Outer" and "Number" in Bk2 (ticket). Thanks in advance Paul |
#2
|
|||
|
|||
It sounds as though you could use Advance Filter for this.
Take a look at http://www.contextures.com/xladvfilter01.html -- Regards Roger Govier "gibbylinks" wrote in message ... Hi, We have two workbooks, Bk 1 contains information relating to production scheduling and manufacturing information. Bk2 is a template used to generate a ticket (workbook) containing specific information relating to the individual order. Is it possible to transfer information between the two. Eg on Bk1 there is a packing spec worksheets for items, what size outer to use, and how many items in that outer as well as other information, can we interrogate this (search by item code) and then "autofill" in cells marked "Outer" and "Number" in Bk2 (ticket). Thanks in advance Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
Reference multiple cells in if statement | Excel Worksheet Functions | |||
Excel data query locks source file | Excel Discussion (Misc queries) | |||
Using Excel workbook as data source for word mailmerge | Excel Discussion (Misc queries) | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |