+ Reply to Thread
Results 1 to 6 of 6

Want

  1. #1
    Forum Contributor
    Join Date
    07-10-2022
    Location
    USA
    MS-Off Ver
    2021
    Posts
    190

    Want

    Hi,

    I hav
    Last edited by rexcel548562; 08-07-2022 at 08:28 AM.

  2. #2
    Forum Contributor
    Join Date
    07-10-2022
    Location
    USA
    MS-Off Ver
    2021
    Posts
    190

    Re: Want to Copy from another Workbook File whenever Cell Formula Result Changes

    Hi, Can An
    Last edited by rexcel548562; 08-07-2022 at 08:29 AM.

  3. #3
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,513

    Re: Want to Copy from another Workbook File whenever Cell Formula Result Changes

    both worksheet event and macro code should be used.
    In the begining Cell C1 should be blnk. Then Column A and B will be copied.
    Worksheet event
    Please Login or Register  to view this content.
    Macro code
    Please Login or Register  to view this content.
    Worksheetevent

    How to use the code
    Right click on Sheet tab --> view code
    Visual Basic (VB) window opens.
    Paste the code
    Close the VB window.
    Save the file as .xlsm
    Attached Files Attached Files
    Last edited by kvsrinivasamurthy; 07-22-2022 at 04:06 AM.
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.

  4. #4
    Forum Contributor
    Join Date
    07-10-2022
    Location
    USA
    MS-Off Ver
    2021
    Posts
    190

    Re: Want to Copy from another Workbook File whenever Cell Formula Result Changes

    Hi Sir kvsrinivasamurthy,
    Last edited by rexcel548562; 08-07-2022 at 08:29 AM.

  5. #5
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,513

    Re: Want to Copy from another Workbook File whenever Cell Formula Result Changes

    Thanks for feedback and rep.

  6. #6
    Forum Contributor
    Join Date
    07-10-2022
    Location
    USA
    MS-Off Ver
    2021
    Posts
    190

    Re: Want to Copy from another Workbook File whenever Cell Formula Result Changes

    Hi Sir kvsrinivasamurthy,
    Last edited by rexcel548562; 08-07-2022 at 08:29 AM.

+ 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. Help with code to copy result of formula in a cell
    By Climber-Jutt in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-15-2021, 06:52 PM
  2. Copy filter data from Master workbook to Result workbook
    By Ajay45822 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-08-2021, 06:50 AM
  3. IF formula to copy cell value to a 2nd file workbook
    By old dawg in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-23-2016, 05:05 PM
  4. Copy result from cell with formula to empty cell
    By banyanman in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-02-2016, 06:49 PM
  5. Replies: 3
    Last Post: 07-11-2013, 03:01 AM
  6. Automatically save file with cell value + copy cell values to other workbook
    By notquitetheguru in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-10-2013, 07:04 AM
  7. [SOLVED] how do i copy a formula's result to another cell, without copying.
    By Mili in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-28-2005, 09:06 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