Solved: Cut Paste data into different sheet

[john3j]

Hello. I need to create a module that will do the following:
Find the last row
Go thru the range of column 15
If the value for each row in column 15 equals "Basic" Then
Copy all rows that have "Basic" in row 15 and cut/paste into the second row of the sheet named "Basic Orders"
Else
Copy all that DO NOT have "Basic" in column 15 and cut/paste into the second row of the sheet "Other Orders"
I would like to make sure that no formatting is lost when pasted. Also, all of the data will be on the mainsheet "Data".
Any help would be greatly appreciated.
John:banghead:

[lucas]

If I understand correctly.......

[john3j]

This is exactly what I needed. Thank you so much!