Hi everyone,

Im new to VBA, wondering whether what im trying is possible.

I have tables from 2 different sheet. Sheet stafflist - table (stafflist). sheet leave references - 4 tables (management, Acq, SP, MM)
I was trying to do is from table stafflist:
- if each ROW CONTAIN 'management' (column E) then copy only row A and B to sheet leave references - table management
- if each ROW CONTAIN 'Acq' (column E) then copy only row A and B to sheet leave references - table Acq
- if each ROW CONTAIN 'SP' (column E) then copy only row A and B to sheet leave references - table SP
- if each ROW CONTAIN 'mm' (column E) then copy only row A and B to sheet leave references - table MM

Any help would be appreciated.

Thanks.