Copy & paste filtered data

Hi,

I would like to move a set of rows (Planned Orders) to the left by 1 column, but Excel does not let me paste onto filtered data....I've tried the sort function, but since there are so many formulas in the data sheet, some of the data got messed up....is there a way to solve this? Please see dummy file. (Comments in RED and cells are filtered by column G)

Your help is appreciated!