+ Reply to Thread
Results 1 to 3 of 3

Is it possible in Excel to copy cell contents from one Excel file to another?

  1. 02-01-2019, 06:50 PM #1
    RustyNail
    RustyNail is offline
    Forum Contributor
    Join Date
    03-07-2013
    Location
    Montreal
    MS-Off Ver
    Excel 2007
    Posts
    274

    Is it possible in Excel to copy cell contents from one Excel file to another?

    Hello,

    I have two excel files on my hard disk.

    I would like to click on a button that is in one excel file and through VBA I copy the contents of a cell and store it in another cell on
    the other excel file!

    Is this possible?

    Thank you all for your feedback

    rn
    Reply With QuoteRegister To Reply
  2. 02-01-2019, 08:45 PM #2
    TMS
    TMS is offline
    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,447

    Re: Is it possible in Excel to copy cell contents from one Excel file to another?

    Yes. Record a macro while you copy a cell, select another workbook, sheet and cell, and paste the data.
    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 With QuoteRegister To Reply
  3. 02-02-2019, 05:52 AM #3
    banaanas
    banaanas is offline
    Forum Contributor banaanas's Avatar
    Join Date
    08-26-2014
    Location
    Finland
    MS-Off Ver
    2016
    Posts
    199

    Re: Is it possible in Excel to copy cell contents from one Excel file to another?

    See attached workbook, or copy this code and assing it to a button 

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Create new Word file then Copy table and contents from Excel to that Word file
    By sbv1986 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-23-2018, 09:14 AM
  2. excel to Copy contents of Htm file
    By Mr.India in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-10-2018, 07:55 AM
  3. Open PDF File and Copy Contents as is in Excel
    By karan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-02-2016, 05:34 AM
  4. Automatically Copy contents from One column of One excel file to Another excel file
    By sarabjit in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-22-2014, 08:11 PM
  5. How to copy a cell from a closed excel file to another open excel file
    By anup_keshri in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-22-2013, 08:48 AM
  6. VBA create txt file from cell contents on Excel 2011 (Mac) VBA
    By lw5182 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-10-2013, 07:07 AM
  7. [SOLVED] Code to open another excel file, file name depending on cell contents
    By L-Drr in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-02-2013, 11:09 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1