Summary Worksheet.
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. |
Summary Worksheet.
Easier if you send the file to me at dguillett1 @gmail.com
I recommend all in one sheet and just use datafilterautofilter to see month On Feb 1, 2:50*pm, Colin Hayes wrote: 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 |
All times are GMT +1. The time now is 11:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com