Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
iserror, index & if
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
iserror, index & if
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 Is there a formula utilizing ISERROR, IDNEX and IF that you are having a problem with? If you posted that, along with a better description of what you are trying to accomplish, maybe someone could help. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
iserror, index & if
You need to give more details of the columns you are using. Presumably
one column will be used to determine which set of data that record belongs to (4, 7, 54 etc), but what other information will you want to copy across? Pete On Feb 16, 4:18*pm, 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
iserror, index & if
Sueellen1312 -
Can you just put references in the other worksheets so they always point to the cells on the first worksheet? -- Daryl S "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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
iserror, index & if
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
iserror | Excel Worksheet Functions | |||
iserror help | Excel Worksheet Functions | |||
ISERROR,SMALL,INDEX, MATCH, SMALL?? | Excel Discussion (Misc queries) | |||
use of ISERROR | Excel Worksheet Functions | |||
IF ISERROR | Excel Discussion (Misc queries) |