create sheets' data from master sheet

[ShadowRider]

I have a master sheet of data for a number of individuals and would like to create a sheet for each for their ease.

For example:
Master Sheet

A b c
Jane Doe amount 1 reason 1
Jon Doe amount 2 reason 2
Tom Smith amount 3 reason 3
Jane Doe amount 4 reason 4
Jon Doe amount 5 reason 5
Tom Smith amount 6 reason 6
Jane Doe amount 7 reason 7
Jane Doe amount 8 reason 8
Tom Smith amount 9 reason 9

I'd like to have sheets for Jane Doe, Jon Doe and Tom Smith. Jane Doe's sheet would look like:

A B
amount 1 reason 1
amount 4 reason 4
amount 7 reason 7
amount 8 reason 8

IN order to accomplish this, can I use a formula or do I need some VB code? If code, any way to make the macro automatic, such as when it's opened or printed?

Thanks.

[JBeaucaire]

I have a macro that may be "ready to use" for parsing rows of data from one sheet to many sheets named for the same values.

Sheet1 to Many Sheets

It not only can parse the rows, it can create the sheets if they are missing.

[ShadowRider]

Yes, that macro works very well - thank you.

I'd like to modify it so that I get a total for two of the columns on each page. Any suggestions on modifying the macro for this?

thanks again.

[JBeaucaire]

Show me what you mean in a sample workbook created from the macro and with the stuff manually added that you want.

Click GO ADVANCED and use the paperclip icon to post up a desensitized copy of your workbook.

[ShadowRider]

Show me what you mean in a sample workbook created from the macro and with the stuff manually added that you want.

Click GO ADVANCED and use the paperclip icon to post up a desensitized copy of your workbook.

Here it is. I did the calculation two ways. Now that I think about it, the second way is probably best as you don't need to know the depth of rows above you and the formula can be the same on each page.

Thanks again.

[JBeaucaire]

I didn't see the macro in the file, did you edit it in any way?

[JBeaucaire]

Just add this to macro:

Please Login or Register  to view this content.

The first and last lines of that code example are already in the macro, add the stuff in the middle.

[ShadowRider]

I had not modified the macro other then to specify the options. Thanks for your help. I'll add this to the macro.

Thanks again!

[ShadowRider]

I have several sheets that I need to use as the source sheet for this macro. I currently use a different macro for each sheet, but it seems to me there is a way to have a variable for the sheet name.

How can I pass in a sheet name to the macro so I can use the same macro for all sheets?

Thanks.

[JBeaucaire]

Well "ALL SHEETS" is a dangerous phrase. You mean "all the sheets I want to parse from".

This version has an array added where you can list all the sheet names to parse data from.

Please Login or Register  to view this content.