How to create a Macros that will filter and drop in different tabs

[robert21]

Hello,

I'm not the greatest when it comes to excel. I know how to use all the formulas but when it comes to using the Macros I don't really know how it works very well. I have a worksheet with a large database that changes weekly. What I want to do is create a Macros that will filter the database based on criteria and then drop it in a tab. The criteria that I want to filter by is in column N and it will be a name of a company, then I would like the filtered information to be dropped in another tab.

Could anyone please help me? Thanks!

[JBeaucaire]

Yes, a very common request.

'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.

The parts to edit are in red, the variable named vCol should be 14 for column N.

[robert21]

Thank you for all the help this is exactly what I needed!

[robert21]

Yes, a very common request.

'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.

The parts to edit are in red, the variable named vCol should be 14 for column N.

I tried running it and I don't know if I messed up in something but just to be sure this will sort out of column 14 (once I change it) and drop in new tabs all in the same worksheet right?

[JBeaucaire]

The parts of the code you need to check are highlighted in red for you. Changing the vCol = 14 is obvious since you want to column of values to be column N, which is column 14. The rest you match to your workbook layout.