I have a equation for H1 that at first I filled down to infinity (making a large file) then I realised that I only need it to fill down as far as Column B is filled in. I need to also do this on another sheet? so sheets sheet1 sheet3 etc.\

I pinch the code from another post.



This is what I have come up with so far



Please Login or Register  to view this content.