Hi guys!
Im trying to combine data from multiple separate workbooks into a single cell in a third workbook.
I use the & to combine data from the same workbook but how can I use that to combine data from multiple separate workbooks?
Here is a sample of what I have to combine data from the same file...
=A1&" "&Sheet2!A1&" "&Sheet3!A1
Thanks for any help!
Ginger