+ Reply to Thread
Results 1 to 3 of 3

Goods In Sheet Problem

  1. #1
    Registered User
    Join Date
    01-29-2006
    Posts
    12

    Goods In Sheet Problem

    I AM TRYING TO SET UP A SIMPLE COMMUNICATIONS SHEET WITH 'GOODS IN'.
    I HAVE A PARTS LIST WITH SAY: A3 SUPPLIER, B3 GOODS DESCRIPTION, C3 No. OFF, D3 ORDER No.
    NOW, WHEN THE ORDER No. IN D3 IS ENTERED I WANT THE ROW (A3 TO D3) TO BE COPIED TO THE GOODS IN WORKBOOK/SHEET. THE 'GOODS IN' SHEET WILL THEN DISPLAY ALL PARTS DUE IN.
    THE 'GOODS IN' SHEET SHOULD HAVE A TICKBOX IN SAY CELL E3 THAT WHEN TICKED WILL DISPLAY "RECIEVED" ON THE PARTS LIST SHEET IN CELL E3. aNY HELP WITH THIS WOULD BE GREAT AS IM USELESS AT VB. THERE IS ONE OTHER THING, IN THAT THERE WILL BE MULTIPLE PARTS LISTS TO BE DISPLAYED ON THE ONE GOODS IN SHEET.

  2. #2
    NickHK
    Guest

    Re: Goods In Sheet Problem

    You are probably not going to get many replies to build a whole "system" for
    you.
    At least make a start yourself and ask specific questions when you get
    stuck.

    NickHK

    "alanled" <alanled.2cy3jf_1156256407.9593@excelforum-nospam.com> wrote in
    message news:alanled.2cy3jf_1156256407.9593@excelforum-nospam.com...
    >
    > I AM TRYING TO SET UP A SIMPLE COMMUNICATIONS SHEET WITH 'GOODS IN'.
    > I HAVE A PARTS LIST WITH SAY: A3 SUPPLIER, B3 GOODS DESCRIPTION, C3
    > No. OFF, D3 ORDER No.
    > NOW, WHEN THE ORDER No. IN D3 IS ENTERED I WANT THE ROW (A3 TO D3) TO
    > BE COPIED TO THE GOODS IN WORKBOOK/SHEET. THE 'GOODS IN' SHEET WILL
    > THEN DISPLAY ALL PARTS DUE IN.
    > THE 'GOODS IN' SHEET SHOULD HAVE A TICKBOX IN SAY CELL E3 THAT WHEN
    > TICKED WILL DISPLAY "RECIEVED" ON THE PARTS LIST SHEET IN CELL E3. aNY
    > HELP WITH THIS WOULD BE GREAT AS IM USELESS AT VB. THERE IS ONE OTHER
    > THING, IN THAT THERE WILL BE MULTIPLE PARTS LISTS TO BE DISPLAYED ON
    > THE ONE GOODS IN SHEET.
    >
    >
    > --
    > alanled
    > ------------------------------------------------------------------------
    > alanled's Profile:

    http://www.excelforum.com/member.php...o&userid=30949
    > View this thread: http://www.excelforum.com/showthread...hreadid=574189
    >




  3. #3
    Registered User
    Join Date
    01-29-2006
    Posts
    12
    Thanks for that advice, its just that I dont relly know where to start, and a little pointer in the right direction would be great

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1