Create sheets named by header and populate them with sorted data

**salaso69** · 02-15-2013, 04:28 PM

Create sheets named by header in sheet "Table" and populate them with data from sheet "Points" sorting by column E and corresponding sheet name from "Table" sheet.

**HSV** · 02-15-2013, 09:07 PM

With autofilter header I came to this solution.

**salaso69** · 02-15-2013, 09:28 PM

Wow, works! Thank you so much. What can I change in the code to get everything stating with raw 1

Thanks again,

Sasa

**HSV** · 02-15-2013, 09:35 PM

Add the red text in the code.

Please Login or Register  to view this content.

**salaso69** · 02-15-2013, 09:40 PM

Ok, but now in table TOPO I get doubled row one. Also is it possible to get data sorted by column A?

Thanks a lot

**HSV** · 02-15-2013, 09:47 PM

In sheet "Points" there are 4 rows been added by mistake, remove them.

**salaso69** · 02-15-2013, 09:53 PM

Thanks again

**salaso69** · 02-16-2013, 02:20 PM

Hello Harry,
What would be change in the code if I add one more column in sheet "Table"

Thank you,
Sasa

**HSV** · 02-16-2013, 02:31 PM

Hello Sasa,

Can you upload the file ?

Or is this enough.

Please Login or Register  to view this content.

**salaso69** · 02-16-2013, 02:50 PM

Thanks for fast respond. I test it and it works well. The only thing is that in sheet "Points" you have filters on but I can live with that.

Looks like you wrote a completely new code?

**salaso69** · 02-16-2013, 02:56 PM

Hmm, after second look I noticed that row 2 is copied in every sheet.

**HSV** · 02-16-2013, 02:59 PM

For the filters,
Add the red text.

Please Login or Register  to view this content.

You can also use the other code.
Change the 3 into a 4.

Please Login or Register  to view this content.

**salaso69** · 02-16-2013, 03:47 PM

My deepest appreciation

Create sheets named by header and populate them with sorted data

LinkBack

Thread Tools

Rate This Thread

Display

Create sheets named by header and populate them with sorted data

Re: Create sheets named by header and populate them with sorted data

Re: Create sheets named by header and populate them with sorted data

Re: Create sheets named by header and populate them with sorted data

Re: Create sheets named by header and populate them with sorted data

Re: Create sheets named by header and populate them with sorted data

Re: Create sheets named by header and populate them with sorted data

Re: Create sheets named by header and populate them with sorted data

Re: Create sheets named by header and populate them with sorted data

Re: Create sheets named by header and populate them with sorted data

Re: Create sheets named by header and populate them with sorted data

Re: Create sheets named by header and populate them with sorted data

Re: Create sheets named by header and populate them with sorted data

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions