D
DConstance
I need to compare each row (not individual cells) in columns B:C to eac
individual row in columns F:G. i.e. look for B2&C2 in F:G. If no matc
is found this data needs to be entered into the next blank row in F:G.
import data into B:C on a daily basis through a macro, so I'd like t
incorporate this into it. I currently have data in H:K that is specifi
to the data in F:G within that same row. I will enter data into H:K a
the data is entered into F:G. I tried auto filtering B:C into F:G, bu
the data in F:G changes row numbers without the data in H:K, s
everything becomes mixed up. What's the best way to do this
individual row in columns F:G. i.e. look for B2&C2 in F:G. If no matc
is found this data needs to be entered into the next blank row in F:G.
import data into B:C on a daily basis through a macro, so I'd like t
incorporate this into it. I currently have data in H:K that is specifi
to the data in F:G within that same row. I will enter data into H:K a
the data is entered into F:G. I tried auto filtering B:C into F:G, bu
the data in F:G changes row numbers without the data in H:K, s
everything becomes mixed up. What's the best way to do this