Activate another sheet based on value in a cell

graphage · Mar 12th, 2002, 10:21 AM

I have 2 workbooks. Workbook1 and Workbook2. Workbook1 contains 1 sheet. Workbook2 contains 5 sheets. My data in Workbook1 is copied via a macro...I want to paste it to a particular sheet in Workbook2 bases on the value in cell A1 of Workbook1. for example... Workbook2 contains 5 sheets each named after different cities; New York, Miami, Cleveland, etc. When my macro copies the data from Workbook1, based on the city name in cell A1, I want it to paste it to the corresponding sheet in workbook2. Does this make since??? It's kind of hard to type it out. Any suggestions would be appreciated...

[ This Message was edited by: graphage on 2002-03-12 12:06 ]

Ivan F Moala · Mar 15th, 2002, 12:59 AM

Try turning on your macro recorder.
See what code you get.

Then post what you have and what you
need to change.....Always a good idea to
use the macro recorder then alter code to suit.....

Post for further assistance.

Cheers

ivan

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

Mar 12th, 2002, 10:21 AM	#1
graphage Board Regular Join Date: Mar 2002 Posts: 69	I have 2 workbooks. Workbook1 and Workbook2. Workbook1 contains 1 sheet. Workbook2 contains 5 sheets. My data in Workbook1 is copied via a macro...I want to paste it to a particular sheet in Workbook2 bases on the value in cell A1 of Workbook1. for example... Workbook2 contains 5 sheets each named after different cities; New York, Miami, Cleveland, etc. When my macro copies the data from Workbook1, based on the city name in cell A1, I want it to paste it to the corresponding sheet in workbook2. Does this make since??? It's kind of hard to type it out. Any suggestions would be appreciated... [ This Message was edited by: graphage on 2002-03-12 12:06 ]

Mar 15th, 2002, 12:59 AM	#2
Ivan F Moala MrExcel MVP Join Date: Feb 2002 Location: Auckland, New Zealand Posts: 4,209	Try turning on your macro recorder. See what code you get. Then post what you have and what you need to change.....Always a good idea to use the macro recorder then alter code to suit..... Post for further assistance. Cheers ivan