Using Excel, I am trying to link a column in one workbook to update daily to one cell in another workbook. The part I can not get to work is making the one cell automatically pull the current date value from the first workbook. I believe I need to use either an IF formula or a macro to tell the one cell to pull the column data next to today's date. Anyone understand/can help? Thanks!