Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy between worksheets...
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy between worksheets...
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need macro to copy a list of named cells between worksheets | Excel Worksheet Functions | |||
using programming to copy worksheets data only | Excel Discussion (Misc queries) | |||
copy formats column width & row heights between Excel WORKSHEETS? | Excel Discussion (Misc queries) | |||
macro to copy into different worksheets | Excel Discussion (Misc queries) | |||
CREATE MACRO TO COPY MULTIPLE WORKSHEETS | Excel Discussion (Misc queries) |