Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trying to list tab/worksheet names in a summary worksheet | Excel Discussion (Misc queries) | |||
Summary worksheet reference to detail worksheet | New Users to Excel | |||
Summary Worksheet with VBA | Excel Programming | |||
summary data sheet from worksheet to worksheet | Excel Worksheet Functions | |||
Link worksheet totals to a summary worksheet in the same workbook | Excel Worksheet Functions |