I need a macro that can copy specific information based on specific criteria, and to be pasted into new sheets. so for an example i need all the information that belongs to john, max, and ahmed. i need the macro to be able to copy each name with the information that belongs to that name into a new sheet.
Are you saying that you have an "Input" sheet with varying names in one column (say Column A), a number of data columns (say Columns B:H) with data relating to the name in Column A and then each row of data associated with a particular name transferred to individual sheets named after each individual in Column A?
The best way for someone to be able to help you would be if you uploaded a sample of your work book clearly showing your inputs and expected results. You can upload a sample using a free file sharing site such as DropBox or ge.tt
Be careful with any sensitive data.