Results 1 to 4 of 4

Macro to copy specific data from one WB to specific cells in another WB based on specific

Threaded View

  1. #1
    Registered User
    Join Date
    08-16-2012
    Location
    connecticut
    MS-Off Ver
    Excel 2007
    Posts
    14

    Macro to copy specific data from one WB to specific cells in another WB based on specific

    Hello All, I'm looking for help in writing a Macro to copy specific data from one WB to specific cells in another WB based on specific criteria. I have 2 workbooks, one is Bill Of Materials, the other is a Vendor List. What I'm trying to accomplish is using the Vendor name I've entered in the BOM workbook to copy the "Phone" and "Contact" information from the Vendor List workbook to the appropriate Cells and Column in the BOM workbook.

    Any help is greatly appreciated. Thanks in advance

    br/dave r
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. HELP! Macro to Copy specific cells from one sheet to another based on specific criteria
    By atriscritti in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-11-2012, 11:05 AM
  2. Macro to extract data from multiple workbooks, specific sheet, specific cells
    By crissandraauree in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-29-2012, 03:54 PM
  3. Macro to copy specific data to specific columns from a pivot table
    By Raju Radhakrishnan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-09-2012, 07:24 PM
  4. macro needed to sum specific data in specific cells
    By nasser in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-24-2011, 08:11 AM
  5. Replies: 3
    Last Post: 03-28-2011, 10:53 AM

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