ExcelBanter - copying a formula but not skipping ref cells

ExcelBanter (https://www.excelbanter.com/)

- About this forum (https://www.excelbanter.com/about-forum/)

- - copying a formula but not skipping ref cells (https://www.excelbanter.com/about-forum/448339-copying-formula-but-not-skipping-ref-cells.html)

Picc

copying a formula but not skipping ref cells

I'm trying to reference a column of data from sheet1 into sheet2.

I need to skip rows in sheet2 without skipping the reference cells.

All times are GMT +1. The time now is 10:53 AM.