+ Reply to Thread
Results 1 to 2 of 2

How to transfer data to another workbook from specific cells only

  1. #1
    Registered User
    Join Date
    12-18-2017
    Location
    London, UK
    MS-Off Ver
    Excel 2016
    Posts
    1

    Smile How to transfer data to another workbook from specific cells only

    hello,

    I need to insert data from specific cells from an excel spreadsheet to another excel spreadsheet in specific columns? What is the easiest way to do this? Thanks, best wishes Claire

  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,093

    Re: How to transfer data to another workbook from specific cells only

    You could use VLOOKUP or INDEX/MATCH if you have unique key fields. If you don't have unique key fields, you can maybe use INDEx/ROW() to get data from all rows of specific columns.

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    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


+ 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. How to transfer specific data from one workbook to another using vba
    By Levinio in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-24-2016, 10:48 AM
  2. [SOLVED] How to transfer specific row of data from multiple workbooks to master workbook using VBA
    By rajeshntiwari in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-08-2014, 08:08 AM
  3. [SOLVED] Macro to transfer data to specific tabs on another workbook
    By 4lysaabri in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-12-2014, 11:13 PM
  4. Replies: 3
    Last Post: 02-21-2014, 09:05 AM
  5. [SOLVED] Copy Data from Range on Specific Worksheet and Transfer Data to New Workbook
    By s2jrchoi in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-22-2013, 08:24 AM
  6. Macros to transfer specific data from one workbook to another
    By Johnptry in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-10-2012, 02:04 PM
  7. VBA to transfer data to specific cells in another worksheet
    By SAsplin in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-24-2011, 10:28 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