+ Reply to Thread
Results 1 to 3 of 3

VB to return whole column in different work book

  1. #1
    Registered User
    Join Date
    06-12-2014
    Posts
    61

    VB to return whole column in different work book

    Good day,

    I wondered if someone could help with a piece of code that could search/match a column name (call is "Product Title") from a different workbook (wb1) and return the columns contents to the wb the code will be in (wb2)

    Many thanks

    Russ

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,425

    Re: VB to return whole column in different work book

    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Expert
    Join Date
    10-11-2021
    Location
    Netherlands
    MS-Off Ver
    365
    Posts
    1,381

    Re: VB to return whole column in different work book

    When both files are open

    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)

Similar Threads

  1. Auto save work book to two work book file names
    By HORA018 in forum Excel General
    Replies: 0
    Last Post: 03-13-2022, 01:28 PM
  2. Current work book .xlsm convert to xlsx work book then mail
    By Vcare in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-26-2016, 09:47 AM
  3. VBA Code for populating cells from one Work Book A to another Work Book with condition
    By ray.kanata in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 06-22-2015, 03:46 PM
  4. Replies: 2
    Last Post: 05-03-2013, 11:13 PM
  5. Replies: 2
    Last Post: 06-20-2012, 05:10 AM
  6. Copy active sheet to a new workbook, close that work book and return
    By nig_44 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-30-2012, 02:24 AM
  7. Replies: 5
    Last Post: 06-15-2010, 09:52 AM

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