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
This message was edited by graphage on 2002-03-12 12:06