I am working on a macro and, as part of it, I would like to look at column H of my spreadshet. If the wording in any cell in column H begins with the word, "total" I would like the cell contents of the cell in column G and up one to be dropped down one. Here is an example:
Let's say that the words "total money" is found in cell H2. I would like the cell contents of cell G1 to be moved to G2, making boths cell side-by-side having text in them - G2 and H2.
Can anyone help me with this?
Thanks so much,
Mike
Let's say that the words "total money" is found in cell H2. I would like the cell contents of cell G1 to be moved to G2, making boths cell side-by-side having text in them - G2 and H2.
Can anyone help me with this?
Thanks so much,
Mike