Help with creating a formula
 

Here is what I'm trying to do. I have a woorkbook with 32 sheets in it 31 of
them are the same and will be as days of the month, the last sheet is used to
track commisions. I would like to be able to automate the process to move
the sold information from 5 different cells, meaning if there is anything in
those cells move the name information to the commision page. Please help!

Help with creating a formula
 

Summarised?

=SUMPRODUCT(N(INDIRECT(ROW(INDIRECT("1:31"))&"!A1" )))

or just referenced

=INDIRECT(COLUMN()&"!A1")

etc.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"jaysphotos" wrote in message
...
Here is what I'm trying to do. I have a woorkbook with 32 sheets in it 31
of
them are the same and will be as days of the month, the last sheet is used
to
track commisions. I would like to be able to automate the process to move
the sold information from 5 different cells, meaning if there is anything
in
those cells move the name information to the commision page. Please help!

Help with creating a formula
 

Bob,

Thanks for the help. Maybe I don't understand should I type just as you
have or do I make changes. It might be easier if I was able to get you a
screen shot contact jaysphotos@same .com

"Bob Phillips" wrote:

Summarised?

=SUMPRODUCT(N(INDIRECT(ROW(INDIRECT("1:31"))&"!A1" )))

or just referenced

=INDIRECT(COLUMN()&"!A1")

etc.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"jaysphotos" wrote in message
...
Here is what I'm trying to do. I have a woorkbook with 32 sheets in it 31
of
them are the same and will be as days of the month, the last sheet is used
to
track commisions. I would like to be able to automate the process to move
the sold information from 5 different cells, meaning if there is anything
in
those cells move the name information to the commision page. Please help!

Help with creating a formula
 

I think you should try giving more detail. I offered a couple of options as
it was not clear exactly what you were trying to do.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"jaysphotos" wrote in message
...
Bob,

Thanks for the help. Maybe I don't understand should I type just as you
have or do I make changes. It might be easier if I was able to get you a
screen shot contact jaysphotos@same .com

"Bob Phillips" wrote:

Summarised?

=SUMPRODUCT(N(INDIRECT(ROW(INDIRECT("1:31"))&"!A1" )))

or just referenced

=INDIRECT(COLUMN()&"!A1")

etc.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"jaysphotos" wrote in message
...
Here is what I'm trying to do. I have a woorkbook with 32 sheets in
it 31
of
them are the same and will be as days of the month, the last sheet is
used
to
track commisions. I would like to be able to automate the process to
move
the sold information from 5 different cells, meaning if there is
anything
in
those cells move the name information to the commision page. Please
help!