Hi Khurram Z., I noticed your profile and would like to offer you my project. I need an application that will modify an excel spreadsheet into a different format.
I copy from a hospital medical record program a list of patients. The list includes room number, name, age, sex, etc.
What the app will do is
1. Modify the room number to just numbers.
2. Organize the room numbers in discrete groups.
3. Place some in descending and others in ascending order.
4. Separate the groups by colored dividing lines.
5. Create two boxes to the right of the specific record.
6. Use vLookup to code a manual entry into the left hand box yielding posting a number in the right hand box.