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.
Posted by Tom Urtis on January 11, 2002 8:40 AM
See if this works for you at the point in your macro when you need to select the sheet. Modify this line to suit the particular cell containing your spec #.
Remember also to cover yourself for a run time error if somehow the spec # cell will be blank or contain a value for which no sheet is named.
Sheets(Range("A1").Value).Select
HTH
Tom Urtis
