Hi all
Not really sure how to describe this hence the rubbish title (!!) but should be fairly easy from the picture. I have data in column B, in this example, letters starting at 'a'. I want to reference these in in merged celled (column D) but want the second 'block' down to show 'b', not 'e' as it currently does, due the 4 rows being added on to the cell reference. I need to then be able to copy and paste the merged blocks so they reference consecutive cells from column B. I've had a play with the offset function but have been unsuccessful so far
Any help would be appreciated!
Thanks
Not really sure how to describe this hence the rubbish title (!!) but should be fairly easy from the picture. I have data in column B, in this example, letters starting at 'a'. I want to reference these in in merged celled (column D) but want the second 'block' down to show 'b', not 'e' as it currently does, due the 4 rows being added on to the cell reference. I need to then be able to copy and paste the merged blocks so they reference consecutive cells from column B. I've had a play with the offset function but have been unsuccessful so far
Any help would be appreciated!
Thanks