Copy between worksheets...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If worksheet 1 has:
1 2 3
A Smith Travel 1 Mar 06
B Jones Off 1 Mar 06
C Smith Off 1 Jun 06
D Jones Travel 1 May 06

How do I copy the A1, A3, A5, A6, etc., and D1, D3, D5, D6, etc., to
worksheet 2, only if A2="Travel"?

(I realize the easy way would be to sort WS1 the Copy/Paste the appropriate
cells, but would like this to be automated)

Even better would be to populate a PowerPoint "Table", but will settle for
Excel!

Thanks in advance,

KSL
 
Apply autofilter to column 2 (usually called B) for values "Travel".
Highlight the displayed cells and copy them to another area of the
sheet - you can then delete the second column before copying to
Powerpoint.

Hope this helps.

Pete
 

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

Row references 1
Copy from worksheet 1 to worksheet 2, 3 , 4 etc.. 3
Text lookup array and match specific data 3
Calculating Sum with Multiple Field Criteria 2
Copy/Fill increments 8
How do I copy cells from one worksheet to another based on values 2
Empty Cells 5
Retrieving a field from another worksheet - with conditions... 3

Back
Top