Aussiebear
05-16-2010, 03:19 AM
In the attached workbook, lies a data table. I'm looking for any method which might improve its functionality?
For example
1. Number of visible rows at any one time (excluding the Header & LastRow)may not exceed 12 rows, but the visible data rows can only be those rows containing entered data + 1
2. Ability to clear the contents of a row based on a value, then move lower rows up if they contain data.
Please note: the workbook is a copy of a much larger project, and may contain links which work correctly in the bigger project.
The code currently attached simply sorts the data based upon the "Priority" rating
For example
1. Number of visible rows at any one time (excluding the Header & LastRow)may not exceed 12 rows, but the visible data rows can only be those rows containing entered data + 1
2. Ability to clear the contents of a row based on a value, then move lower rows up if they contain data.
Please note: the workbook is a copy of a much larger project, and may contain links which work correctly in the bigger project.
The code currently attached simply sorts the data based upon the "Priority" rating