Results 1 to 9 of 9

update record sheet from production sheet

Threaded View

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

    Post update record sheet from production sheet

    dear friends here i have attached my document.in my document first sheet I'm keeping record about my daily production.second sheet is my production report.what i want to do is production report data should copy to first sheet correct place,for that second sheet column "B" first 6 characters need to mach with sheet one column "M".if it is matched then sheet two same row column "G" values should copy to first sheet column "N".if at that time any values are already there then don't overwrite that values & new values should combined.
    ex-
    old value = 5
    new value = 10
    after running macro =5+10
    pla any body can make macro for this.it's very big help for me.thanks.
    Attached Files Attached Files
    Last edited by johncena; 03-19-2010 at 07:00 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