two workbooks.

[stone]

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

 

[Al Chara]

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)