Thanks for the quick reply!

“IBT” is text that I am trying to find from transferring a text file into Excel - it is not alone in the cell.

IBT is in column D - first one is found at row 192 and then want to select all surrounding data which was rows 190-195 and cut that to A1 of Sheet3.

The dataset that would upload into Excel will always change and will need to use the Find feature to locate which cell has IBT in order to select the rows surrounding it.

Due to the file being a text file I copy/pasted the file into column A on Sheet2 and then used Text to Columns with this "Step 1" macro

** Step 1 Format Sheet**

Range("A:A").Select

Selection.TextToColumns Destination:=Range("A1"), DataType:=xlDelimited, _

TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=True, Tab:=True, _

Semicolon:=False, Comma:=False, Space:=True, Other:=False, FieldInfo _

:=Array(Array(1, 2), Array(2, 1), Array(3, 1), Array(4, 1), Array(5, 1), Array(6, 1), _

Array(7, 1), Array(8, 1), Array(9, 1), Array(10, 1), Array(11, 1), Array(12, 1), Array(13, 1 _

), Array(14, 1)), TrailingMinusNumbers:=True

Range("A:A").Delete

End Sub

I only want to Cut the data that contains the IBT within the 5 rows and then paste them to Sheet3 - trying to have it find the last row unused +1 so there is a space in between each cut/paste

Was able to get it to find the first IBT section and paste onto Sheet3 but i cant figure out how to loop it and find the next row +1