Hi,
I am in need of help with a VBA. I have multiple worksheets in a workbook. For all worksheets within this workbook I need to add a blank row above row 10 (new row becomes row 10). In this new row I need the following to be gathered from the specific worksheet that the row has been added to;
A10 = C7
B10 = B7
D10 = "Sub Assembly "&Right(B7,2)
Thank You
Bookmarks