Hello all, .... Is there a way to reproduce the data from col B2:B4, into col C, where the display row is dependant upon the variable in D10. So if D10=3, the data would begin in Row C5 (original data start row plus 3), as below. (apologies for the rubbish format but my IT dept does not allow uploading of a screenshot and any spaces are automatically deleted when previewing so I had to use dashes :-/
Thank you!
----------A-------------B--------------C------------D
1------Despatch-----Qty----------Delivery----offset days
2-------21/6---------150
3-------22/6---------200
4-------23/6---------300
5-------24/6-------------------------150
6-------25/6-------------------------200
7-------26/6-------------------------300
8
9
10-------------------------------------------------3
Bookmarks