UncleBajubjubs
Board Regular
- Joined
- Jul 11, 2017
- Messages
- 111
- Office Version
- 2010
Hello, I am trying to write a macro to copy information from a range (E22:DQ22) to another range directly above it (E8:DQ8), but only if the cells have values, and highlighting the changes. For example, if there is already information in cell E8 and F8, and cell E22 has data while F22 does not, the value in E8 will be replaced by that in E22, while the data in F8 will remain the same. Cell E8 will now be highlighted, while F8 will not.
I imagine I need some type of loop, but I'm not sure the bets way to do it. Any ideas?
I imagine I need some type of loop, but I'm not sure the bets way to do it. Any ideas?