+ Reply to Thread
Results 1 to 3 of 3

Inserting Column

  1. #1
    Registered User
    Join Date
    06-05-2012
    Location
    usa
    MS-Off Ver
    Excel 2007
    Posts
    37

    Inserting Column

    Hey,

    I want to insert a column only if a cell has certain value. In this case if a cell in column G has the text “K” I need a way to insert a column. I have attached the spreadsheet for example.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    02-22-2013
    Location
    London, UK
    MS-Off Ver
    Office 365
    Posts
    1,218

    Re: Inserting Column

    Hi, try this as an example:
    Please Login or Register  to view this content.
    If a cell in column G has the value of "K", it will insert a new column to the right of it. Is this what you want?

    Regards,
    berlan

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

    Re: Inserting Column

    Where would you like to insert the column and do you require any formula or data to be inserted into the cell on the corresponding row? Pleaste try to be specific in your request as we like to help but cannot mind read yet.
    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

+ 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. Inserting column headers text before the content of each cell in a column
    By Spacedone in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-27-2014, 10:18 AM
  2. Replies: 4
    Last Post: 05-03-2014, 07:09 AM
  3. [SOLVED] Macro is inserting cells in one column, need it to insert in 2nd column as well
    By MR22 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-01-2012, 10:23 AM
  4. Inserting new column, hiding oldest column, 12-month total
    By ambiewaq in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-07-2010, 12:39 PM
  5. When inserting a Column, all colors of the LEFT column are copied!!
    By Hutas in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-22-2005, 11:06 AM

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