Results 1 to 2 of 2

two workbooks.

This is a discussion on two workbooks. within the Excel Questions forums, part of the Question Forums category; Hi guys. I have two workbooks (W1 and W2), the first worksheets in both workbooks are identical,(WS1 and WS2), if ...

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Location
    iceland
    Posts
    138

    Default

    Hi guys.

    I have two workbooks (W1 and W2), the first worksheets in both workbooks are identical,(WS1 and WS2), if I fill out WS1 (it contains alot af data and simple formulas), how can I get WS2 automaticly.

    BK stulli

  2. #2
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701

    Default

    Kind of confused on your request. Do you just want to copy the first worksheet of workbook 1 to the first worksheet of workbook 2? If so, then try something like the following:
    Workbooks(1).Sheets("WS1").Copy Before:=Workbooks(2).Sheets(1)
    Best regards,
    Allan Chara
    http://www.mrspreadsheets.com

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com