Hi
i need help with a formula that will duplicate selected data from a master worksheet into another worksheet IF a condition is met. example:
Master worksheet contains job title, name, branch, date started
if the person is from "RMB" branch (the condition) then the following data will be copied into the "RMB" worksheet - job title, name and date started.
and if the person is from "HR" branch then the following data will be copied into the "HR" worksheet - job title, name and date started.
can someone please point me into what formula would be the best for me to use?
Sample.xlsx
thanks
Bookmarks