View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ryguy7272 ryguy7272 is offline
external usenet poster
 
Posts: 2,836
Default Copy specific data form sheets into master sheet

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