software

I have a large workbook with 50 or so worksheets that have the same layout.
I would like to create a summary table of data in the worksheets in a table

I'm ashamed to say that although I passed City amp; Guilds a few years ago
I've forgotten almost everything I know about this program.

Hello,

When flopping back and forth between colors in Excel it would be nice to have
more than one cell fill in icon. You can have two or more on the toolbar but

We have created a web application that allows users to generate Excel
documents. We use Excel XML to create the document and allow users to open or

Hi,

I need to link a sheet to a pivot table in the same workbook to get the data
value from the pivot table. This also has to be updated dynamically as the

Hi, could someone please advise me on a training site I can use to get info
on how to work out sums on excell?

I am trying to average a column from cell 1 to the most recently added cell.
A1 is the constant cell. All succeeding cells are to be averaged from A1.

I want to track vacation days: taken and left to take. How do I link two
cells so when I add to one the other automatically subtracts the same value?