I am trying to copy a relative formula with a pattern increase.
I need the formula to copy from sheet1 (RRP Clean) cell C100 into sheet2 (POS) cell A24. Then I need to copy the sheet 2 relative formula down 14 rows whilst the relative formula only increasing by 1 cell i.e. Sheet 2 cell A38 copying in Sheet 1 cell C101 (instead of cell C114) and so on for A52,etc.
Does anyone know the right way to do this. I have tried using OFFSET but can't seem to make it work.
Thanks in advance and apologies for the poor explanantion. Hopefully the photos help explain.
3.PNGExcel Pattern 2.PNG
Bookmarks