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

  • Thread starter Thread starter Jonzip
  • Start date Start date
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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy records that are 4 rows apart 5
How to use macros to copy a range of cells which can exclude some cells which I didn't want to be co 2
Highlighting cells with specified dates 2
How to count the occurrence? 3
How do I leave linked cells that do not contain a date 1
Copy cell contents, then paste into the same cell with other text. 6
I copied Visible Cells Only, but it pastes only the first cell 1
how do I use a cells from one worksheet in the equation of another 1

Back
Top