This is the last thing I have to figure out and my project is finished. ! This is a great resource and I appreciate all the help I've gotten.
I have a group of cells D21:D46 that may or may not have entries. The entires will start at D21 and the last possible entry would be in D46. The catch is that not all cells have to have entries in them. Using VBA, I have to move the last five cell values in order (from D46 down to D21) to D18 down to D14.
I'm sure I can come up with something that would probably be brute force and not very efficient, so I figured I'd get some advice from the experts. Appreciate any ideas.
I have a group of cells D21:D46 that may or may not have entries. The entires will start at D21 and the last possible entry would be in D46. The catch is that not all cells have to have entries in them. Using VBA, I have to move the last five cell values in order (from D46 down to D21) to D18 down to D14.
I'm sure I can come up with something that would probably be brute force and not very efficient, so I figured I'd get some advice from the experts. Appreciate any ideas.