Summary Worksheet.

[Colin Hayes]

Hi All

I need some assistance in establishing a summary worksheet in my
workbook.

Sheets 2 - 13 represent the months April to March. Each sheet has
entries for various activities in the month , one row per activity.
Where there has been no activity the cells in row C are empty. There is
a varying amount of activity in each month , with a maximum of 40
entries possible per month.

This means that months have varying numbers of entries. Rows beneath the
final entry are left unfilled in column C.

I'm trying to establish a sheet 15 where completed rows from each month
are copied over as they are entered. This would be ordered April to
March in row order. Clearly , where cell C in the row is blank this
would not be copied over. Where cells in C have an entry these should be
copied over. This would apply for all sheets 2 - 13.

Can someone help with some code for my sheet 15?

Grateful for any advice.

 

[Don Guillett]

Easier if you send the file to me at dguillett1 @gmail.com
I recommend all in one sheet and just use data>filter>autofilter to
see month

Hi All

I need some assistance in establishing a summary worksheet in my
workbook.

Sheets 2 - 13 represent the months April to March. Each sheet has
entries for various activities in the month , one row per activity.
Where there has been no activity the cells in row C are empty. There is
a varying amount of activity in each month , with a maximum of 40
entries possible per month.

This means that months have varying numbers of entries. Rows beneath the
final entry are left unfilled in column C.

I'm trying to establish a sheet 15 where completed rows from each month
are copied over as they are entered. This would be ordered April to
March in row order. Clearly , where cell C in the row is blank this
would not be copied over. Where cells in C have an entry these should be
copied over. This would apply for all sheets 2 - 13.

Can someone help with some code for my sheet 15?

Grateful for any advice.

0