MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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