Recent content by pmsrefugee

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...

Between the =MID formula, Concanatate, and indirect plus this site http://www.cpearson.com/excel/sheetref.htm I was able to get it to reference the other workbook and match the new date when I add a new sheet to the end. Thank you very much!

I can't figure out the INDIRECT function. If I have both workbooks open, I would like to have one sheet reference a cell in the other workbook. But when I add a new sheet by copying to the end to each workbook and renaming the sheet tab with the new date I need the reference to update the sheet...

1. Each new sheet in numbered sequentially each week i.e., 41, 42, 43, etc 2. Yes, all the formulas in RE Weekly reference the same week in WSWD. That is why I though if we could match the date in the sheet tab, I could add a new sheet by copying the latest sheet to the end and changing the...

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...