Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking Data based on criteria
Hi
I would like to link data from my master workbook to 2 different workbooks depending on criteria. If there is a value in either issued, paid or receipted move name and column value to the workbook of the same name. Can it be done? Thanks Wendy Master workbook:- Type Name Post Issue Overdue Receipted Chq1 John Smith 10 10 PO Bill Jones 52 20 Cash Ted Green 80 80 chq2 John Smith 100 100 Issued, Overdue and Receipted Workbooks all contain these and also other fields. Name Total John Smith 10 Ted Green 80 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Retrieving data based on more than 1 criteria | Excel Worksheet Functions | |||
Help getting first column data based on criteria? | Excel Worksheet Functions | |||
Sum data based on 2 criteria | Excel Worksheet Functions | |||
Linking WorkBooks Based on Data Entered In One of Them | Excel Discussion (Misc queries) | |||
Linking data that contains specific row criteria | Excel Worksheet Functions |