Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Linking WorkBooks Based on Data Entered In One of Them
I have two WorkBooks. In WorkBook 'A', there is a field called 'keyfield1'.
In all other Workbooks in the same directory, there is a field called 'keyfield2'. I need to be able to enter a value in keyfield1, then based on that value, search through all WorkBooks (in the same file directory) for the same value in keyfield2, and use that relationship to link the unique Workbook that contains that value. 1) Can I do this without VB programming? How? 2) If I need to use VB, is there a script anywhere I can use to begin with? (I am not a VB programmer.) Thank you. George |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
eliminate data entered to a worksheet that copies to another work. | Excel Worksheet Functions | |||
Preserving data integrity in linked workbooks | Excel Discussion (Misc queries) | |||
IF statement based on data type | Excel Worksheet Functions | |||
Should Merging workbooks pick up new data or only edited data? | Excel Worksheet Functions | |||
Importing Data Into Formula Based Cells | Excel Worksheet Functions |