I'm trying to find the value in the last cell of a row using VLOOKUP to determine the range (row). I don't know the column offset VLOOKUP needs to find the column as it is dynamic. It is a status report where each update is added to the row's next column. I need to get the result from the last...
I have a workbook (WSWD) with the same page copied to multiple tabs. A new tab for each week to track weather and construction days left in the project. I label each tab 03-02-2013_41-PE followed by 03-09-2013_42-PE, etc. I have another workbook (RE Weekly) I need to copy cell data from WSWD. It...