+ Reply to Thread
Results 1 to 3 of 3

Moving Data From External Sheet to an internal Working Sheet & Transfers to View Sht

  1. #1
    Forum Contributor
    Join Date
    12-10-2008
    Location
    Austin
    Posts
    660

    Moving Data From External Sheet to an internal Working Sheet & Transfers to View Sht

    Hi all,

    Here's some lines from a code that moves specific data from spreadsheets named *BOM* to an Working Sheet within my booklet.
    From there, I've got another subcode that will insert the data from
    the working sheet to the output sheet called, Non_Completed.

    The qty values from gets moved w/no issues.
    It will match up with the correct value in column A.
    But I have tried to insert a few more lines w/same code structure to move other data from the BOM's into the working folder and get actioned out
    to the Non_Completed, but, these values are not showing up on the correct
    item rows.

    Here's part of the code that brings in the values from the BOM's.
    Please Login or Register  to view this content.
    Here's the part of the code that transfers items from the Working_Non_Complete to the output sheet,Non_Completed.

    Please Login or Register  to view this content.
    I really could use some professional assistance in pointing out
    whats causing this to happen. I've been tryiing to figure this out for hours
    apon hours, and I've grown frustrated and fatigued.
    Any help would be greatly appreciated.

    Thanks,
    bdb

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: Moving Data From External Sheet to an internal Working Sheet & Transfers to View

    Hello bdb1974,

    When posting about problems, please don't use general terms like "it doesn't work", "the code breaks when it runs", etc. Please indicate what the problem is. The data is being written to the wrong cell (cell address), an error occurs (error message or number), etc. Once the problem is properly stated, a solution can be provided.
    Last edited by Leith Ross; 03-20-2009 at 11:55 PM.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Forum Contributor
    Join Date
    12-10-2008
    Location
    Austin
    Posts
    660

    Re: Moving Data From External Sheet to an internal Working Sheet & Transfers to View

    All,

    Sorry for not stating myself clearly.
    All, item numbers, from column A & all Qtys of these items, from column D, from booklets called *BOM*'s, gets transferred or built to column A on a sheet named Working_Non_Completed in my Programs workbook. After
    all data has been transferred, the data gets rebuilt onto an output sheet
    called Non_Completed. This process works fine. Now, I'm wanting to transfer more data in from the BOM's. This data will be coming from columns,
    B, I,&J. I tried to used the same scripting for what brings in the QTY. values,
    however, the data from these columns are not being brought into the correct
    rows for the output sheet.

    In my last post, I've posted segments of the code which handles bringing in this data. I've also added comments to the lines to state what these lines do.

    Any help is appreciated.

    THanks,

    bdb

+ 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