Results 1 to 16 of 16

Export data from one excel to another based on a common ID using macro instead of Vlookup

Threaded View

Deepa12 Export data from one excel to... 10-09-2012, 11:03 PM
rylo Re: Export data from one... 10-10-2012, 12:38 AM
Deepa12 Re: Export data from one... 10-10-2012, 04:56 AM
rylo Re: Export data from one... 10-10-2012, 05:59 PM
Deepa12 Re: Export data from one... 10-10-2012, 09:46 PM
Deepa12 Re: Export data from one... 10-10-2012, 09:53 PM
rylo Re: Export data from one... 10-10-2012, 10:04 PM
Deepa12 Re: Export data from one... 10-10-2012, 10:34 PM
jindon Re: Export data from one... 10-10-2012, 10:19 PM
jindon Re: Export data from one... 10-10-2012, 10:40 PM
Deepa12 Re: Export data from one... 10-10-2012, 10:52 PM
jindon Re: Export data from one... 10-10-2012, 11:08 PM
Deepa12 Re: Export data from one... 10-10-2012, 11:38 PM
jindon Re: Export data from one... 10-10-2012, 11:50 PM
jindon Re: Export data from one... 10-11-2012, 03:37 AM
Deepa12 Re: Export data from one... 10-11-2012, 04:37 AM
  1. #1
    Registered User
    Join Date
    10-04-2012
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    46

    Export data from one excel to another based on a common ID using macro instead of Vlookup

    Hi Experts,
    I have had valued experts helping me before. I request there help now too, to solve mine as macros are new to me.
    I have a Master file and a Monthly file.
    I need to export certain column data from Master to Monthly file based on a common ID " CostCentre+ B ID", available in both the files.
    I can do this using vlookup,but my boss wants to run a macro to automate this, as there are several columns to do vlookup.

    I have put a example file.

    Can experts help me this.
    Attached Files Attached Files

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