Transfering to another sheet based on input
Posted by Donald on January 11, 2002 7:55 AM
I need to transfer data from an input sheet to a collection sheet based on a spec #.
On the input sheet, the spec is selected from a pull down list and test values are entered. I want to transfer those test values to collection sheets specific to the spec.
The input sheet works and the collection sheets work. I can transfer information using a macro and button to one sheet, but can't figure out how to make it select a worksheet based on a cell value. Any help in general or code would be appreciated.