Consulting

Results 1 to 1 of 1

Thread: Transfer worksheet to another workbook

  1. #1
    VBAX Newbie
    Joined
    Oct 2018
    Posts
    5
    Location

    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.

    Capture.PNG

    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.
    Edmond

Posting Permissions

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