Hi All, i have the below code at the moment it just runs on cell Z1 but i want it to move down column Z fetching the data until the cells are blank so the code would run complete Z1 then loop round dropping to Z2 etc. how do i add the loop in?
Option Explicit
Sub Find_Data()
Dim casenumber...