See
http://www.rondebruin.nl/copy2.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Eva" wrote in message ...
Hi
Thank you for your response, but it is not exactly what I want. There are
about 20 sheets and I was thinking about the macro, that copy the same
section in all sheets and paste it into master sheet.
--
Greatly appreciated
Eva


"ryguy7272" wrote:

Data Filter Auto Filter

Custom

Items Begin With...Summary by Customer Category
And
Items End with...TOTAL

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Eva" wrote:

Hi
I have number of sheets with some data. In all of them there is a sequence
of data starting:"Summary by Customer Category" and it ends :"TOTAL
STATEMENT".
It can be found in column A.
How I can copy this data from all of sheets and paste it into master sheet?

--
Greatly appreciated
Eva