The aim of this code will be when i run the code, it will look across the range i have selected, identify if the cell contains a "/", then copy that cell AND the 3 cells to the RIGHT of this cell then paste the copied cells elsewhere.

Currently this is my code, which copies and pastes the next 3 cells every time a cell with a value is encountered, however i only want it to copy and paste if the first cell encountered contains a "/"

Please Login or Register  to view this content.