+ Reply to Thread
Results 1 to 5 of 5

Putting data from one sheet to another

  1. #1
    Registered User
    Join Date
    06-17-2014
    Location
    USA
    MS-Off Ver
    2010
    Posts
    13

    Putting data from one sheet to another

    I have a spreadsheet with 5 columns (A - E) and over 2000 rows 1 - 2000.
    I was wondering if there is a way to take information (whole row) basiced off one cell and move it to another work sheet.

    Example:

    In one excel document I have two sheets, Sheet 1 titled "Everyone" Sheet 2 titled "YES"

    Sheet 1 A2 has persons name, B2 Address, C2 Phone #, . . . E2 has values Yes or No

    Is there a way I can copy the infromtion from sheet 1 with column E that have a value of "YES" and move it to the other sheet?


    Thank you..

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Putting data from one sheet to another

    Put your cursor on row1. Select the Auto Filter. In column E, click on the drop down arrow. Select only the Yes box.

    The sheet will be filtered for Yeses only. Highlight the range of cells from column A through E and down to the last row displayed. Click on Copy. Paste into the second sheet. Click on the Auto filter to unfilter the range.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    06-17-2014
    Location
    USA
    MS-Off Ver
    2010
    Posts
    13

    Re: Putting data from one sheet to another

    I can not use sort. the spreadsheet has merged cells

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Putting data from one sheet to another

    Alan did not say sort, he said filter
    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

  5. #5
    Registered User
    Join Date
    06-17-2014
    Location
    USA
    MS-Off Ver
    2010
    Posts
    13

    Re: Putting data from one sheet to another

    not quite what i had in mind but a BIG help
    Thank 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. Looking to extract data from two columns and putting them in a new sheet
    By wwballar42 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-28-2014, 10:57 PM
  2. Getting data from Access then putting this in new sheet depending on date?
    By alka5eltzer in forum Access Tables & Databases
    Replies: 1
    Last Post: 11-14-2013, 08:40 AM
  3. Grabbing Data From a UserForm and Putting it Into A Sheet Help Please.
    By richter394 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-01-2013, 03:28 PM
  4. Copying a template sheet and putting those multiple sheets data into a summary sheet
    By John Wolfe in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-18-2011, 06:29 PM
  5. Putting Data in One Sheet
    By Nad in forum Excel General
    Replies: 8
    Last Post: 07-12-2006, 08:14 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