Hi.
I have been working on a file and wondering if a Marco could help!
Basically, each time I need to clear some content & to delete some unnecessary datas in the C column. Finally, re-present it as a clean easy to ready report.
1. insert a new colunm after C columnn and name the new D column as " Color".
2. I will bring cell: C6 to cell: D4
3. clear the data from cell: (A5:D9)
4. delete the blank Row 10
5. Fill the data from (A5:D9) with the same data on Row 4
repeat the above 1-5 steps for the next item.
I'm attaching a sample file to show how the original file look like "before' and what is the desire "result" to be.
thanks for checking and all the help!
Bookmarks