Activate another sheet based on value in a cell

[graphage]

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]

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