+ Reply to Thread
Results 1 to 4 of 4

excel vba vlookup for updation of workbooks

  1. #1
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    excel vba vlookup for updation of workbooks

    any vba experts help me on this..........urgent and helpful

    i have 2 region worksheet(north,south) in folder and one master workbook I want get current status of updates according to values of order no in column C:C master workbook.

    status updates range is E to k column if any changes in any one of sheet values i get updates in master sheet range (E:K)

    e.g if in south WORKBOOK COLUMN C BY ORDER NO 7005233137 TOWARDS COLUMN (E,F,G,H,I,J,K) MAKE ANY STATUS UPDATES

    IF I CLIK CMD BUTTON IN MASTER IT PULL DATA FROM SOUTH TOWARDS RESULT OF ORDER NO of 7005233137.

    i enclosed all sheets with this thread

    every time clicking cmd button remove old status and updates new updates
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor tehneXus's Avatar
    Join Date
    04-12-2013
    Location
    Hamburg, Germany
    MS-Off Ver
    Work: MS-Office 2010 32bit @ Win8 32bit / Home: MS-Office 2016 32bit @ Win10 64bit
    Posts
    944

    Re: excel vba vlookup for updation of workbooks

    Hi,

    try the update button in:MASTER.xlsm
    Please use [CODE]-TAGS
    When your problem is solved mark the thread SOLVED
    If an answer has helped you please click to give reputation
    Read the FORUM RULES

  3. #3
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    Re: excel vba vlookup for updation of workbooks

    HI dude

    Thanks Alot Its work perfectly but i need solution for new range help me on this

    I tried to reassign the range of column index (BN:BV)only which appear in yellow color index (In Master & Region Workbook(north & south)
    but result Unknown Region!! I might be wrong at refer the values

    Can you help me on this with your solution?

    I uploaded sheets here pls find...

    Thanks alot
    Attached Files Attached Files

  4. #4
    Valued Forum Contributor tehneXus's Avatar
    Join Date
    04-12-2013
    Location
    Hamburg, Germany
    MS-Off Ver
    Work: MS-Office 2010 32bit @ Win8 32bit / Home: MS-Office 2016 32bit @ Win10 64bit
    Posts
    944

    Re: excel vba vlookup for updation of workbooks

    try
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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