I have A.xls which contains multiple sheets and each sheets has its own name: s1, st2 etc. For each sheets,for example-sheet: “s1” there are columns: “C” to “P”. I want to shift the values from columns: D to O to columns: C to N and leave column O as new column to input the new value in column:O. note that first row contains header. I would like to do the same for other sheets as well until all sheets completed.
Need to shift Jul-19 and Aug-19 columns to one column to the left.
After that, remove the Aug-19 column and add in Sep-19 Column, those cells under Sep-19 will be manual input.
The column A contains formula need to preserve the column A cells. How can this Column A be preserved? For write range activity from sheet 1 to sheet 2, how can this be done?