View Single Post
 
Old 08-14-2017, 07:04 AM
Lincoln Delph Lincoln Delph is offline Windows 10 Office 2016
Novice
 
Join Date: Aug 2017
Posts: 7
Lincoln Delph is on a distinguished road
Default

I now realise that the solution I thought I'd found does not do what I want. The filter system just hides the lines that don't meet the criteria. What I'm looking for is a way to step through the data select a matching line and paste it elsewhere.
The end result being that if the criteria is met in B5 the row 5 becomes row 1 elsewhere on the sheet. The next row that meets the criteria becomes row 2 etc.
I'm sure this must be possible but it's beyond my anility and understanding which is why I was really looking for a complete syntax
Reply With Quote