title: Python: copy/paste columns
body: <p>I'm working with an excel file using openpyxl. I want to copy all the formulas I have in column GD and paste them in column GE in the same excel tab. How can I do this so the formulas update in the new column?</p>
  <pre><code>from openpyxl import load_workbook
  workbook = load_workbook('filename.xlsx')
  sheet= workbook.worksheets[8]
  sheet.insert_cols(187)
  sheet.column_dimensions['GE'].width= 14.55
  sheet.column_dimensions['GG'].width= 14.55
  sheet.column_dimensions['GF'].width= 14.55
  sheet.column_dimensions['GH'].width= 3
  </code></pre>
  <p>Many solutions show how to copy a column and paste in another tab of the excel file but I need to copy and paste in the same sheet.</p>
  <p>Here's an updated code</p>
  <pre><code>for cell in sheet['GD3:GD67322']:
  print(str(cell.column) + str(cell.row))
  sheet.cell(row=cell.row, column=187, value=cell.value)
  </code></pre>
  <p>What else needs to be changed in that code if I want GD3:GD67322 to be pasted in column GE at row 3?</p>