Prev: emailing from excel 2003 thru outlook 2007 is not being recieved
Next: subtotal, match?
From: Sueellen1312 on 16 Feb 2010 11:18
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
From: Glenn on 16 Feb 2010 11:35
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.
From: Pete_UK on 16 Feb 2010 11:36
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
<Sueellen1...(a)discussions.microsoft.com> 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

From: Daryl S on 16 Feb 2010 11:56
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
From: Gord Dibben on 16 Feb 2010 12:13
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
<Sueellen1312(a)discussions.microsoft.com> 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

 | 
Pages: 1
Prev: emailing from excel 2003 thru outlook 2007 is not being recieved
Next: subtotal, match?