+ Reply to Thread
Results 1 to 1 of 1

How to insert column based on Cell Values

  1. #1
    Registered User
    Join Date
    08-27-2013
    Location
    SG
    MS-Off Ver
    2010
    Posts
    12

    How to insert column based on Cell Values

    I have a worksheet where I must insert a column every time the user selects 2 values (found in Pricelists sheet).

    So Basically whenever a user chooses the Quote LP, or the Sell on web Values from the cell dropdown, I must insert a column adjacent to the value.

    So for example if a user selects cell G5 and selects Sell on web, a column must appear between G and H. The column must read "List Price", in cell H5.

    If the new list price column can have a "collapse" button in cell H5 that will cause the column to hide, that would be amazing as well.

    Thank you and I apprecaite any and all the help!!
    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. Insert rows based on values in column
    By scott p in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-11-2013, 01:58 PM
  2. Replies: 2
    Last Post: 03-12-2013, 04:10 PM
  3. [SOLVED] Insert Rows, based on values in a column, for a 300,000 row dataset
    By engineerlady in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-04-2013, 04:47 PM
  4. Insert New Column Based Upon Unique Values
    By kasperblue in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-17-2012, 04:35 PM
  5. After insert new record, insert values in row based on first cell in row
    By frankienap in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-04-2012, 11:36 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