How do i use an "if then" formula in spreadsheet, to past cell data from one worksheet into another based off of another cells contents?
For example, In worksheet 1, if data in column C = "red", then excel will paste cell data from column B of worksheet 1 into column B of worksheet 2, and continue through all data from column C (of worksheet 1).
If data in column C does not match, skips onto next cell.
Bookmarks