Noob here. I tried looking everywhere but I apparently don't know how to use the correct words to find what seems like should be a simple solution...
Column A is for Day labels of consecutive weekends (Saturday and Sunday) for 4 consecutive weekends.
Column B is related data for each day.
Column C has one cell for each weekend that sums the data for each weekend. Each cell in this column is separated by a blank cell so they are noncontiguous.
I need a quick/simple way to enter the formula "=cell address" of each non-empty cell in column C into continuous cells in Column D. In other words, I need the contiguous cells in Column D to reference cells in Column C and not just show the calculated results of the cells in Column C. My real worksheet has thousands of rows of data so manually entering "=cell address" from every other cell in Column C into every contiguous cell in Column D is prohibitive. Also I need to be able to copy the worksheet and replace the column B data with other data and have the results in column D recalc.
My sample worksheet is attached. I hope I explained myself adequately. Thanks in advance for any help offered.Excel Sample 1.xlsx
Bookmarks