I do not think a formula can create a separate sheet. A formula can only return a value. What you need is code, or macro. I can help if you could attach your sample. To attach a sample, go to advance then attachment.