Formula

[Charity]

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.

 

[Guest]

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.

 

[Guest]

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.

 

[Charity]

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

 

[Myrna Larson]

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