+ Reply to Thread
Results 1 to 4 of 4

Data Relationship?

Hybrid View

Q-D Data Relationship? 11-26-2009, 12:44 PM
Palmetto Re: Data Relationship? 11-26-2009, 05:35 PM
stanleydgromjr Re: Data Relationship? 11-26-2009, 06:38 PM
Q-D Re: Data Relationship? 11-27-2009, 10:13 AM
  1. 11-26-2009, 06:38 PM #1
    stanleydgromjr is offline
    Forum Expert
    Join Date
    10-10-2008
    Location
    Northeast Pennsylvania, USA
    MS-Off Ver
    Excel 2007
    Posts
    2,387

    Re: Data Relationship?

    Q-D,

    See the attached workbook "Data Filter AutoFilter - Q-D - SDG10.xls", with your raw data on worksheet "Output", and two additional worksheets "Orders", and "OtherPartNumbers".

    There is a command button on worksheet "Output", "Get Others".

    Click on the command button, and all the other "Order Numbers" (and data) that contain the same "Part Number" as the "Part Number" in cell G2, will be copied to worksheet "OtherPartNumbers", less the rows that may contain the "Part Number" in cell G2.

    We have gone from 6,999 rows of data in worksheet "Output", to 566 rows of data in worksheet "OtherPartNumbers".

    Detach/open the workbook and click on the command button on worksheet "Output", "Get Others".
    Attached Files Attached Files
    Have a great day,
    Stan

    Windows 10, Excel 2007, on a PC.

    If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
    Reply With QuoteRegister To Reply
  2. 11-27-2009, 10:13 AM #2
    Q-D is offline
    Registered User
    Join Date
    03-20-2008
    Posts
    11

    Re: Data Relationship?

    Fantastic!!

    Thankyou both for your help, much more than I expected I was hoping for a direction not the actual outcome.

    It does amaze me the skills some people have!

    Thanks
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1