Hi I would like some assistance regarding the following
Where A1 will equal "1" and A15 will equal "1" - I require every cell in between the two to be filled with a "1".
My aim is to apply this to a small base of data and to conditional format the "1" so that at a glance I can sum the total amounts of rows and associated 'blocks'