I have different workbooks with names wo 1,wo 2,wo 3,....and so on,I need to
use the workbook name in a formula,like ='C:\My Folder\[wo 1.xls]Sheet1'!$H$5
is there a way that I could drag this formula down so it change the workbook
name to wo 2, then wo 3, and so on ?
Note: I have workbooks name wo 1 up to wo 1000 and its going up