+ Reply to Thread
Results 1 to 1 of 1

Macro to Copy from 2 Columns, Paste Value in the next 2 Columns, Then clear 1st Columns

  1. #1
    Registered User
    Join Date
    01-20-2014
    Location
    Eugene, OR
    MS-Off Ver
    Excel 2007
    Posts
    1

    Macro to Copy from 2 Columns, Paste Value in the next 2 Columns, Then clear 1st Columns

    I have worksheets that compare month by month totals between years. Each Year I need to move the previous month over two columns and then clear the first two columns for input of the current year, doing this for each month.

    After the values from Column B has been pasted as Value in Column D (hopefully not pasting over formulas in Column D) I would like Column B to remove the numbers, leaving the formulas, dates and text untouched.

    This goes on for 3 months, and then there are Quarter To Date columns which contain formulas. Those need to remain untouched also.

    I have attached an example sheet.

    1 Rev/Exp Miles Rev/Exp Miles
    2 01/31/14 01/31/14 01/31/13 01/31/13
    3 22 23 22 2,004,423
    4
    5 20000.00 (formula)
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 03-02-2014, 11:55 AM
  2. macro to add columns after existing columns and copy/paste headers and formulas
    By rhybeka in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-21-2013, 02:35 PM
  3. [SOLVED] Copy/Paste multiple columns as values based on another columns criteria
    By Dgp2012 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-28-2013, 06:50 AM
  4. [SOLVED] Faster way to copy and paste multiple columns in Sheet1 to corresponding columns in Sheet2
    By babbeleme1 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-19-2013, 12:55 AM
  5. Replies: 8
    Last Post: 04-04-2013, 08:02 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1