Automatically "cut and paste" data from one Excel workbook to multiple workbooks
Posted on 2014-10-31
Is there an easy, automatic way - rather than manual cut and paste - to copy data from an Excel workbook into separate, individual workbooks based on one of the columns of data? So if I have several columns of data and one of the columns is an agent number, I want to take all the rows for a particular agent number and create a separate workbook only with that agent's information and then save the file using the agent's first and last name, which are in another column. Is this possible? If so, how? If it needs to be done with Visual Basic coding, does anyone have that coding or willing to put it together for me? I am not a programmer and wouldn't know where to start with this. If you need a sample of my data, I can provide that. Thanks for any help you can provide.