+ Reply to Thread
Results 1 to 1 of 1

VLOOKUP from another workbook to first column with same name

  1. #1
    Registered User
    Join Date
    04-26-2022
    Location
    Czech Republic
    MS-Off Ver
    2016
    Posts
    10

    VLOOKUP from another workbook to first column with same name

    Hello guys,

    Please can you help me? I have one workbook with macro, dummy2.xlsm. I need if I’ll clik on macro, than put iferror(vlookup) into first blank cell in row 7. Source is in dummy_source.xls, but most difficult part for me is: There are more tables, I need to find same table like in dummy2.xlsm row 5 and put there formula and drag it down.

    Values in row 5 are added continuously, so I need fill one column by one click.

    dummy_source.xls is editing manually, so I can place name of the table everywhere where is better for macro.

    Thank you for helping.
    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. Trying to VLookup from separate workbook based on a value in a column.
    By IainLewis in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-29-2021, 10:49 PM
  2. Lookup date in a column on SharePoint workbook and copy column to current workbook
    By alimsab in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-21-2020, 11:20 AM
  3. [SOLVED] Need VBA code for Multiple Column Vlookup from another workbook
    By Pankaj jaswani in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-16-2020, 07:53 AM
  4. Replies: 12
    Last Post: 07-03-2013, 01:35 PM
  5. [SOLVED] Compare Column C Workbook A with Workbook B, Column C across multipal Worksheets
    By GatorsBucs in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-28-2013, 02:05 PM
  6. [SOLVED] fill column with vlookup formula to other workbook that depends on cell value
    By knick12 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-23-2012, 03:11 AM
  7. Replies: 6
    Last Post: 09-27-2011, 02:11 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