Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summary sheet/ hide rows
Hi!
I am trying to produce a summary worksheet that automatically only contains rows from another worksheet that meet a certain criteria. I have been trying to write an "if" statement that only copies those cell that meet the criteria but if they don't, hide the row. This is a constant recurring task for me, so I don't want to have to manually run macros and/or filters every time I want to look at the summary sheet. This means every cell must have an "if" formula. I have seen a number of VBA scripts (in other messages) to hide rows but can I enter them as part of a formula? I hope I have explained this properly. Thanks for any help. Sally. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summary Sheet help with multiple sheets | Excel Discussion (Misc queries) | |||
Hiding rows while sheet is protected | Excel Discussion (Misc queries) | |||
Daily Totals on a summary sheet | Excel Worksheet Functions | |||
resetting last cell | Excel Discussion (Misc queries) | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions |