I haven't done this in along time and searching is just giving me conflicting answers.
If a Cell in one column
something along the lines of
If Sheet 1 B1= Sheet 2 B1 then copy Sheet 2 Row 1 to Sheet 1 Row 1
Sheet 2 Row 1 to Sheet 1 Row 1 - This would be 4 colums at the end of the row.
I haven't done this in along time and searching is just giving me conflicting answers.
If a Cell in one column
something along the lines of
If Sheet 1 B1= Sheet 2 B1 then copy Sheet 2 Row 1 to Sheet 1 Row 1
Sheet 2 Row 1 to Sheet 1 Row 1 - This would be 4 colums at the end of the row.