Hello All,
I am actually working on a reporting file. I wish to have a VBA code which moves the columns from sheet1 to sheet2 if the last cell of the column contains a specific word. Can someone help me please? For example the values are from column B, first row is 3 and last row is 84 and if it contains completed or inactive, the entire column is moved to Sheet2 and deleted in Sheet1.
That would be really nice if someone could help me
I am actually working on a reporting file. I wish to have a VBA code which moves the columns from sheet1 to sheet2 if the last cell of the column contains a specific word. Can someone help me please? For example the values are from column B, first row is 3 and last row is 84 and if it contains completed or inactive, the entire column is moved to Sheet2 and deleted in Sheet1.
That would be really nice if someone could help me