+ Reply to Thread
Results 1 to 2 of 2

Transfer figures from workbook to master

  1. #1
    Registered User
    Join Date
    09-13-2005
    Posts
    59

    Transfer figures from workbook to master

    Hello I have two workbooks called "master" and "division".

    The "division" workbook has the same sheet names as the ones found in the "master" workbook.

    The "master" workbook has other sheets which do not exist in the "division" workbook.

    I am looking for a macro which will go through the sheets of the "division" workbook and transfer via a vlookup function the "License" numbers to the "master" workbook.

    I attach a sample of the workbooks to make this more clear.

    Please let me know if I have to clarify this further.

    thanks for your help
    andy
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    09-13-2005
    Posts
    59
    any help with this one?

    I understand it might be a bit tricky but I was thinking of using the 'Find' argument in VBA. I will try and make a start on the code but the problem is I don't know how to start !

+ 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