Not enough detail to even hazard a guess about iserror, index and if


Gord Dibben MS Excel MVP

On Tue, 16 Feb 2010 08:18:03 -0800, Sueellen1312
wrote:

I'm trying to design a workbook that has a front sheet where you input all
the information, then a function that will copy it to relevant worksheet
within the workbook ie 4,7, etc etc, but there will be multiple information
on the front sheet to copy to the relevant sheet.
Sheet 1 INput
Sheet 2 4
Sheet 3 7
sheet 4 54 & so on