D
Dr. Darrell
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 column’s 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
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 column’s 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