I am creating a number of spreadsheets that have multiple links with each
other. One link I am trying to make is this: Condition: If column L has text
"NSI", then copy and paste entire row to a separate worksheet. However, I
need it to paste in a sequential order begining with row 2 of the new sheet
and not in the same row it is copied from on the new sheet. I am probably on
the bottom end of the advanced scale of Excel and would greatly appreciate
any assistance anyone can offer. Thank you.