Results 1 to 5 of 5

Vba that moves cells with text, (up and to left, insert row/ insert copied cell)

Threaded View

  1. #1
    Registered User
    Join Date
    08-30-2018
    Location
    North Bergen, NJ
    MS-Off Ver
    Office 2013
    Posts
    23

    Vba that moves cells with text, (up and to left, insert row/ insert copied cell)

    So I have a formula which is testing some key stuff (unimportant right now) if true then the cells get text, if not then blank. I copy and paste values so it is just blank or text. What I need is if the cells contain text then cut and paste the data above the cells to their immediate left. essentially inserting a new row and moving cells below down. I've included a sample excel of what I need it to do, if anyone can help it would be much appreciated. Thank You! I'm hoping the excel attached, but if it didn't please let me know cause I'm not seeing it even though it says it did.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Macro to insert rows with copied text a certain amount of times based on a value in a cell
    By rhendrickson11 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-21-2017, 11:20 AM
  2. [SOLVED] Select matching cell and insert value 4 cells to the left of selected cell?
    By TomToms in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-03-2014, 11:46 AM
  3. Replies: 3
    Last Post: 10-25-2012, 07:10 AM
  4. [SOLVED] Insert Copied Cells multiple times, shift cell down
    By system in forum Excel General
    Replies: 18
    Last Post: 09-21-2012, 12:47 AM
  5. Insert Copied Cells multiple times, shift cell down
    By system in forum Excel General
    Replies: 1
    Last Post: 09-08-2012, 10:49 PM
  6. [SOLVED] Insert Copied Cells
    By Cyclewench in forum Excel General
    Replies: 2
    Last Post: 04-16-2012, 04:07 PM

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