Master sheet into separate sheets then delete macro.

**motown** · 12-02-2009, 07:23 PM

I'm hoping this is a bit more on the simple side than I am thinking...

The workbook attached starts as imported data into the "Master" sheet. From there I manually sort by Org after making all my updates and then make a new sheet based on the amount of different Orgs. Obviously the formatting, formulas, and such stay 100% as if there are 7 different Orgs, those 7 separate sheets would reconcile and balance with the Master sheet.

From there I take this and send individual tabs to individual contacts.

What I'm wondering first is if the process from going to one sheet can be automated with a Macro to make the individual sheets in addition to retaining the Master sheet. Maybe this is a template and the new Workbook is saved as a new doc without the Macro? That would be ideal.

Also, would it be possible to have the macro make separate workbooks for each Org Sheet (Master not needed on these) to be able to use to send. The names of the new books would be similar to "Controller Base - ABC".xls.

Last, if I had a worksheet that had contact e-mails based on the Org (say Org in Column A and e-mail in column B through Z in case of multiple addys.) could the Macro also create the draft e-mail with me as a "cc"? Subject: Report, and then a simple message that's the same for every report?

Woah, lots to digest, hope to get some feedback on the idea.

Thanks!

**JBeaucaire** · 12-02-2009, 07:58 PM

Install this macro into a standard module in your Controller Base workbook. When you run it, it will update each of the worksheets and then save it to a workbook of its own.

Please Login or Register  to view this content.

This is a standard macro of mine, I just tweaked it to add your totals in the format you presented.

**motown** · 12-03-2009, 11:08 AM

I'm not sure if I'm missing something but the above seems to run fine but produces no results. No other workbooks or tabs on the master book. ?

**JBeaucaire** · 12-03-2009, 01:18 PM

As stated, "It will update each of the worksheets in the workbook and then save [each sheet] to a workbook of their own."

If you tried that on a workbook with no worksheets other than the master, then there is nothing to update.

This macro was designed based on your example sheet. As you saying your workbook does not have other sheets? Why not? Is your original question/sample NOT what you're working with?

**motown** · 12-03-2009, 01:31 PM

Ahhh, sorry that was the part I was missing. The workbook starts as just the "master" sheet and I manully create the other sheets. That's another aspect I was hoping the Macro would take care of. The start and end would be:

Start: Workbook only has one Sheet called Master
End: Seperate Workbooks for each Org we have in Column A and the original workbook saved with Master Sheet and new individual sheets.

Sorry if I wasn't more clear, it's been a rough Year End so far. lol

**JBeaucaire** · 12-03-2009, 01:53 PM

Yeah, that's a significantly different process for the macro. Try this:

Please Login or Register  to view this content.

**motown** · 12-03-2009, 02:20 PM

This is Awesome! It looks like it works and I should be able to record another macro to reformat columns and print settings unless that's a quick add in to the current macro?