excel spread sheet question?

You can do this quote easily and it's just like using a formula.

Say the answer you want is on sheet one, call A4.

To get it displayed, all you need to do on the page you want to print is type =Sheet1!A4

Not sure exactly what calculations you allude to but if a case of having data on a page and then using autosum for example if you had four columns like this:

units sold, price per unit, units returned, refund price

and you wanted to collate this into a summary you could use a pivot table, should work with 27 calculations go to data or tools should be in there (sorry no excel at home and my heads gone blank).

By the way macros can present a security risk.

Why not use the filter to select only the final totals or the totals you need? To do this, select any column (top of speadsheet where it says A, B, C., etc). One or more columns are okay. Scroll over the column (s). When the little black arrow shows up, right click it. Go to DATA, FILTER, AUTOFILTER.

There, AutoFilter is on. You will see on the top, little arrows. Click one. It shows exactly the same data in your worksheet. From there, you have a list of information to select. Pick one item only for each column and click.

Let's say your final totals all have the same comment "Final Total" in column A. Then you should have used column A in the AutoFilter and then selected "Final Total". All your final totals will show up, depending if they are all spelt the same way.

Format the page before printing.

To undo AutoFilter, go back to DATA, FILTER and then click AUTOFILTER again.

you have an option to print on one page or as mant pages as your own choice.

fisrst of all to print on one page you will need to go to 'file' and then go onto page setup. a page setup window will open, after that select the paper size as A4 and also select the option which says fit to 1 page.

to choose your own number of pages and also choose the content that you want in each page, select the print preview icon, and the page will show what it will print on each page, after that select the button which says 'Page Break Preview'. The normal excell screen will appear with darker lines which show where the page break will appear. by dragging these lines you can select the content you want displayed in each page.

also when the screen takes you to the normal excel page the content may seem small on the screen, to view this in a larger mode press and hold the Ctrl key on your key board and scroll the rolling button on your mouse.

simple,

make a master sheet with the format for displaying the data ... for example, in table format or whatever makes sense in your application.

in each cell, type an equal sign ( = ) and then navigate to the sheet that you want the data from and click on the appropriate cell.

Hit enter

The desired value will display in the cell because it refers to the sheet/cell in which the data is actually stored.

Now, just print as usual.

This will not only work with sheets within files, you can also refer to data in other files.

Hope that helps

Go to help in Excel and type 'reference'. It will explain the details on how to do it. no need for macro's as the info, when changed on one worksheet or book will auto update on the collector sheet.

I don't have one yet, but I like a challenge so watch this space...

simply go from page to oage copy (ctrl c) and pasting (ctrl v) them on the desired page

It's as simple as that!

Hi Wills,

The best people to answer your question are at www.extreme-excel.com

They know EVERYTHING there is to know about excel.