Summary Worksheet.


C

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.
 
Ad

Advertisements

D

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top