Formula
 

I am trying to see if it is possible to create a formula that will copy a
certain row to another worksheet with a letter or number indicator in the A
column of that row. For example: If the is the letter A in the first cell
of the row then that row needs to be copied to the worksheet tab labeled A.

hi,
formula can only return a value. they cannot perform an
action like copy. you would have to use a macro for this.
If you would more info post back.

-----Original Message-----
I am trying to see if it is possible to create a formula
that will copy a
certain row to another worksheet with a letter or number
indicator in the A
column of that row. For example: If the is the letter A
in the first cell
of the row then that row needs to be copied to the
worksheet tab labeled A.
.

hi,
formula can only return a value. they cannot perform an
action like copy. you would have to use a macro for this.
If you would more info post back.

-----Original Message-----
I am trying to see if it is possible to create a formula
that will copy a
certain row to another worksheet with a letter or number
indicator in the A
column of that row. For example: If the is the letter A
in the first cell
of the row then that row needs to be copied to the
worksheet tab labeled A.
.

Ok. Do you have the time to explain to me how I can create a macro?

" wrote:

hi,
formula can only return a value. they cannot perform an
action like copy. you would have to use a macro for this.
If you would more info post back.

-----Original Message-----
I am trying to see if it is possible to create a formula
that will copy a
certain row to another worksheet with a letter or number
indicator in the A
column of that row. For example: If the is the letter A
in the first cell
of the row then that row needs to be copied to the
worksheet tab labeled A.
.

Try reading through the available posts in the Programming newsgroup. There's
no 2-line (or 50-line) answer to your question.

On Wed, 9 Feb 2005 11:49:05 -0800, "Charity"
wrote:

Ok. Do you have the time to explain to me how I can create a macro?

" wrote:

hi,
formula can only return a value. they cannot perform an
action like copy. you would have to use a macro for this.
If you would more info post back.

-----Original Message-----
I am trying to see if it is possible to create a formula
that will copy a
certain row to another worksheet with a letter or number
indicator in the A
column of that row. For example: If the is the letter A
in the first cell
of the row then that row needs to be copied to the
worksheet tab labeled A.
.