I have used subtotal option and copied visible cells to another sheet ,I got desired output but now the copied sheet became too bulky opening so slow ,taking long time to save even there are few records,pls help .thanks in advance.