Trying to pull info out of an excel database and copy to a new spreadsheet skipping over the duplicates in exel the statement would be
=If(activecell = active cell(-1,0), skip down one cell, run imbeded macro to copy row to other sheet)
Then loop
What is the correct VB way of structuring this IF/Then statement
Thanks
=If(activecell = active cell(-1,0), skip down one cell, run imbeded macro to copy row to other sheet)
Then loop
What is the correct VB way of structuring this IF/Then statement
Thanks