Hi
The below code does what I need it to do but it requires small tweaks / code cleanup maybe
Issues:
1. The fetched results from two different sheets is arranged alternatively. But I wish to have the data from one sheet all stacked in sequence and then followed by the data of the second sheet. I'm sure a code optimization is required here but since I'm a beginner unable to do so
2. Also I need the code to ' Copy Planned Closure Date where Date located in Sheet 2(7 Row, 5 Column)and add 15 Man Days to it and place data in Sheet 13 and in Column 8 (The same has been commented in the code)
Below is the Code
Bookmarks