How can you copy selected cells when one cell contains a specified string?

J

Jonzip

Hi!
I need to paste selected cells into different worksheets.
The cells contain information like:

date, amount, category eg:
24/08/04, 590, eggs
25/08/04, 430, cheese

what I wanna do is copy date and amounts to eggs worksheet or cheese
worksheet, depending on whether category is eggs or cheese.
Is there a way to combine the IF function with a paste link, or something
like that?

Thanks a bundle in advance!
Jon.
 
F

Frank Stone

Formulas return a value to the cells in which they reside.
They cannot perform actions, such as copy,paste ect.
what you want is possible but you didn't not provide
enought information to give a viable solution.
 
Top