Hi,
I have sheet "Working". In this I have a column with Heading New Sheet1, New Sheet2, New Sheet3, New Sheet4, New Sheet5 and New Sheet6.
I need a macro to find above Heading New Sheet1, New Sheet2, New Sheet3, New Sheet4, New Sheet5 and New Sheet6 in Row number 1 and if it exist then delete those columns.
And find last filled column in the same sheet and add new 6 columns with same heading New Sheet1, New Sheet2, New Sheet3, New Sheet4, New Sheet5 and New Sheet6
The Column heading format should be in Red font.bold and backgroung yellow colour
Bookmarks