LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 15th 16, 10:01 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
First recorded activity by ExcelBanter: Feb 2016
Posts: 7
Default Pivot table - Data Extract

please help me,
I cant attach files to clarify the issue

is there a way to list pivot table data to a normal sheet rows and columns

this is my daily work it took me 1 hour to finish it , but I think with a VB code it could be done on 1 minute.

I don't know if this could be done by formula.

I want to list specific rows and columns , not all.

for example if I filter the table I can copy the rows 5 and 6 to a different sheet in row 1 and 2
then filter again the vb code will copy the same rows to the same different sheet in row 3 and 4.

I do this manually every day to copy and past over 30 rows to new sheet.
please assist.

note that : there's multiple filter criteria.

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Extract pivot table raw data Han Qiao Excel Discussion (Misc queries) 2 October 17th 07 05:41 PM
Extract data from Pivot table with VBA [email protected] Excel Programming 0 January 24th 07 12:07 AM
HOW TO EXTRACT (or lookup) DATA FROM A PIVOT TABLE SSJ New Users to Excel 3 November 9th 06 09:46 PM
how do i extract data from pivot table to txt file stef Excel Discussion (Misc queries) 1 May 24th 06 06:29 PM
Extract Source Data From Pivot Table Luis Carrion Excel Programming 0 December 24th 04 12:29 AM

All times are GMT +1. The time now is 04:00 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017