Hi all,

I have a worksheet where I record all projects (added on an ad hoc basis) I'm involved in, some require auditing and some don't.

What I'm trying to achieve is to automatically copy certain cells from Sheet2 to Sheet5, if the value of row J on sheet2 is either 'email' or 'folder'.

I don't want to copy the whole row, just certain cells from the row. However they don't exactly correspond to the cells on Sheet5 where they need to be pasted. As an example the cells from the row on Sheet2 that need to be copied are A, C, D, E, F and J and these need to be pasted into cells A,B,C,D,E and G respectively on Sheet5.

Both sheets have headers in row 1 and the information needs to be copied into the next available empty row on Sheet5 so no data is overwritten.

Is this something that can be done?

Thanks in advance for the help.