Thread: Filtering of data in a master excel sheet from multiple sheets
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Khawajaanwar Khawajaanwar is offline
external usenet poster
  
Posts: 17
Default Filtering of data in a master excel sheet from multiple sheets
Dear Herbert Seidenberg, i this would not solve the problem or could not
understand the Pivot Table. As i only need to update the data in Sheet i.e.
all the rows of column A6 from sheet-2, sheet-3 & sheet-4 which exists on the
same worksheet.

"Herbert Seidenberg" wrote:

Excel 2007 Tables, PivotTable
Consolidate tabs.
Transpose column blocks to rows.
Sum with PT.
No formulas, code aplenty.
http://c0444202.cdn.cloudfiles.racks.../01_23_10.xlsm
.

Reply With QuoteReply With Quote