+ Reply to Thread
Results 1 to 3 of 3

Merging new worksheet into old one whilst keeping data

  1. #1
    Forum Contributor
    Join Date
    11-26-2008
    Location
    UK
    MS-Off Ver
    Using Excel 2019
    Posts
    317

    Merging new worksheet into old one whilst keeping data

    I have updated an old workbook with new (amended) formulas and saved it as a new file. Id like to merge the data present in the old workbook into the new workbook. I could copy and paste it, but ideally id like to merge the two together.

    Is there anyway of doing this?

  2. #2
    Valued Forum Contributor Blake 7's Avatar
    Join Date
    10-01-2010
    Location
    Bogota, Colombia
    MS-Off Ver
    Excel 2010 64 bit and Excel 2007,
    Posts
    1,377

    Re: Merging new worksheet into old one whilst keeping data

    there are various ways and means of achieving this depending on your data and the set up ect. Why dont you upload a sample? create one workbook containing old data new data and how u want the merged data to appear.
    Blake 7

    If your question has been answered, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

    If any member's response has helped to solve your problem, please consider using the scales icon on the top right of their post to show your appreciation.

    http://failblog.org/

  3. #3
    Forum Contributor
    Join Date
    11-26-2008
    Location
    UK
    MS-Off Ver
    Using Excel 2019
    Posts
    317

    Re: Merging new worksheet into old one whilst keeping data

    hi, ill knock up an example, i cat upload the original as its a work file and would require too much editing.

    Ta

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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