Thank but i need each customer in a seperate sheet i am looking for Macro ,
bcz i have more then 2000 rows

"Jacob Skaria" wrote:

Not sure whether this is what you are looking for. Suppose you have Sheet1 to
Sheet5; and you want to copy the customers listed in Col A of Sheet1 to all
other sheets.

--Select Sheet1 Column A. (Click on the column header to select) and Right
click 'Copy'
--Select Sheet2 and holding shift key select the last sheet (This will
select sheet2 to sheet5)
--Select cell A1 and Right clickPasteSpecialValuesOK...






If this post helps click Yes
---------------
Jacob Skaria


"osaka78" wrote:

i have the following data in Sheet 1
Customer A
1
2
3

Customer B
1
2
3

i want to copy each customer to different sheet