+ Reply to Thread
Results 1 to 3 of 3

Moving selected data from one column to another

  1. #1
    Registered User
    Join Date
    11-23-2021
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    1

    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
    09-21-2012
    Location
    Botswana
    MS-Off Ver
    Professional Plus 2019
    Posts
    856

    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.

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

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,385

    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

    Regards
    Ford

+ 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

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