IF cellJ5=x, then copy entire row into New Sheet

**absflaw** · 02-08-2012, 04:23 PM

I have looked at a previous forum which suggests a macro/VBA to move an entire row of information to a new spreadsheet. It does not seem to solve my problem, as the data i need to sort cannot come from the first column.

So my question is:

Is it possible to use a qualifier from Spreadsheet 1 that occurs in column "J" and have the entire row copied automatically into another spreadsheet?

I have attached an example, in which I want to sort different Clients by "Place", which in this case is Column J. I am hoping to sort the data into different sheets so that Place X is in one sheet and Place Y is in another.

**watersev** · 02-08-2012, 04:59 PM

hi absflaw, welcome to ExcelForum, please check attachment, press "Run"

**absflaw** · 02-08-2012, 05:51 PM

Wow. I am grateful for the quick response. It works almost nearly as I need it to, though I am wondering if it's able to update, rather than add previous entries again (once the button is pressed). I am not sure how the thing works. I have attached the exact columns I am working with, not just hypotheticals. As you can see, I am looking for column AB.

Best,

**JBeaucaire** · 02-08-2012, 07:24 PM

'SHEET1 TO MANY SHEETS
Here's a macro for parsing rows of data from one sheet to many sheets named for the same values in a specific column.

Sheet1 to Many Sheets

It not only can parse the rows, it can create the sheets if they are missing. There is a sample sheet there where you can test this out.

When you install this macro, change the vCol to 28 so that it parses by column AB.

Also change the Sheets("Data") to Sheets("Clients").

Lastly, vTitles = "A1:AG1"

That should be it, it should work as is from there. Each time you run it will replace the data on each sheet with the updated data from your CLIENTS sheet, and it will create new client sheets as needed.