Results 1 to 1 of 1

Thread: Transfer worksheet to another workbook

  1. #1
    VBAX Regular
    Oct 2018

    Transfer worksheet to another workbook

    Hi everyone,

    I built workbook1 with worksheet1 and worksheet2.
    Worksheet2 contains a lot of formulas linked to worksheet1.

    Now, I want to transfer my worksheet2 (with the formulas) on another workbook2.
    Workbook2 has worksheet1. So ideally, I would copy worksheet2 from workbook1 to workbook2 with the formulas adjusted with the new workbook2 and not the old workbook1.

    Workbook1= [20181105 OOR_DATA KB TEST.xlsx]
    And I want to delete this within all the cells.


    I tried with the find and replace function but it didn't work. Maybe with some VBA?

    I thank you in advance

    Edit: I deleted the links (DATE==>Edit Links) and it worked perfectly
    Last edited by Edmond; 11-07-2018 at 10:54 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts