R
Ron Bernstein
I have a sheet which has a row which gets updated with
summary data from a different workbook. This update
occurs each time I open my workbook, which has links to
the workbook with the summary data. I currently operate
by opening my workbook once each day to receive the
updated values.
In the same sheet where I am reading the summary data from
the other workbook, I want to read that summary data on a
daily basis and store the data on a separate row so that I
can accumulate trend data which I want to report.
Currently, I am using the current formula in each row to
check if it is today, and then writing the data read into
the current row. The problem is that the next day, I lose
the data which existed from the previous day.
Any suggestions would be appreciated.
Current Formula: =IF(A43 = TODAY( ), $G$26, #N/A) where
$G$26 has summary data from an external spreadsheet.
summary data from a different workbook. This update
occurs each time I open my workbook, which has links to
the workbook with the summary data. I currently operate
by opening my workbook once each day to receive the
updated values.
In the same sheet where I am reading the summary data from
the other workbook, I want to read that summary data on a
daily basis and store the data on a separate row so that I
can accumulate trend data which I want to report.
Currently, I am using the current formula in each row to
check if it is today, and then writing the data read into
the current row. The problem is that the next day, I lose
the data which existed from the previous day.
Any suggestions would be appreciated.
Current Formula: =IF(A43 = TODAY( ), $G$26, #N/A) where
$G$26 has summary data from an external spreadsheet.