hi there,

I have a spreadsheet with two tabs - and I want to copy some data from one tab to the other based on certain criteria.

In tab 1, I have a column with a list of staff including employee ID (unique) and then a series of columns for each day of the year.

In tab 2, I have a column with the same unique ID, and then columns for each day of the year but this time populated with shift pattern or an "R" if on annual leave.

The unique IDs are not in the same order on each tab, and the information on Tab 2 is changed weekly

I want to copy to the "r" from the second tab to the first tab, but not the shift patterns.

I was thinking of trying to combine some kind of VLOOKUP and IF statement, but can't figure out how to do that.

Can anyone help please?

Paul