Hi,
Need help for a VB code that does the following :
( Sample excel sheet is also attached that explains the requirement clearly
before & after running the script)
1. It should work on those "rows" in which :
Cell A contains a string
Cell B contains a number
Cell C contains a number
Cell D contains a "number" or string "None"
2. Once it identifies the rows, then :
If cell D contains "None", then it should
- Merge all cells in the row from "number in B + 4" to "number in C + 4"
- Add borders
- Fill with some colour.
If cell D contains a number, then :
- Merge all cells in the row from "number in B + 4" to "number in D + 4" and
- Merge all cells in the row from "number in D + 4 +1" to "number in C + 4"
- Add borders & fill both the merged cells with some colour.
- Add a comment in the first cell as "Trial o/p available"
Thanks for any help in advance.
Bookmarks