Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Cutting from a Data Filtered Sheet

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Mike
    Posts
    796
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I tried the suggestions offered yesterday on the following, but I have a slight problem.

    I have data from B2:R500.
    I sorted that range by Salesman Codes.
    Set my Data Filter, select the drop dowm menu for the Salesman Code and click on Custom (Equals 029 or Equals 008).
    All displays perfectly.
    Data for 029 runs from rows B2:B50
    Data for 008 runs from B92:B180.

    I then CTRL+END to select it all, Ctrl+X.
    I then GOTO Edit, Special, and check off
    "Visible Cells Only". Then I paste the data to another sheet.

    Everything shows from B2 to B180, rather than from
    B2:B50 and B92:B180. Even though the data from B51:B91 wasn't visible, it displayed it on the Cut sequence.

    Can anyone figure out what IO did wrong?

    thanks for your help,
    Zac

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Cut doesn't work like Copy does on a filtered list. Consider using Copy/Paste and then go back and Clear Contents on the displayed rows of the filtered list.

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Mike
    Posts
    796
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Awesome.

    Thanks for your help.

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    OK any idea

    if filters this date is sortable ie sort it so to custom whatever and the the data will line up and copy selection as reqd and paste..

    Tgis is common and easy to do then un sort ie return to original state

    take seconds.. nice trick!

    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •