+ Reply to Thread
Results 1 to 5 of 5

Copy and update the data in excel sheet to another workbook

  1. #1
    Registered User
    Join Date
    06-17-2014
    Location
    Male'
    MS-Off Ver
    Office 2010
    Posts
    31

    Copy and update the data in excel sheet to another workbook

    Hi.

    I have some data in an excel sheet. i want to copy the same data to another sheet in another workbook and these data should update as i update the original sheet.
    Any help is appreciated.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,603

    Re: Copy and update the data in excel sheet to another workbook

    Perhaps =Sheet1!A1 ?

  3. #3
    Registered User
    Join Date
    06-17-2014
    Location
    Male'
    MS-Off Ver
    Office 2010
    Posts
    31

    Re: Copy and update the data in excel sheet to another workbook

    i want the whole sheet to be copied to another workbook and updated

  4. #4
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,276

    Re: Copy and update the data in excel sheet to another workbook

    As per #2 post copy paste formula across as per data record.


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  5. #5
    Registered User
    Join Date
    06-17-2014
    Location
    Male'
    MS-Off Ver
    Office 2010
    Posts
    31

    Re: Copy and update the data in excel sheet to another workbook

    what if my sheet has huge data on it. it will be very difficult to create a formula for each cell.

+ 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. VBA to compare and update data on Master Sheet/workbook from another Sheet/workbook
    By Lee_of_Excel in forum Excel Programming / VBA / Macros
    Replies: 25
    Last Post: 08-12-2020, 08:19 AM
  2. Can VBA copy data from an Excel Sheet to a *.csv workbook which is not open?
    By Elijah in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-27-2019, 04:15 PM
  3. Copy multiple columns to sheet on closed workbook, and update back
    By nordicdust in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-12-2018, 10:34 AM
  4. [SOLVED] Copy all data from an Excel sheet in a different workbook to a blank sheet in current WB
    By drjarmin in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 12-27-2017, 02:24 AM
  5. [SOLVED] Copy Sheet to Same Workbook but Update Hyperlinks to New Sheet Name
    By KlementM in forum Excel General
    Replies: 2
    Last Post: 07-06-2017, 02:38 AM
  6. Trying to copy data from multiple sheets to a new sheet in 1 workbook (EXCEL 2010)
    By maurerma in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-17-2014, 12:28 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