Excel Macro Needed

Microsoft Excel 2003 (full product)
January 8, 2010 at 06:54:19
Specs: Windows Vista
I have a list of data in Excel. Each row has multiple columns. There is a header section (rows 1 - 3). The data is sorted by column H. Based on the Change in Column H, I wanted a new tab created, naming the tab that value, moving all of the rows which contains that value to that tab, and keeping the header row for each of the tabs.

Anyone think this is possible? I think it is but I am new to VBA and cant get it correct.

See More: Excel Macro Needed

Report •

January 8, 2010 at 07:25:06
Just looking for some clarification...

So if there is a 3 (or Bob) in column H, and you change it to a 4 (or Sue), you want all rows that contain 4 (or Sue) in Column H to be moved to a new sheet named 4 (or Sue), correct?

You also want rows 1 - 3 to be copied to the new sheet everytime, right?

What if a sheet named 4 (or Sue) already exists? Is that a possibility, maybe after the sheet was created and then later another cell in Column H is changed to 4 (or Sue)?

What does the data in Column H actually look like? There are some characters that are not allowed to be used in sheet names. Is that going to be an issue?

Report •

January 8, 2010 at 08:17:08
Sorry for the confusion.
I mean as a look down column H (after sorting by column H), I see all of the "Bob" rows together. Then all of the "Sue" together. etc.

I want to move all of the "Bob" rows to a new tab entittled "Bob" and move all of the "Sue" rows to a new tab entitled "Sue.

Yes I would liek to keep the header to be copied to each new tab created.

The data in column H is all department names. No special characters at all.


Report •

January 8, 2010 at 09:34:26
re: "I think it is but I am new to VBA and cant get it correct. "

Why not post what you've tried and we'll offer some suggestions/options?

Report •

Related Solutions

January 14, 2010 at 16:43:09
Hi there,

I am in the same boat as the original post, I need a macro to create new spreadsheets based on filtered data. Column B has facility numbers (multiple rows per facility number) at each change in Column B, I need all the same numbers copied to a new worksheet (worksheet would then be named whatever number it pulled).
Column1 Column2 Column 3
1 1101 Someplace
1 1101 Someplace
1 1102 Someplace else
1 1102 Someplace else

All of the '1101' need to be on a new sheet named '1101' all of the '1102' need to be on a new sheet named '1102' etc. Is there any hope for me??

Report •

Ask Question