Results 1 to 17 of 17

production report update from packing report.

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-14-2010
    Location
    oman
    MS-Off Ver
    Excel 2003
    Posts
    384

    Post production report update from packing report.

    dear friends i want to update my first sheet from second sheet.second sheet our packing report & it's daily I'm getting from packing department.according to packing report i want to update production sheet.second sheet Column "F" first 6 characters i need to mach with first sheet column "K" first 6 characters.if it is match then first sheet column "J" values need to reduce form second sheet column "G".
    ex- first sheet value = 60
    packing report value = 50 then answer in first sheet column "J" =60-50 = 10
    after updating first sheet column "J" any value coming mines then that row need to delete.
    pls make macro for this.thanks..
    Attached Files Attached Files
    Last edited by johncena; 03-22-2010 at 04:34 AM.

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