Closed Thread
Results 1 to 2 of 2

Automatic Column Deletion and Addition by Date

  1. #1
    Registered User
    Join Date
    01-18-2019
    Location
    London, England
    MS-Off Ver
    2016
    Posts
    87

    Automatic Column Deletion and Addition by Date

    Hi guys,

    I have attached a spreadsheet, I'm creating a report. I would like to keep it on rolling 12 months. What I would like that every month when I enter the date at the top the following should happen automatically :

    1. Column 'B' removed
    2. Column 'C' to 'M' move from Column 'B'
    3. Column 'M' automatically add another Month

    I have attached the spreadsheet for your reference. Please can someone help me urgently as I need to submit the project by tomorrow.
    Attached Files Attached Files

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Automatic Column Deletion and Addition by Date

    Welcome to the Forum, unfortunately this is a duplicate post and as such will now be closed, you may continue in your other thread. Please read the forum rules and comply with them. Do not create duplicate threads. Please amend the title in your earlier thread as requested. Continued abuse of the forum rules may result in infractions and possible banishment. Do not let this happen to you.

    Thread Closed.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Columns addition and deletion
    By abac in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-07-2019, 11:32 PM
  2. Replies: 1
    Last Post: 09-13-2017, 06:35 PM
  3. Apply formulas on row Addition/deletion
    By linok in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-10-2014, 07:20 AM
  4. Macro to update row addition/deletion across multiple worksheets
    By lorigies in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-07-2014, 09:24 AM
  5. [SOLVED] Excel 2007 : Column data transfer and automatic data deletion
    By shelbert13 in forum Excel General
    Replies: 4
    Last Post: 06-19-2012, 12:24 PM
  6. Addition and Deletion
    By ravi_m5_2000 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-13-2009, 10:06 AM
  7. protect columns (prevent addition or deletion)
    By qwertyjjj in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-16-2006, 04:20 AM

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