Hi all,
After two weeks of developing and testing, my macro is almost ready! There’s just one small component left that I can’t seem to figure out. It involves conditional copy-pasting. Here are some more details:
The macro should search column A starting with A2. Each time a cell in column A contains the string “Status,” it should:
1. Move down 1 cell
2. Move 10 cells to the right
3. Copy that cell
4. Move 10 cells left, 2 cells up (1 above “status”)
5. Paste
6. Move down 2 cells so that it can continue searching the column for “Status”
Any ideas or suggestions are much appreciated!
Bookmarks