I have grouped cells in a sheet (3 rows by 4 columns ); I reference into this group a cell value in another sheet. This sheet has no grouped cells.
When I setup the first "equals cell" formula in the group, referencing the single row cell value, then drag or copy the formula down the grouped cells, the given value is the third value down in each grouped cell.
I need to get the next row down in each group of cells in increments of 1 not every third value.
Can someone help (no VBA code required)?