if a 1 appears in any of three specific columns, then cut row and move to next sheet

[intothewild]

In attached workbook there are 0 and 1's in columns G, H and I.
Any ideas on:

• If a 1 appears in any of these three columns (G, H and I) on Sheet2, then move the row that the 1 (or 1's) are in, from Sheet2 to Sheet3. Would need to determine how many rows are in Sheet3 before pasting in new rows (to avoid overwriting rows that are already in there).

[mike7952]

Give this a try

Please Login or Register  to view this content.

[intothewild]

Thanks alot Mike, it works wonders! Can you talk me through the steps a little, i dont follow everything (your more sophisticated in vba than me, thankfully!) ..your reference to col "a" in particular left me guessing how this works. i understand alot of these methods (so im definitiely learning alot, thanks!) but im struggling with whats happening, in particular, on the lines with 'RangeToCut'.