+ Reply to Thread
Results 1 to 2 of 2

move a line of by adding info into 1 of 3 specific cells at the end of the line

  1. #1
    Registered User
    Join Date
    03-08-2017
    Location
    arlington texas
    MS-Off Ver
    2010
    Posts
    1

    move a line of by adding info into 1 of 3 specific cells at the end of the line

    Hello,
    Attempting to move a line of cells to a designiated line "RESOLVED" area on the same sheet. that will also color code it light blue. the line will move automaticly by entering data into one of 3 specific cells on the same line....so
    Data in A4,B4,C4,D4,E4,F4,G4,H4,I4,J4, K4, L4, THEN....enter data into 1 of the following 3 cells (M4, N4, O4) will move this entire line to A50 (for example) there could be up to 80 lines of specific data that would need to be moved as each line is completed to the area below line i.e. 50 also wanted it to color light blue to show completed.

    thanks for any help,

    E.

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,922

    Re: move a line of by adding info into 1 of 3 specific cells at the end of the line

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ 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. Replies: 3
    Last Post: 03-12-2017, 03:39 PM
  2. Replies: 1
    Last Post: 01-28-2015, 09:11 PM
  3. Replies: 1
    Last Post: 04-05-2013, 03:40 PM
  4. Difficulty adding a trend line to line graph in Excel 2007
    By jmatoske in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 11-28-2012, 02:59 PM
  5. Replies: 6
    Last Post: 11-26-2012, 05:17 AM
  6. [SOLVED] How do I move a line marker on a line column combination chart?
    By dknj30 in forum Excel General
    Replies: 7
    Last Post: 05-08-2012, 09:21 AM
  7. Select row, move data to specific line in new worksheet
    By itsunclebill in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-22-2011, 10:38 PM

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