LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 205
Default copy data with criteria

Hi!
i am trying to copy data of certains rows from 2 columns that match the
criteria choosen.i have 4 columns, ID, DATE, CUST, MOD.the criteria is for
DATE,but i want to copy column CUST & MOD to another worksheet.can it be done?
i've tried to use advanced filter,but it seems like copy DATE column
only,cannot copy CUST & MOD.
is there any other suggestion?
thanks in advance=)

--
Regards,
Linda
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy Row to worksheet based on criteria JoePineapples Excel Discussion (Misc queries) 1 March 7th 07 09:05 AM
Auto copy down depending on criteria Kim Excel Worksheet Functions 3 July 4th 06 12:53 PM
Copy DSUM Criteria Question Curtis Excel Worksheet Functions 1 February 14th 06 06:20 PM
copy rows meeting criteria to another worksheet confused Excel Worksheet Functions 4 October 4th 05 11:51 AM
under certain criteria copy data. dave Excel Worksheet Functions 2 November 16th 04 02:56 AM


All times are GMT +1. The time now is 10:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"