Hannaford123
New Member
- Joined
- Jun 27, 2012
- Messages
- 1
Hi - I have a spreadsheet with multiple columns containing teaching staff (3 x initials), or non teaching staff (number 1). I want to delete all the number 1's and regroup each column so that there are no blanks. I can't do this by using a filter as it also works across the rows whereas I want the columns to remain independent of each other. Can I set this up on a macro so that all the cells containing the number 1 are deleted and the remaining cells in each column move up? I can do each column manually but with 50+ columns there must be an easier way!
Thanks
Thanks