Separate workbook by value in column into separate workbooks.

**LightingPop** · 02-25-2013, 01:35 AM

Hi. So I have 10 very large workbooks that are all setup in the same format. In column Z is a numerical value from 1 to 83. I have been trying to filter the sheet and then copy one at a time from 1 to 83 but that takes a LONG time especially when there is 10 workbooks to do.

Is there anyway I can run a function or macro or something that would just automatically look down the column Z and put each row into a it's own workbooks?

I have attached a sample of what the workbooks look like right now, any help would be so great. Thanks!

**visha_1984** · 02-25-2013, 02:03 AM

Hi loghtingPop

u mean fillter in col Z and copy row and make new sheets or workbooks.

**LightingPop** · 02-25-2013, 11:27 AM

Yes. Is there any way to automate that process so that every row that has matching values in column Z are copied over to a new workbook together?

**arlu1201** · 02-25-2013, 11:50 AM

So if i understand this correctly, you want each workbook to be taken from a folder, check for column Z in each file and move the corresponding data to its own workbook. So this data should be copied to new workbooks or existing workbooks?

Are the existing workbooks placed in the same folder or should the new workbooks be placed in the same folder or a new workbook altogether?

**LightingPop** · 02-25-2013, 04:10 PM

Yes that is exactly what I would like to do. Be able to have some kind of command or macro that when ran in the currently opened workbook it would search through column Z and put the data that matches in it's own books.

I am sorry if this is not clear.

Basically I have 10 different work books and they are HUGE. All of them are the same format where column Z is a numerical value from 1-83. So it would copy all of the rows that have a 1 in column Z and put them in there own book. Does that makes sense?

Currently there are not already workbooks in place for the data to be copied too so I really place them anywhere it is needed.