I have a situation where I need to copy a range (a:j) to a sheet (named Existing) if a criteria is met and copy the same range to a sheet (named New) if a criteria is not met. I have four sheets: Details, Master, Existing, & New. If the data in columns A & B, in Details, matches the data in columns A & B, in Master, I want to copy the columns a:j for that row to the sheet named Existing. If not, I want to copy columns a:j to the sheet named New. I have attached a sample spreadsheet to hopefully better explain what I am looking for. Any help would be appreciated.
Thanks,
Met
Bookmarks