I've attached a file. I've used simpler explanation, but basically I've to input data into a report every month (column B), but use the same formula from the last month except referencing the new cells.
There are multiple columns in the real world, so it's time-saving to drag them all the information down from the previous 2 months to form the new month but this throws in a supposed value.
Is there anyway to copy data down from previous two rows, but leave data in one column blank?
Bookmarks