title: Copy and paste last used column into next available column
body: <p>I know this has probably already been answered but I have searched through the previous questions and cannot find an answer that works for me.</p>
  
  <p>Basically I have an excel spreadsheet which can be updated daily/weekly/monthly depending on the workflow. What I need is a macro that finds the last 'used' column(Headers are in row 5), inserts a blank column directly to the right of that - (we have a totals table at the end that needs to move along) &amp; copies the entire last used columns data into that newly created column.</p>
  
  <p>It's probably quite a simple code but I've only just started using VBA and hope someone can help!! I'm hoping once I've started doing some bits and pieces I can build up my knowledge!</p>
  
  <p>Thanks in advance</p>
  
  <p>Emma</p>