Moving data from another workbook

Hi Mandy, thanks for your query. You could code your links into a worksheet so cells end up dynamically linked to cells in another workbook, but remember the "=" operator acts in its mathematical sense in code, so you can't just use it in the same sense as we do when working directly onto the worksheet. To use "=", you'd set (say) cell A1 to be the formula "=[myexcel.xls]Sheet1!G10". Essentially, you are coding the manual entry of link into a cell.

Hope this helps,

Anthony