This is probably very simple for you. I have a simple 2 sheet workbook with current projects listed by client. When I delete or add a client on sheet 1, I want it to automatically update sheet 2, keeping the alpha formatting. The tricky part for me is that the 2 sheets have only the client name in common, the other columns are different. thank you very much for your response.