Hi all, I've been trying to piece this together but my experience is limited -- thought I could accomplish this with a simple formula initially, but now not sure. Appreciate any help.
I have a workbook that lists jobs for a company that has 3 divisons.
I need to start maintaining separate sheets per division, but also need to maintain my master sheet of all jobs. So I would like rows relating to specific divisions to automatically get copied into their respective sheets -- so I only ever need to update my master sheet.
E.g.
IF a row contains "Dental" in Column B, that row content is copied to the Dental sheet
IF a row contains "Medical" in Column B, that row content is copied to the Medical sheet.
Thank you!!
I have a workbook that lists jobs for a company that has 3 divisons.
I need to start maintaining separate sheets per division, but also need to maintain my master sheet of all jobs. So I would like rows relating to specific divisions to automatically get copied into their respective sheets -- so I only ever need to update my master sheet.
E.g.
IF a row contains "Dental" in Column B, that row content is copied to the Dental sheet
IF a row contains "Medical" in Column B, that row content is copied to the Medical sheet.
Thank you!!
![EXAMPLE-SHEET.jpg](/board/proxy.php?image=http%3A%2F%2Fwww.drytoasts.com%2Fwp-content%2Fuploads%2F2018%2F02%2FEXAMPLE-SHEET.jpg&hash=c2cbfd72ffdfd6d17b56b132c924a46e)