I have several different xls with multiple worksheets in each I have written the report that generates the data but I must manually go into each field and change the worksheet reference each time the sheet changes.
Could I have an additional colum which specifies which sheet to pull data from? Then in each function sepecifiying how to create the value needed the worksheet referance updates too.
Let me know if I need to clarify.
Bookmarks