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

Thread: See Below

  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 have Data from B2:R500.
    In Col Q is my Salesman Code (026, 029, etc).

    I've sorted the SSheet by Salesman Code, then by Customer, then by Inv#.
    I've then used a Data Filter to only show the 026 Sales Code. My intent is to Cut the 026 data from B2:B40 and paste it to another Sheet in the Workbook. I did this by going to B2 and hit CTRL + Shift + END (which hi-lites the lines I need).
    However when I do so, it copies over all 500 lines rather that the 39-40 I need.
    Is there a way around this?
    Recording the MAcro will be easy if I can get by this snag.

    Should I even be using the Data Filter?
    I thought maybe I could somehow look in Col Q and where the data ends for SAlesman 026, insert a blank line. Then when I use CTRL + SHIFT + End from B2, the Cut and Paste would be easy. However, I don't know how to accomplish this either.

    I can then do the same for the other Salesman.

    Need someones help or Suggestions.

    Thanks,
    Zac

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Ahmedabad Gujarat
    Posts
    303
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Instead of using try using

    Advance filter

    It will give you the option where to post your data.. criterial etc.

    in advance filter you select the range as per your need only.

    ni****h desai
    http://www.pexcel.com
    ni****h desai
    Mindful act is consecration only road to salvation.

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Ontario
    Posts
    52
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-18 06:26, Zac wrote:
    I have Data from B2:R500.
    In Col Q is my Salesman Code (026, 029, etc).

    I've sorted the SSheet by Salesman Code, then by Customer, then by Inv#.
    I've then used a Data Filter to only show the 026 Sales Code. My intent is to Cut the 026 data from B2:B40 and paste it to another Sheet in the Workbook. I did this by going to B2 and hit CTRL + Shift + END (which hi-lites the lines I need).
    However when I do so, it copies over all 500 lines rather that the 39-40 I need.
    Is there a way around this?
    Recording the MAcro will be easy if I can get by this snag.

    Should I even be using the Data Filter?
    I thought maybe I could somehow look in Col Q and where the data ends for SAlesman 026, insert a blank line. Then when I use CTRL + SHIFT + End from B2, the Cut and Paste would be easy. However, I don't know how to accomplish this either.

    I can then do the same for the other Salesman.

    Need someones help or Suggestions.

    Thanks,
    Zac
    Once you've displayed the filtered rows, go to EDIT/GO TO.../SPECIAL and select VISBLE CELLS ONLY
    then your operation wuill only copy the filtered rows instead of the whole sheet.

    Hope this is what you're after?

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

    Default

      
    Thanks Big Blue. Worked Great.

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
  •  

 

 
DMCA.com