+ Reply to Thread
Results 1 to 2 of 2

Vba - find next empty column, insert column, copy paste values & copy paste formulas

  1. #1
    Registered User
    Join Date
    09-05-2012
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2013
    Posts
    71

    Vba - find next empty column, insert column, copy paste values & copy paste formulas

    I am creating a report that will be updated monthly then create charts with the newly pulled data. I need to create code that will:
    Calculate current date, determine previous month's 1st and last dates
    find last column that contains data
    copy & paste values of that column (within that same column)
    find the next available blank column and insert a new column
    copy the master formula column
    paste formulas in the newly inserted column
    calculate
    Hide any columns older than 6 months.
    Attached Files Attached Files
    Last edited by DoodlesMama; 12-20-2012 at 04:18 PM. Reason: ADDED ATTACHMENT AGAIN

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    18,239

    Re: Vba - find next empty column, insert column, copy paste values & copy paste formulas

    Unable to open your file. My system gives me two error messages. One indicating that it is already open by someone else and that the file extension is invalid. I am operating EXCEL 2010 and I have no other instances of excel open. I believe that your file may be corrupted. Please try re-creating and uploading again.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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