I use Office 2003:
I have a workbook with tabs for each day of the month (01st, 02nd, etc thru
31st).
One cell on each page needs to refer to a specific cell on the previous day,
if data is
there; if not, then the day prior to that and so forth. As in:
(tab)05th cell C3 = (tab)04th cell B4 (or if no data, then 03rd cell
B4 and so on.
I'm sorry if this is not clear. Can anyone help?
Thanks in advance!