I could really use some help. I need a macro that will look for the word "Station" at the beginning of each cell in column A and insert a row beneath it when it is found, then move the Account Type text from the adjacent cell in column B to the new row, in column A.
The report will vary in length each month, so the macro needs to find the bottom of the data each time to make sure nothing is missed
I've attached a file forum.ozgrid.com/index.php?attachment/54380/ with before and after examples. Thanks so much!