GallowayJay
New Member
- Joined
- Apr 8, 2002
- Messages
- 15
Hello....I want to create a Macro that would do the following:
If the row above it (some specific cell) contains data, I want Excel to automatically add a row below it. This would be similar to what Access does. I want to do this so that a user can enter information into a protected sheet without having to unprotect it, add the rows, and reprotect it. This will cut down errors. Can anyone help?
Thanks!
If the row above it (some specific cell) contains data, I want Excel to automatically add a row below it. This would be similar to what Access does. I want to do this so that a user can enter information into a protected sheet without having to unprotect it, add the rows, and reprotect it. This will cut down errors. Can anyone help?
Thanks!