I have a worksheet with multiple directorates and information under each directorates.
how can i automate the worksheet to select split the worksheets at different directorates and save them as seperate files under the directorate name?

» Forum post: Excel vba (macro)

What's In A Number? Make Figures Mean More Via Excel

Where Excel is concerned, spreadsheets can be viewed as a storage for data before it's transformed into informative reports. Teaming Excel and Project means you have access to report-making functions that reflect the inner workings of assignments, such as resource allocation.

» Article: Excel course london

Here's how to present your data in a chart format:

Highlight the data you wish to use in a chart

Click the Insert Ribbon

In the Charts Group, select Column Chart

Your chart will then appear on your work sheet.

» Tip: Creating Charts in Excel

Here's how to present your data in a chart format:

Highlight the data you wish to use in a chart

Click the Insert Ribbon

In the Charts Group, select Column Chart

Your chart will then appear on your work sheet.

» Tip: Creating Charts in Excel