When anything is entered into the column A starting at row 3 and below I would like VBA to copy sheet 1 and create a new sheet.
So if data is entered in A3 I would like a new sheet to be opened which is a replica of Sheet 1, then if data is entered into A4 I would like a new sheet to be opened which is a replica of Sheet 1 and so on.
Any help would be greatly appreciated!!