+ Reply to Thread
Results 1 to 3 of 3

How to Recognize and Copy a Row of Data from a Closed Workbook

  1. #1
    Registered User
    Join Date
    05-20-2020
    Location
    Newark, Delaware
    MS-Off Ver
    2016
    Posts
    2

    How to Recognize and Copy a Row of Data from a Closed Workbook

    I want to pull data from one Excel file to another. This a formulation sheet that I want the date pulled to. Once a tradename is recognized, I would like for the INCI, supplier, and function to be automatically populated. The name of this file is Formulation Template Draft 2020.

    Formulation Sheet.png


    I want it pulling from this file, called 2020 Ingredient List With Contacts.

    Master Formulation Sheet.png


    I know very little about Excel. This was successfully done by an employee before me, but it fell apart when used on different computers and when the master list was edited. I don't know what formula was used or how to do this. I tried looking it up, but I cant seem to get much further than messing around with the formulas that I don't fully understand and I have not ventured into VBA, which is where I will likely land. Thank you so much.

  2. #2
    Registered User
    Join Date
    05-23-2020
    Location
    Guwahati, Assam, India
    MS-Off Ver
    2019
    Posts
    23

    Re: How to Recognize and Copy a Row of Data from a Closed Workbook

    You can get the same done via VLOOKUP formula
    Asha Kanta Sharma
    Guwahati, India

  3. #3
    Registered User
    Join Date
    05-20-2020
    Location
    Newark, Delaware
    MS-Off Ver
    2016
    Posts
    2

    Re: How to Recognize and Copy a Row of Data from a Closed Workbook

    When I Googled my question, some people said I could use VLOOKUP or INDEX, but I am unsure of how to use either

+ 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] VB Code to copy data from closed workbook to another closed workbook
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-10-2020, 01:40 PM
  2. Replies: 25
    Last Post: 01-15-2018, 04:32 AM
  3. Replies: 0
    Last Post: 03-27-2014, 12:38 PM
  4. [SOLVED] Code to copy data from a closed workbook and paste in active workbook using named range.
    By paullie1912 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-28-2014, 02:38 AM
  5. Copy Data from Closed workbook (bbb.xls) to Open workbook (aaa.xls) (Part 2)
    By alexnkc in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-23-2013, 02:06 AM
  6. [SOLVED] Copy Data from Closed workbook (bbb.xls) to Open workbook (aaa.xls)
    By alexnkc in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-22-2013, 03:24 AM
  7. VBA to copy data from closed workbook to open workbook
    By Anil2007 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-27-2011, 12:30 PM

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