Can someone explain to me how I can turn "Kanoodle" and "012605" into referenced cells (from a different workbook, obviously) in this formula?
Thank you in advance.
I figured something like this would do the trick, but I'm not too familiar with Excel:='[AllTime-KanoodleROI-012605.xls] Summary'!$E$7
Apparently, it's harder to break text out of a formula than it is in PHP :x.='[AllTime-', 'Kanoodle', 'ROI-', '012605', '.xls] Summary'!$E$7
Thank you in advance.