I have a work book which has 64 worksheets in it. I would like to create a
Summary Worksheet.

1) I would like to create a summary worksheet.

2) I would like to merge Cells A1:L1 and enter the File Name (without the
extension). Formatted Arial,Bold,White,24pt text with Black background.

3) In Cells B2:M2 I would like to enter the values from the first worksheet
Cells # S8, T8, U8, V8, W8, X8, Z8, AA8, AC8, AD8 and AE8

4) In Column A3:A70, I would like to enter the text from each Worksheet Tab.

5) On each work sheet there is a value in Column A of €œtotals€�. In these
work sheets, it happens to be on Line 97, 98 or 59.

a. On each line representing each Tab Name, in columns B through M, I would
like to enter the values of columns S, T, U, V, W, X, Z, AA, AC, AD and AE
from the lines that contain the value €œtotals€� in column A for each of those
worksheets.

Can code be easily writen to perform these tasks? Or should I create this
worksheet manually?

Darrell

Start with this macro
http://www.rondebruin.nl/summary.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Dr. Darrell" wrote in message ...
I have a work book which has 64 worksheets in it. I would like to create a
Summary Worksheet.

1) I would like to create a summary worksheet.

2) I would like to merge Cells A1:L1 and enter the File Name (without the
extension). Formatted Arial,Bold,White,24pt text with Black background.

3) In Cells B2:M2 I would like to enter the values from the first worksheet
Cells # S8, T8, U8, V8, W8, X8, Z8, AA8, AC8, AD8 and AE8

4) In Column A3:A70, I would like to enter the text from each Worksheet Tab.

5) On each work sheet there is a value in Column A of €œtotals€�. In these
work sheets, it happens to be on Line 97, 98 or 59.

a. On each line representing each Tab Name, in columns B through M, I would
like to enter the values of columns S, T, U, V, W, X, Z, AA, AC, AD and AE
from the lines that contain the value €œtotals€� in column A for each of those
worksheets.

Can code be easily writen to perform these tasks? Or should I create this
worksheet manually?

Darrell

Ron:

Thank you, Looks like this will get me on track.

Darrell

"Ron de Bruin" wrote:

Start with this macro
http://www.rondebruin.nl/summary.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Dr. Darrell" wrote in message ...
I have a work book which has 64 worksheets in it. I would like to create a
Summary Worksheet.

1) I would like to create a summary worksheet.

2) I would like to merge Cells A1:L1 and enter the File Name (without the
extension). Formatted Arial,Bold,White,24pt text with Black background.

3) In Cells B2:M2 I would like to enter the values from the first worksheet
Cells # S8, T8, U8, V8, W8, X8, Z8, AA8, AC8, AD8 and AE8

4) In Column A3:A70, I would like to enter the text from each Worksheet Tab.

5) On each work sheet there is a value in Column A of €œtotals€�. In these
work sheets, it happens to be on Line 97, 98 or 59.

a. On each line representing each Tab Name, in columns B through M, I would
like to enter the values of columns S, T, U, V, W, X, Z, AA, AC, AD and AE
from the lines that contain the value €œtotals€� in column A for each of those
worksheets.

Can code be easily writen to perform these tasks? Or should I create this
worksheet manually?

Darrell