two workbooks.

stone · May 21st, 2002, 12:37 PM

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 · May 21st, 2002, 03:24 PM

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)

May 21st, 2002, 03:24 PM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	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) __________________ Kind regards, Al Chara

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 21st, 2002, 12:37 PM	#1
stone Board Regular Join Date: Apr 2002 Location: iceland Posts: 138	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