<div>
Hello! You might find it easier to use Autofilter to do each Cost Centre.
</div>


Hello! You might find it easier to use Autofilter to do each Cost Centre.

<div>
Hello etech0<br />
Where would I find Autofilter?<br />
<br />
Regards<br />
<br />
SQLSearcher
</div>


Hello etech0
Where would I find Autofilter?

Regards

SQLSearcher

<div>
In Excel 2010, on the home ribbon, click Sort &amp;&nbsp;FIlter, and then click Filter. Then you will have an arrow next to each column header where you can check off which values to show.
</div>


In Excel 2010, on the home ribbon, click Sort & FIlter, and then click Filter. Then you will have an arrow next to each column header where you can check off which values to show.

<div>
Hello etech0<br />
I am currently using filter to get each cost centre in a list then I print off each one, one at a time. &nbsp;I am hoping that there is an easer way than this. &nbsp; I have twenty cost centres so I have to filter and print out twenty times. &nbsp;I am looking for a way that can print each cost centre in one go.<br />
<br />
Regards<br />
<br />
SQLSearcher
</div>


Hello etech0
I am currently using filter to get each cost centre in a list then I print off each one, one at a time.  I am hoping that there is an easer way than this.   I have twenty cost centres so I have to filter and print out twenty times.  I am looking for a way that can print each cost centre in one go.

Regards

SQLSearcher

Filter-Print.xlsm

<div>
<div class="content wysiwyg-content">
Hello Experts Exchange<br />
I have a spreadsheet that has several columns and lots of row of data. &nbsp;I have a column called Cost Centre and it has 20 different figures inside, &nbsp;I can sort by Cost Centre and print each set of information one at a time. &nbsp;Is there a way to print all the data for each Cost Centre all in one go without have to sort each one at a time?<br />
<br />
Regards<br />
<br />
SQLSearcher
</div>
</div>


Hello Experts Exchange
I have a spreadsheet that has several columns and lots of row of data.  I have a column called Cost Centre and it has 20 different figures inside,  I can sort by Cost Centre and print each set of information one at a time.  Is there a way to print all the data for each Cost Centre all in one go without have to sort each one at a time?

Regards

SQLSearcher

Excel Create spreadsheet per cost centre

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.