|re: "when no one said anything, I took that to mean that no one with any VBA experience could help."|
It probably just means that no one with VBA experience had the time right then and there to respond. We're all just volunteers here and dedicating a large amount of time to a question only happens when someone has the time.
Linking is really nothing more than a formula:
- Links within a sheet:
In B1 put =A1
- Links between sheets:
In Sheet1!B1 put =SHEET2!A1
- Links between workbooks:
In '[Book1.xlsx]Sheet1'!$B$1 put ='[Book2.xlsx]Sheet1'!$A$1
If Book2.xlsx is open, you'll see ='[Book2.xlsx]Sheet1'!$A$1 in the cell.
If Book2 is closed, you'll see something like:
='C:\Documents and Settings\DerbyDad03\My Documents\[Book2.xlsx]Sheet1'!$A$1
In other words, Excel will add the complete path to the file.
- You can even use functions across linked workbooks:
e.g. in Book2, you could use this to VLOOKUP something in Book3:
If you close Book3, Excel will add the path to the file within the function.
- You don't have to type the "link", you can type the equal sign and then click in the cell on the other sheet or in the other workbook and Excel will put the correct syntax in the cell.
I hope that helps.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.