+ Reply to Thread
Results 1 to 3 of 3

Moving selected data from one column to another

  1. #1
    Registered User
    Join Date
    North Carolina
    MS-Off Ver

    Moving selected data from one column to another

    I need the formula to extract these specific items moved to their own column. I can't figure out the formula to do so.

    Thanks in Advance
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor PeteABC123's Avatar
    Join Date
    MS-Off Ver
    Professional Plus 2019

    Re: Moving selected data from one column to another

    Hi Christianne: Welcome to the forum.

    An excel file containing a brief example of your sanitized data which shows your desired result would be a better file to attach.

    Last edited by PeteABC123; 11-23-2021 at 01:02 PM.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16

    Re: Moving selected data from one column to another

    If you mean you want to physically move the data to another location, so that it no longer exists in it's original location (rather than just copy the data elsewhere and have the original data stay where it is), you cannot do that with a formula, you will need VBA.
    Last edited by FDibbins; 11-24-2021 at 12:19 AM.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you


+ 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. [SOLVED] userforms needed for moving data from columns to match selected destination column.
    By Johnny247 in forum Excel Programming / VBA / Macros
    Replies: 64
    Last Post: 05-20-2021, 11:23 AM
  2. Replies: 4
    Last Post: 05-22-2020, 04:01 AM
  3. Replies: 4
    Last Post: 08-14-2018, 09:10 AM
  4. Replies: 1
    Last Post: 03-05-2016, 04:04 PM
  5. Replies: 5
    Last Post: 02-07-2012, 04:55 PM
  6. Im looking for help moving and organizing selected data to another sheet inv workbook
    By cadamhill in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-04-2010, 05:03 AM
  7. Moving selected data
    By Stu-Gnu in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-11-2005, 01:06 PM


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