+ Reply to Thread
Results 1 to 1 of 1

vba to copy specific columns with unique column records to a closed workbook

  1. #1
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    MS365
    Posts
    1,079

    vba to copy specific columns with unique column records to a closed workbook

    Hello

    I have a workbook in which a specific working sheet with specific columns needs to be copied to a closed master workbook .

    Columns F(reference id) to I, then K, then AH are to copied to the closed databaserecord workbook on sheet master 2017

    Row 1 are headers for each workbook.

    However one criteria is needed are that column F(reference id ) of workings sheets must be unique in copying to columms A (reference id) of closed workbook.

    that is if say reference id in workings sheets is 17067729 ( columns F ), if that reference exists in database records then it should not be copied together with requested specific columns

    But if reference id columns F (17067729) does not not exists in data base records column A then copy Columns F(reference id) to I, then K, then AH are to copied to database records .

    the database recordscworkbook have the path c:\\dabase 2017

    However when finishing copy, can a message box appear specify the no of unique records copied to master work and no of duplicates not copied

    Can anyone help for a vba code .


    the workings book are about rows 6000 rows of data, sometimes it may have 2000 rows or 3500 rows
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] vba code to copy a specific sheet from a closed workbook to the active workbook
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-01-2017, 03:09 AM
  2. [SOLVED] vba copy specific sheet from closed workbook to active workbook
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-12-2017, 01:33 PM
  3. [SOLVED] copy specific sheet from closed workbook to active workbook
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-10-2017, 10:26 PM
  4. vba copy specific sheet from closed workbook to active workbook
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-09-2017, 02:34 PM
  5. [SOLVED] Copy Select Columns from closed workbook into active workbook
    By 3345james in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-09-2015, 02:04 PM
  6. Run Macro in closed workbook and copy specific coloumn in active workbook
    By shiva_reshs in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-07-2013, 03:43 AM
  7. Macro to copy row to specific sheet in closed workbook
    By newbie-excel in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-04-2013, 12:51 PM

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