I want a VBA code which looks at column G and find blank cells , and then delete the row cells from column A to O and shift cells up. For result to look like the second pic. If I delete entire row, the button gets deleted, which I dont want.
Thank you in advance
Thank you in advance