Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Sep 2013
    Thanked 0 Times in 0 Posts

    Writing to cells in Excel 2003


    I have an Excel 2003 Workbook that contains some 3500 inventory items listed on sheet2 under the column headings "Part Number", "Description", "Alternate Part Number(s)" "Location" and "Qty."
    Sheet1 of the workbook will search the "Part Number" and "Alternate Part Number" columns of sheet2 for the part number entered in cell B4 and display (on row 7) all the pertinent info from sheet2 for that part number. I'm using COUNTIF and MATCH functions to accomplish this and it works fine. Also note that cell H1 displays the row number (in this instance row 3) where the part number exists on sheet two.

    Now I would like to be able to make corrections to the columns in sheet1, row 7 and have that information written to the appropriate cell in sheet2.
    As an example: If I were to change the location in cell F7 of sheet1, cell F3 of sheet2 would also be updated with that change.

    Can this be done with functions as I'm not very fluent with VBA.

    Any help is greatly appreciated.

    Attached Files Attached Files
    Last edited by mrg99; 2013-09-14 at 17:22.

  2. #2
    Join Date
    Apr 2012
    Abergavenny, Wales, UK
    Thanked 3 Times in 3 Posts

    It would be far more helpful if you uploaded your workbook rather than PDF's.
    I would question why you do this on 2 separate sheets?
    If you created an are at the top of your sheet 2 to enter the Part Number required, you could then use either Autofilter or Advanced Filter to display that part only.
    Then any amendment you make will be saved against the one and only entry of that part.
    Roger Govier
    Microsoft Excel MVP

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Pittsburgh, Pennsylvania, USA
    Thanked 342 Times in 335 Posts
    I think you need to create a form. Without VB you can use Excel's Built-in Forms:
    Goto a record in Sheet2
    Data - form
    The data will be shown in "Form view"
    [Criteria] button gives an empty form, and you can add search and then Find...

    It is not customizable, but there is a FREE addin from John Walkenbach at that may be useful as well.


Posting Permissions

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