LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
tacarme
 
Posts: n/a
Default Copying selected rows to another sheet


hi friends. I am a newby of excel ( and idem for my english !!!)

Need some help, please.

I have a very big spreadsheet with hundreds of row of customer data.

In the first column starting from column A2 is inserted the customer
code.

After a put a customer code in cell A1. I need :
- to filter all those rows and copy the selection in a second sheet
- and clear the second sheet ONLY every time I change A1 on the first
sheet.

Any help is really appreciated.

Many thanks.
Domenico.


--
tacarme
------------------------------------------------------------------------
tacarme's Profile: http://www.excelforum.com/member.php...o&userid=24453
View this thread: http://www.excelforum.com/showthread...hreadid=380490

 
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
Questions on copying from one sheet to the other and coping every other cell. KatyLady Excel Discussion (Misc queries) 10 June 7th 05 08:29 AM
I want to sort selected cells in Excel, not entire rows. Aeryn635 Excel Discussion (Misc queries) 1 June 1st 05 07:58 PM
Copying whole rows based upon one criteria kirbster1973 Excel Discussion (Misc queries) 2 May 26th 05 10:00 PM
How do I stop an Excel sheet from automatically hiding rows when . kazyreed Excel Worksheet Functions 1 February 3rd 05 03:35 PM
Adding Rows to Master Sheet Excel Newbie New Users to Excel 1 December 23rd 04 10:56 PM


All times are GMT +1. The time now is 01:57 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"