Hello everyone. I hope I can get some help with this :o)
I have made a macro that looks like this(It's a macro for accounting):
This is just an extract of the full macro, but it should be enough for me to explain.
As you can see of the selected range, the worksheet wil now probably have the words Rent, Food and Insurance in cells B4, B5 and B6, and there is a number in cells D4, D5 and D6 which is being copied to a column farther to the right. So far the macro works. The problem is, if I then enter Rent, Food and Insurance again in cells B7, B8 and B9, and some numbers in cells D7, D8 and D9, the macro totally ignores this, and I've tried several times with do..while.until..loop, but it just doesn't work.
Does anyone have a clue??
Bookmarks