Excel problem

Winnieacre

I have a number of worksheets (one for each month)in a workbook and want to produce a summary sheet that will summarise the results by totalling the results from certain cells in each sheet.

I can do this by inserting =Jan!S37 then =Feb!S37 then =Mar!S37 and so on accross the columns.

This is very timeconsuming. Is there a way to use the Edit/Fill command or some other way to simplify the process?

Thanks in advance, any help appreciated.

Antar Bolaeisk

You can use the indirect function.

First set up a column with the months of the year in them as they appear on the sheet names so for example A1 will be jan.

Then, in the B column use;

=indirect(A1&"!S37",1)

When you drag that down to fill in the rows it should do it for all the months.

Winnieacre

Thanks Antar

That worked once I made sure that the column headings matched the worksheet labels i.e. that both column and worksheet tab read 'Jan'.
You've saved me a lot of time!

Winnie

Antar Bolaeisk

You're welcome, glad it worked.