View Single Post
  #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