i have a excel workbook and it contains 2sheets i.e. sheet1 and sheet2 which is also attached herewith for ready reference
i want a vba code to add 10 blank rows before the First #N/A of Col-H of Sheet1 (first #N/A exist in H16, add 10 blanks rows before H16)
after that i want to add the data which is exist in Sheet2 "Col-A2 to G2" and put it after H15 in Sheet1..........after that make a total of Col-F in the very next row
Bookmarks