Each week I receive various weekly reports on separate spread sheets which I save in to different folders and Id the report with name and Week number. I wan to take specific information from each report and put on a summary report showing changing data by week as we go through the year. I set this up for past weeks using a vlookup which works fine, but how can I put the vlookup formulas in now for files that do not yet exist in the folder? Of course I can just drag down the formula each week and use find and replace to change the week number in the formula but this is too time consuming. Is there a better way of doing this??
Last edited:
